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

Baltimore, Maryland, Virginia, Washington D.C., & On-Site at Your Location

Print this Page
Course Information & Why You Should Attend

ThinkB!G Exclusive LogoDuration & 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.
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 Print and/or Digital Courseware & Personal Use of Class Recording for Limited Time
  • Certificate of Completion
  • Computer (Apple Mac or Windows PC) with Software & Class Files (In Person Only)
  • 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

Dates to Register!

 

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!

Click to Get a Quote Now!

Dates to Register

CourseLocationStart DateEnd DateTime
Power BI - Intro

ThinkB!G (Columbia, MD) - In Person Only

Monday, Feb 03, 2020 Tuesday, Feb 04, 2020 8:30 am EDT - 3:00 pm EDT Register
Power BI - Intro

ThinkB!G (Columbia, MD) - In Person Only

Wednesday, Apr 15, 2020 Thursday, Apr 16, 2020 8:30 am EDT - 3:00 pm EDT Register
Power BI - Intro

ThinkB!G (Columbia, MD) - In Person Only

Wednesday, Jun 10, 2020 Thursday, Jun 11, 2020 8:30 am EDT - 3:00 pm EDT Register
Power BI - Intro

ThinkB!G (Columbia, MD) - In Person Only

Wednesday, Aug 12, 2020 Thursday, Aug 13, 2020 8:30 am EDT - 3:00 pm EDT Register
Power BI - Intro

ThinkB!G (Columbia, MD) - In Person Only

Thursday, Nov 12, 2020 Friday, Nov 13, 2020 8:30 am EDT - 3:00 pm EDT 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 Print and/or Digital 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! 

Click to Get a Quote Now!

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.