Microsoft Power BI Introduction Live Hands-On Instructor-Led Training Class

Virtual Online Live Training (VOLT™) Access from Anywhere

Print this Page
Outline & Course Information

ThinkB!G Exclusive LogoDuration & Times: 2 Days – 8:30AM-3:00PM EST

Locations for Training:

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.

Required Technical Set-Up:
• Primary computer connected to a second monitor OR second computer to view instructor live
• Reliable High-speed internet connection
• Web Browser: Google Chrome Preferred (Alternative: Microsoft Edge)
• 3-Button Computer mouse
• Audio Speaker/Microphone (built-in to computer or external)

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. Introduction to Power BI
• What is Power BI Desktop?
• What is Power BI Service?
• Starting and logging in to Power BI
• Examining the Power BI Desktop environment:
– The ribbon
– Views
– Panes
– Pages

2. Creating Reports and Visualizations
• Creating reports
• Connecting to single or multiple data sources
• Working in the Model view to connect tables with shared key fields
• Changing a data source
• Report templates

3. Creating Visualizations
• Adding visualizations to reports (Pie chart, Column chart, Card, Matrix, etc.)
• Using Focus mode
• Formatting visualizations

4. Filtering Visualizations
• Using visuals to filter other visuals
• Filter using slicers
• Turning filters between visuals off
• Applying filtering to individual visuals
• Applying page and report filters
• Controlling measure filtering with DAX

5. Interacting with Visualizations
• Sorting and filtering data
• Using Drill features with hierarchies
• Working with date hierarchies
• Creating custom hierarchies

6. Shaping and Transforming Data
• Filtering data with the Power Query editor
• Changing data types in Data View and the Power Query editor
• Preparing data for Power BI in Excel
• Transforming data with the Power Query editor including removing rows and columns, replacing data, splitting or combining data, merging, appending, and unpivoting data
• Using Applied Steps
• Using the Advanced Editor
• Refreshing data
• Creating Groups
• Creating tables in Power BI

7. Modeling Data
• The differences between custom columns and measures
• Introduction to Data Analysis Expressions (DAX) and DAX functions
• DAX References
• Core DAX Functions
• Time Intelligence Functions
• Concatenating with DAX
• Using the Query Editor tools and M to create calculated columns
• Using DAX to create custom columns
• Creating measures with DAX
• Using measures in Card and other visualizations
• Quick Measures
• Moving Measures between tables

8. Publishing Reports to the Power BI Service / Office 365
• Publishing a report to the Power BI Service
• Editing a report in the Power BI Service
• Creating a Dashboard
• Using Natural Language Querying in a Dashboard
• Adding an “Ask a question” visual to a report
• Creating a Dashboard phone view

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
  • Instructor Led Hands-On Virtual Online Live Training (VOLT™) & Certification
  • Training Delivered from Certified Instructors that are Senior Consultants
  • Digital Official Curriculum Courseware (Not Used During Class) & Personal Use of Class Recording for Limited Time
  • Certificate of Completion
  • Remote Access to ThinkB!G Class Computer with Software licenses & Class Files Pre-Installed for Use During Training--No Installs or Downloads
  • Instructor's Real-Time View of ThinkB!G Class Computer Screen for Immediate Live Interactive Support
  • If Certification Training is Selected, It May Include a Test Prep Tool, Testing Voucher with Free Retake, and Proctor Fee (if taken with ThinkB!G Virtually)
  • Note: IT Support is Available to Pre-Flight Virtual Class Set Up Before & During Training
Pricing

Public Enrollment Training Pricing

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


Need Private Custom Training for Your Team?

Request a Quote

Dates to Register

We have instructors ready to teach this class, but we do not currently offer it on our Public Enrollment Training Calendar. If you are interested in this class, please fill out the form below and we will contact you shortly about your training options!


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!

What's Included?

  • Custom Outline to include Targeted Topics Based on Your Learning Needs
  • Instructor Led Hands-On Virtual Online Live Training (VOLT™) & Certification
  • Training Delivered from Certified Instructors that are Senior Consultants
  • Official Curriculum Courseware & Personal Use of Class Recording for Limited Time
  • Certificate of Completion
  • Remote Access to ThinkB!G Class Computer with Software licenses & Class Files Pre-Installed for Use During Training--No Installs or Downloads
  • Instructor's Real-Time View of ThinkB!G Class Computer Screen for Immediate Live Interactive Support
  • If Certification Training is Selected, It May Include a Test Prep Tool, Testing Voucher with Free Retake, and Proctor Fee (if taken with ThinkB!G Virtually)
  • Note: IT Support is Available to Pre-Flight Virtual Class Set Up Before & During Training

Submit details and a formal training quote will be sent to you!

Request a Quote

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. Registration is transferable to another student. Please contact your class organizer or manager if you need to cancel. 
Reviews

Average Review: 5 out of 5 - 8 Reviews

Department of Defense DOD Logo
The Instructor Was Very Knowledgeable!
The training was very good, and the instructor was very knowledgeable and helpful. -DOD, Rosaria (Microsoft Power BI Introduction Live Hands-On Instructor-Led Training Class)
Department of Defense DOD Logo
Virtual Classroom Setup is Very Pleasant!
The virtual classroom setup experience is very pleasant! -DOD, David (Microsoft Power BI Introduction Live Hands-On Instructor-Led Training Class)
Clear Instructions & Lots of Examples!
The instructor provided clear instructions and gave lots of examples. Good training. -FBI, Caitlin (Microsoft Power BI Introduction Live Hands-On Instructor-Led Training Class)
Learned New Skills & Information!
Very Good Course - Learned New Skills & Information -FBI, Beatrice (Microsoft Power BI Introduction Live Hands-On Instructor-Led Training Class)
Boland Logo
Very thorough introduction to Power BI
"Very thorough introduction to Power BI. Now the real learning occurs by using it." - Jerry, Boland (Microsoft Power BI Intro)
Boland Logo
Warm, Cozy, & Broad Base!
"The quality of content and instruction was warm and cozy. The instructor was able to cover a broad base of different levels of intellect very well." - Barry S., Boland (Microsoft Power BI Training)
Microsoft Power BI Logo
Instructor Did Well at Breaking Down the Steps!
"[The Instructor] did very well at explaining the concepts and breaking down the steps. Training material will be helpful to look at more in depth after." - Joe C. - Johns Hopkins APL (Microsoft Power BI Course)
Johns Hopkins Applied Physics Lab JHUAPL Logo
This Tool Makes It Easy to Visualize Data in Graphs & Charts!
"I really liked this Power BI Class! I didn't know this tool existed and it makes it easy to visualize data in graphs and charts. I was able to easily manipulate the data and see what I wanted to see very well." Lauren P. - Johns Hopkins APL (Microsoft Power BI Training)