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.
What You Will Learn
- 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
Course Outline
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
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.
