Microsoft Power BI Introduction Live Hands-On Instructor-Led Training Class
Baltimore, Maryland, Virginia, Washington D.C., & On-Site at Your Location
Course Information & Why You Should Attend
Duration & Times: 2 Days – 8:30AM-3:00PM ET / 5:30AM-12:00PM PT (30 Minute Complimentary Lunch)
Locations for Training:
In Person at ThinkB!G in Columbia, Maryland near Baltimore, Washington D.C., Virginia region.
Virtually Online Live (VOLT) From Anywhere! Students Join the Same In Person Class Remotely.
Upon Request: Onsite Custom Private Training at Your Location!
Course Description: In this hands-on, two-day Microsoft Power BI Introduction class, you will work to become familiar with Power BI and be introduced to basic relational data concepts and work with relationships between tables in your data. This course will cover working with reports and visualizations, creating reports that connect to data and visuals, shape and transform data with queries, and model data with DAX functions.
Prerequisites: Students must have a good working knowledge of computers, operating systems, using a mouse, keyboard, standard menus and commands. Students must be able to open, save, and close applications, files, as well as navigate to other folders.
Job Roles That Use Power BI:
Data Architects
Data/Business Analysts
Developers
Uses for Power BI:
Data Analytics & Trends
Data Visualization
Microsoft Power BI Introduction Course Outline
1. Power BI Overview
What Is Power BI?
Power BI Desktop
Power BI Working Environment
Startup Screen
The Ribbon
Views
Overview of Relational Database Concepts
Preview Features
2. Working with Power BI Reports and Visualizations
Power BI Reports
Connecting to Data
Report Templates
Interacting with Visualizations
Focus Mode
Sorting and Filtering
Natural Language Queries
Date Hierarchies
Date Tables
Drilling in Reports/Dashboards
3. Creating Reports
Using Power BI to Create a Report
Report Creating and Publishing Overview
Connecting to Data
Supported Data Sources
Refreshing Data
Creating and Formatting Visualizations
Adding Visualizations
Formatting Visualizations
Conditional Formatting
Filtering with Report/Page/Visual-level Filters
4. Shaping and Transforming Data with Queries
What Is a Query?
Introduction to the Query Editor
Transform tab
What can I do in the Query Editor?
Applying query actions
Common Actions in the Query Editor
Use Dropdowns to Sort and Filter
Apply the correct Data Types
Apply a Filter or Sort Order
Replace Values
Remove What You Don’t Need
Make the Data “Human Friendly”
Combine Two or More Columns Into a New Column
Group Column Values
Applied Steps
Advanced Editor
5. Modeling Data
Creating Measures and Calculated Columns
Measures and Calculated Columns
Aggregations
Moving a Measure
Quick Measures
Using DAX
Introduction to Data Analysis Expressions (DAX)
DAX Syntax
The Matrix Visualization
DAX Functions
Disclaimer: All course objectives and outlines are used as a guideline and are subject to change to ensure the latest information is covered to support real world use of the technology.
Software Versions: ThinkB!G open enrollment classes are taught on the most current version of software whenever possible. To request a specific version, please Contact Us or call us at 301-362-2250.
What You Get
- Hands-On Official Authorized Training & Certification
- Training Delivered from Instructors that are Senior Consultants Certified by Adobe (ACI), Apple (ACT), & Microsoft (MCT)
- Official Curriculum Courseware & Personal Use of Class Recording for Limited Time
- Certificate of Completion
- Computer with Software & Class Files for Use During Training (Online Live Students can LOG ON to ThinkB!G Computers for No Installs)
- Continental Breakfast Every Day (In Person Only)
- Catered Gourmet Deli Lunch Every Day (In Person Only)
- Unlimited Snacks and Refreshments (In Person Only)
- Notebook & Pen (In Person Only)
- Free Parking (In Person Only)
Pricing
Public Enrollment Training
Commercial Price Per Person 2-Day Class: $795
GSA/Government Price Per Person 2-Day Class: $640.81
Non-Profit/Education Price Per Person 2-Day Class: $745
Custom Private Training – Onsite at Your Location, Online Live, or at ThinkB!G
Submit details and a formal training quote will be sent to you!
Dates to Register
Course | Location | Start Date | End Date | Time | |
---|---|---|---|---|---|
Power BI - Intro (Online Live ONLY)
Power BI - Intro (Online Live ONLY)
More Details.
">
Think BIG. Learn Smart
https://thinkbiglearnsmart.com
|
ThinkB!G - Online Live ONLY (NOT Self-Paced) |
Monday, Apr 12, 2021 | Tuesday, Apr 13, 2021 | 8:30 am - 3:00 pm | Register |
Power BI - Intro (Online Live ONLY)
Power BI - Intro (Online Live ONLY)
More Details.
">
Think BIG. Learn Smart
https://thinkbiglearnsmart.com
|
ThinkB!G - Online Live ONLY (NOT Self-Paced) |
Wednesday, Jun 09, 2021 | Thursday, Jun 10, 2021 | 8:30 am - 3:00 pm | Register |
Power BI - Intro (Online Live ONLY)
Power BI - Intro (Online Live ONLY)
More Details.
">
Think BIG. Learn Smart
https://thinkbiglearnsmart.com
|
ThinkB!G - Online Live ONLY (NOT Self-Paced) |
Monday, Aug 09, 2021 | Tuesday, Aug 10, 2021 | 8:30 am - 3:00 pm | Register |
Power BI - Intro (Online Live ONLY)
Power BI - Intro (Online Live ONLY)
More Details.
">
Think BIG. Learn Smart
https://thinkbiglearnsmart.com
|
ThinkB!G - Online Live ONLY (NOT Self-Paced) |
Monday, Nov 15, 2021 | Tuesday, Nov 16, 2021 | 8:30 am - 3:00 pm | Register |
Custom Private Training
We offer this course as Custom Private Training or Project Based Training®!
If you have a team of individuals, you can receive bulk discounts by doing your own Private training session & cover your specific learning objectives! We can have the Private Training at ThinkB!G in Columbia, Maryland, Virtually Online Live (Available for Most Courses), or Onsite at Your Location.
What's Included?
- Custom Outline to include Targeted Topics Based on Your Learning Needs
- Hands-On Official Authorized Training & Certification
- Training Delivered from Instructors that are Senior Consultants Certified by Adobe (ACI), Apple (ACT), & Microsoft (MCT)
- Official Curriculum Courseware
- Certificate of Completion
- Computer (Apple Mac or Windows PC) with Software & Class Files (In Person Only at ThinkB!G)
- Continental Breakfast Every Day (In Person Only at ThinkB!G)
- Catered Gourmet Deli Lunch Every Day (In Person Only at ThinkB!G)
- Unlimited Snacks and Refreshments (In Person Only at ThinkB!G)
- Notebook & Pen (In Person Only)
- Free Parking (In Person Only at ThinkB!G)
Submit details and a formal training quote will be sent to you!
Policies
Payment Policy for Public Enrollment Classes
Payment and/or Purchase Order is required 16 Business Days (Monday-Friday) prior to first date of training class.
Payment Policy for Private & Project Based Training® Classes
Payment and/or Purchase Order is required 16 Business Days (Monday-Friday) prior to first date of training service. Pricing provided is firm fixed price based on number of students. Client is responsible for entire amount regardless of change in number of registrations.
Cancellation/Rescheduling Policy for Public Enrollment Classes
- Classes may be canceled if less than 4 students are registered. We will notify you of cancellations no later than 16 business days prior to class.
- Canceling/Rescheduling more than 16 business days prior to class: You are eligible for a refund or free reschedule. Registration is transferable to another student for the same class & date.
- Canceling/Rescheduling less than 16 business days prior to class: No refund. No Reschedule. Registration is transferable to another student for the same class & date.
- No Shows without contact: No refund. No Reschedule.
Cancellation/Rescheduling Policy for Custom/Private and On-Site Training Classes
- No penalty if cancellation/reschedule is 16 Business Days (Monday-Friday) prior to the first date of class.
- 50% penalty will be incurred if cancellation/reschedule is less than 16 Business Days (Monday-Friday) prior to the first date of class. This fee is to cover instructor expenses, travel, and course materials purchased.
Cancellation/Rescheduling Policy for Individual Students in Custom/Private Training Classes
- Individual students registered in a private class, who cancel or do not show, are not eligible for a partial refund or reschedule. Please contact your class organizer or manager if you need to cancel.