Power BI Bootcamp
- Format
- Live or Self-paced
Choose how you learn
Compare formats, then explore the details for your choice.
Book directly on nobledesktop.com. Opens in a new tab.
Book live on Noble DesktopSummary
Power BI is well known as an industry leader for streamlining the process from data to insights. This fully featured app enables you to build interactive data visualizations such as charts, graphs, maps, and other useful ways to visualize your data to make it both informative and visually appealing. Power BI is a robust tool, giving you control over the look and feel of your visualizations to create dynamic reports and dashboards.
In this training, you’ll learn to import data from various sources (such as Excel Worksheets, Text/CSV, and more), transforming the data using Power Query, and then turning it into visualizations. You’ll explore, structure, analyze, and filter the data to create useful reports and dashboards. Aggregate the data (using functions like SUM and COUNT) to gain insights. You’ll also begin to learn about Power BI’s DAX language, which powers its data calculations and more.
Curriculum
What you'll learn
- Import data from Excel worksheets, CSV, and many more
- Transform/clean your data using Power Query
- Create interactive visualizations, such as charts, maps, cards, and slicers, to explore trends and patterns
- Use DAX (Data Analysis Expressions) to build measures, calculated columns, and custom aggregations
- Design visually engaging reports by adding titles, logos, and formatting options for a professional finish
- Understand and manage relationships between tables to create dynamic, filterable reports
- Share and collaborate on reports via the Power BI Service
- Set up dashboards and explore the differences between dashboards and reports for business presentations
- Schedule data refreshes and manage reusable datasets to keep reports up-to-date and scalable
Course syllabus
Level 1
Introduction to Power BI
- Why Use Power BI?
- Power BI Desktop
- Power BI Pro vs. Free
- Explanation of ETL process (Extract, Transform, Load)
- Data Types
Creating a Visualization
- Importing Data
- Choosing different types of data visualizations (column charts, bar charts, pie charts, donut charts, and more)
- Cleaning Up the Appearance: Axis Labels, Display Units, Title, and more
- Adding Data Labels
- Card Visuals
Publishing & Sharing
- Publishing Reports (to app.powerbi.com)
- Sharing Reports
- Collaborate on Reports with Comments
- Adding a Power BI report to PowerPoint
- Workspaces: What are they, publishing to the appropriate workspace, and creating/managing
- Exporting a PDF
Links to Data Source Files
- How Power BI Links to Data Files
- Managing Links to Data Source Files
Extracting & Transforming Data
- Extracting data from various sources: Text/CSV files, Excel worksheets, Multiple Files in a Folder, and more
-
Transforming data using the Power Query Editor:
ETL = Extract, Transform, Load
ELT = Extract, Load, Transform
Data Transformations
- Use First Row as Headers
- Remove Empty rows (null data)
- Split Column By Delimiter
- Applied Steps
- Merge Queries
- Append Queries
- Fill Down
- Transpose
- Pivot
- Column profiling for data quality check
- Query Dependencies
Relationships
- Relationship importance
- Understanding types of relationship
- Creating relationships
- Cross filter relation: Single or Both
Building/Design a Report
- Adding a Title
- Adding a Logo
- Adding a Background (Solid Color or Photo)
Measures
- Create Measures
- Using Measures in a Data Visualization
Calculated Columns
- Using DAX to create a Calculated Column
- Navigating Related Tables using DAX
Slicers
- What Slicers Are
- Adding & Using a Slicer
Level 2
Filters
- Adding Filters
- Adjusting Filter settings
Intro to DAX: Data Analysis Expressions
- SUM vs SUMX
- CONCATENATEX
- COUNT vs COUNTX
Quick Measures
- YTD (Year-to-Date)
- Year-over-year-change
Map Visuals
- Creating and Customizing a Map Visual
Drill Down & Drill Through
- How to use Drill Down
- How to use Drill Through
- How Drill Down differs from Drill Through
Getting Data from Online Spreadsheets
- Getting Data from a Google Sheet
- Getting Data from Excel File Stored in OneDrive
Refreshing Data
- How Datasets work in the Power BI Service
- Manually Refreshing or Scheduled Refresh
Reusable Power BI Datasets
- About Reusable Power BI Datasets
- Creating & Using Power BI Datasets
Dashboards
- Dashboards vs Reports
- Creating a Dashboard
What's included
- Free course retake within one year to refresh the material and gain practice.
- Course workbook
- Class recordings
Stated by the provider. Confirm what your tuition covers before enrolling.
Live classes
Choose dates and book your instructor-led class on nobledesktop.com.
-
–
In-person or live online · Full
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
–
In-person or live online
Starts at 10:00 · America/New_York (EST); final session ends at 17:00 EST
-
–
In-person or live online
Starts at 10:00 · America/New_York (EST); final session ends at 17:00 EST
-
–
In-person or live online
Starts at 10:00 · America/New_York (EST); final session ends at 17:00 EST
-
–
In-person or live online
Starts at 10:00 · America/New_York (EST); final session ends at 17:00 EST
-
–
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
–
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
–
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
–
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
–
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
–
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
–
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
–
In-person or live online
Starts at 10:00 · America/New_York (EST); final session ends at 17:00 EST
Confirm current dates and availability on Noble Desktop before booking.
Self-paced course
Learn through recorded lessons on your own schedule.
This course is available for 30 days. You can choose when to start your access period. Once you activate, you will have 30 days to complete it (access the course materials, quizzes, projects and videos). You may request one extension of seven (7) days. Other extension requests will be evaluated on a case-by-case basis. Videos are not downloadable.
- Tuition
- $799
- Course length
- 12 hours
- Schedule
- On your schedule
Power BI is a leading platform designed to streamline the journey from data to insights. This powerful tool allows you to create interactive data visualizations, including charts, graphs, maps, and dashboards—that are both visually engaging and analytically meaningful. With full control over the look and functionality of your reports, Power BI helps transform complex datasets into clear, dynamic visuals.
In this hands-on course, you’ll learn to import data from multiple sources—including Excel, Text/CSV, and SQL—using Power Query. You’ll explore, structure, and filter data, apply aggregation functions such as SUM, COUNT, and MIN/MAX, and build visualizations that highlight key insights. You’ll also be introduced to Power BI’s DAX language, which enables advanced calculations and customized data modeling for deeper analysis.
Self-paced curriculum
What you'll learn self-paced
- Import and clean data from multiple sources, including Excel, CSV, and online databases, using Power Query
- Create interactive visualizations, such as charts, maps, cards, and slicers, to explore trends and patterns
- Use DAX (Data Analysis Expressions) to build measures, calculated columns, and custom aggregations
- Design visually engaging reports by adding titles, logos, and formatting options for a professional finish
- Understand and manage relationships between tables to create dynamic, filterable reports
- Share and collaborate on reports via the Power BI Service, including exporting, commenting, and app integration
- Set up dashboards and explore the differences between dashboards and reports for business presentations
- Schedule data refreshes and manage reusable datasets to keep reports up-to-date and scalable
Self-paced syllabus
Level 1
Introduction to Power BI
- Why Use Power BI?
- Power BI Desktop
- Power BI Pro vs. Free
- Explanation of ETL process (Extract, Transform, Load)
- Data Types
Creating a Visualization
- Importing Data
- Choosing different types of data visualizations (column charts, bar charts, pie charts, donut charts, and more)
- Cleaning Up the Appearance: Axis Labels, Display Units, Title, and more
- Adding Data Labels
- Card Visuals
Publishing & Sharing
- Publishing Reports (to app.powerbi.com)
- Sharing Reports
- Collaborate on Reports with Comments
- Adding a Power BI report to PowerPoint
- Workspaces: What are they, publishing to the appropriate workspace, and creating/managing
- Exporting a PDF
Links to Data Source Files
- How Power BI Links to Data Files
- Managing Links to Data Source Files
Extracting & Transforming Data
- Extracting data from various sources: Text/CSV files, Excel worksheets, Multiple Files in a Folder, and more
-
Transforming data using the Power Query Editor:
ETL = Extract, Transform, Load
ELT = Extract, Load, Transform
Data Transformations
- Use First Row as Headers
- Remove Empty rows (null data)
- Split Column By Delimiter
- Applied Steps
- Merge Queries
- Append Queries
- Fill Down
- Transpose
- Pivot
- Column profiling for data quality check
- Query Dependencies
Relationships
- Relationship importance
- Understanding types of relationship
- Creating relationships
- Cross filter relation: Single or Both
Building/Design a Report
- Adding a Title
- Adding a Logo
- Adding a Background (Solid Color or Photo)
Measures
- Create Measures
- Using Measures in a Data Visualization
Calculated Columns
- Using DAX to create a Calculated Column
- Navigating Related Tables using DAX
Slicers
- What Slicers Are
- Adding & Using a Slicer
Level 2
Filters
- Adding Filters
- Adjusting Filter settings
Intro to DAX: Data Analysis Expressions
- SUM vs SUMX
- CONCATENATEX
- COUNT vs COUNTX
Quick Measures
- YTD (Year-to-Date)
- Year-over-year-change
Map Visuals
- Creating and Customizing a Map Visual
Drill Down & Drill Through
- How to use Drill Down
- How to use Drill Through
- How Drill Down differs from Drill Through
Getting Data from Online Spreadsheets
- Getting Data from a Google Sheet
- Getting Data from Excel File Stored in OneDrive
Refreshing Data
- How Datasets work in the Power BI Service
- Manually Refreshing or Scheduled Refresh
Reusable Power BI Datasets
- About Reusable Power BI Datasets
- Creating & Using Power BI Datasets
Dashboards
- Dashboards vs Reports
- Creating a Dashboard
What's included with self-paced
- Course workbook
- Self-paced video lessons
Self-paced lessons
Watch free previews and explore the lessons included with enrollment at Noble Desktop.
Power BI Bootcamp (Self-Paced)
-
Course Overview & Setup
Lesson 1: Getting Started with Power BI
0:55
Introduces the structure of the Power BI course and explains how to use class files, PDFs, and step-by-step guides to build skills progressively.
This preview is temporarily unavailable. Please try again later.
-
Overview of Power BI
Lesson 1: Getting Started with Power BI
10:00
Explains what Power BI is, how it’s used for business intelligence, and how it compares to Excel, including an overview of Desktop, Service, and mobile access.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Installing the Power BI Desktop app
Lesson 1: Getting Started with Power BI
1:14
Walks through installing Power BI Desktop via the Microsoft Store, explaining update cycles and how to launch the application.
View enrollment options at Noble Desktop -
Enrollment required
Create our First Visualization
Lesson 1: Getting Started with Power BI
16:02
Demonstrates importing data and creating basic visuals like tables and column charts while explaining data types and automatic visual suggestions.
View enrollment options at Noble Desktop -
Enrollment required
Publishing and Sharing Reports
Lesson 1: Getting Started with Power BI
10:35
Covers publishing reports to the Power BI Service, including workspaces, sharing options, licensing, and browser-based access.
View enrollment options at Noble Desktop -
Enrollment required
Managing Links to Data Source Files & Refreshing Data
Lesson 1: Getting Started with Power BI
2:15
Explains how Power BI connects to external data sources rather than embedding files and how to manage paths and refresh data.
View enrollment options at Noble Desktop -
Transforming Data
Lesson 2: Transforming Data Using Power Query
10:00
Introduces Power Query for data transformation, including cleaning data, handling missing values, and improving performance through upstream changes.
This preview is temporarily unavailable. Please try again later.
-
Merge Queries
Lesson 2: Transforming Data Using Power Query
10:00
Explains merging tables in Power Query to combine related data and introduces normalized data concepts and lookup tables.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Append Queries
Lesson 2: Transforming Data Using Power Query
8:13
Demonstrates appending queries to combine multiple tables with the same structure into a single dataset.
View enrollment options at Noble Desktop -
Enrollment required
Fill and Transpose
Lesson 2: Transforming Data Using Power Query
5:16
Covers advanced transformations such as fill down and transpose to correct poorly structured data.
View enrollment options at Noble Desktop -
Enrollment required
Unpivot & Merge Columns
Lesson 2: Transforming Data Using Power Query
10:26
Demonstrates unpivoting data, combining date fields, assigning correct data types, and preparing datasets for time-based analysis.
View enrollment options at Noble Desktop -
Enrollment required
Query Dependencies
Lesson 2: Transforming Data Using Power Query
1:43
Explores Query Dependencies to visualize how data sources and transformations connect and to troubleshoot complex models.
View enrollment options at Noble Desktop -
Enrollment required
Getting Data from Multiple Files in a Folder (Appending from Folder)
Lesson 2: Transforming Data Using Power Query
4:59
Demonstrates importing and automatically appending files from a folder to support scalable data updates.
View enrollment options at Noble Desktop -
Relationships
Lesson 3: Building the Adventure Works Report
10:00
Explains creating relationships between fact and dimension tables and introduces star schema modeling.
This preview is temporarily unavailable. Please try again later.
-
Adventure Works Importing Data and Building Relationships
Lesson 3: Building the Adventure Works Report
10:00
Walks through building a relational model using AdventureWorks data and validating automatically detected relationships.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Adventure Works Designing and Building the Report
Lesson 3: Building the Adventure Works Report
7:20
Focuses on report design using text boxes, images, alignment tools, and layout best practices for professional presentations.
View enrollment options at Noble Desktop -
Enrollment required
Adventure Works Intro to DAX Adding the Current Date
Lesson 3: Building the Adventure Works Report
7:22
Introduces DAX by creating a simple date measure and explains the difference between measures and calculated columns.
View enrollment options at Noble Desktop -
Enrollment required
Adventure Works DAX Calculated Columns Profit or Loss
Lesson 3: Building the Adventure Works Report
14:04
Demonstrates creating calculated columns with DAX and using relationships and the RELATED function across tables.
View enrollment options at Noble Desktop -
Adventure Works Removing the Default White Background from VIsuals by editing the Theme
Lesson 4: Visuals, Slicers, and More
2:00
Shows how to customize Power BI themes to remove default styling and apply consistent global design changes.
This preview is temporarily unavailable. Please try again later.
-
Adventure Works Adding more visuals
Lesson 4: Visuals, Slicers, and More
3:17
Builds additional visuals to analyze sales by customer attributes while demonstrating interactive filtering.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Adventure Works Slicers
Lesson 4: Visuals, Slicers, and More
20:24
Introduces slicers as interactive filters and demonstrates layout improvements and user-friendly labeling.
View enrollment options at Noble Desktop -
Enrollment required
Adventure Works SUM vs SUMX
Lesson 4: Visuals, Slicers, and More
12:01
Explains the difference between SUM and SUMX in DAX and why iterator functions are needed for row-level calculations.
View enrollment options at Noble Desktop -
Enrollment required
Adjusting a Desktop Report for Mobile Devices
Lesson 4: Visuals, Slicers, and More
2:58
Demonstrates optimizing reports for mobile using the mobile layout view and adjusting visuals for smaller screens.
View enrollment options at Noble Desktop -
Global Superstore Import Data, Define Relationships, and Create Visuals
Lesson 5: Building the Global Superstore Report
10:00
Walks through importing and modeling Global Superstore data to reinforce ETL and star schema concepts.
This preview is temporarily unavailable. Please try again later.
-
Global Superstore Intro to Filters
Lesson 5: Building the Global Superstore Report
10:00
Introduces visual-, page-, and report-level filters and explains when filters are preferable to slicers.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Global Superstore Top N Filter and Filter Across All Pages
Lesson 5: Building the Global Superstore Report
7:00
Demonstrates Top N filters to highlight best- and worst-performing items and explains how ties affect results.
View enrollment options at Noble Desktop -
Enrollment required
Global Superstore Sales by Country Page
Lesson 5: Building the Global Superstore Report
9:27
Builds a multi-page report analyzing sales by country using slicers and geographic comparisons.
View enrollment options at Noble Desktop -
Enrollment required
Global Superstore Edit Interactions
Lesson 5: Building the Global Superstore Report
4:16
Explains how to control visual interactions to compare filtered values against unfiltered totals.
View enrollment options at Noble Desktop -
Global Superstore Controlling Filtering with SUM and SUMX
Lesson 6: Diving Deeper into DAX
8:46
Demonstrates using SUM and SUMX to control whether calculations respect or ignore filters.
This preview is temporarily unavailable. Please try again later.
-
Global Superstore CONCATENATEX, COUNT, and COUNTX
Lesson 6: Diving Deeper into DAX
7:42
Introduces CONCATENATEX, COUNT, and COUNTX for advanced aggregations and dynamic titles.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Global Superstore CALCULATE
Lesson 6: Diving Deeper into DAX
5:03
Explains how CALCULATE applies filters within DAX expressions to create reusable measures.
View enrollment options at Noble Desktop -
Enrollment required
Global Superstore Matrix Visual with Conditional Formatting Icons and Data Bars
Lesson 6: Diving Deeper into DAX
4:10
Builds a matrix visual with conditional formatting to highlight performance trends at a glance.
View enrollment options at Noble Desktop -
Enrollment required
Global Superstore Quick Measures
Lesson 6: Diving Deeper into DAX
7:21
Uses Quick Measures to generate common DAX calculations like YTD and YoY while keeping measures organized.
View enrollment options at Noble Desktop -
Global Superstore Maps
Lesson 7: Maps, Drill Down, and Drill Through
6:14
Creates map visuals with Azure Maps and explains data categorization and geographic field requirements.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Global Superstore Drill Down
Lesson 7: Maps, Drill Down, and Drill Through
10:41
Demonstrates drill-down using hierarchies to move between summary and detailed views.
View enrollment options at Noble Desktop -
Enrollment required
Global Superstore Drill Through
Lesson 7: Maps, Drill Down, and Drill Through
6:21
Builds drill-through navigation between report pages while preserving filter context.
View enrollment options at Noble Desktop -
Global Superstore Scheduling Data Refreshes and Getting Data
Lesson 8: Refreshing Data, Dashboards & Databases
Explains local refresh versus scheduled refresh in the Power BI Service using OneDrive and shared models.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Dashboards
Lesson 8: Refreshing Data, Dashboards & Databases
4:02
Explains how Power BI dashboards aggregate pinned visuals while linking back to underlying reports.
View enrollment options at Noble Desktop -
Enrollment required
Connecting to a Database
Lesson 8: Refreshing Data, Dashboards & Databases
4:00
Demonstrates connecting Power BI to databases like SQL Server and compares Import and DirectQuery modes.
View enrollment options at Noble Desktop -
Enrollment required
Course Outro
Lesson 8: Refreshing Data, Dashboards & Databases
0:13
Encourages continued practice to improve efficiency, confidence, and the ability to build original Power BI reports.
View enrollment options at Noble Desktop