Transform your career by mastering Power BI for effective data analysis and dynamic report creation, ideal for business analysts and data professionals seeking to optimize decision-making.
EnrollConnect and transform raw data using Power Query Editor.
Design interactive reports with advanced visualizations and filters.
Write basic DAX calculations for meaningful insights.
Publish and manage reports on the Power BI Service.
Power BI is a powerful tool for turning raw data into meaningful insights, making it an essential skill for professionals who work with reporting, analytics, and business intelligence. Whether you need to organize messy data, create interactive reports, or share insights with your team, knowing how to use Power BI effectively will help you work faster and make better decisions. In this hands-on, expert-led course, you will learn how to connect, clean, transform, and visualize data using Power BI’s core features. You will build practical skills that allow you to structure data for analysis, create dynamic reports, and confidently work within the Power BI ecosystem. Power BI Essentials is a two-day, hands-on course designed for those new to Power BI and walks you through basic workflows, from shaping and preparing data in Power Query Editor to building relationships in a data model and writing basic DAX calculations. You will learn how to apply best practices for formatting reports, use slicers and filters to improve interactivity, and create drill-through pages for deeper insights. You will also explore how to enhance reports with hierarchies, tooltips, and calculated columns, making your visuals clearer and more dynamic. As you progress, you will work with Power BI Service to publish and share reports, set up refresh schedules, and manage workspaces effectively. By the end of this course, you will have the confidence to clean and structure data efficiently, create compelling reports that bring your data to life, and share them seamlessly across your organization. With a balance of instruction and hands-on practice, you will leave with practical skills that can be applied immediately in your work. Whether you are an analyst, business professional, or report developer, this course gives you the foundation to build smarter reports and work more effectively with data.
What is Power BI?
Overview of the Power BI Ecosystem
Tour of the Power BI Desktop
Tour of the Power Query Editor
Introduction to the Power Query Editor
Clean and transform raw data using the ribbon
Mastering data types
Understanding some of the PQE 'rules'
Leveraging Applied Steps
Finding nulls/blanks/empties
Adding custom columns
Removing unnecessary columns
Introduction to the 'M' language
Modifying the M in the Formula Bar
Merging/appending data sources
Saving/applying transformations
What is a data model? Why is it necessary?
Reviewing relationships/creating new ones
Using basic DAX to add data
Introduction to filter context and DAX
Hierarchies
Hidden fields
Adding synonyms
Adding descriptions
Why is a date table necessary?
Where is the date table created?
Creating a basic date table
Connecting in a date table
Formatting pages and using themes
Choosing and placing visuals
Formatting visuals
Visual header controls
Editing visual interactions
Slicers and the filter panel
Syncing slicers
Formatting tooltips/creating a tooltip page
Creating a drill through
Understanding and evaluating page/visual performance
Publish the report to a designated workspace
Tour of the Power BI Service
Review of the five types of content a workspace can store
Viewing a report or dashboard
Review of menu options
Understanding editing privileges in Workspaces
Editing a report and saving changes
Creating a dashboard
Setting up a refresh schedule
Creating an app and defining audiences
Publishing a report or dashboard to an app
Your team deserves training as unique as they are.
Let us tailor the course to your needs at no extra cost.
Trusted by Engineers at:
and more...
Aaron Steele
Casey Pense
Chris Tsantiris
Javier Martin
Justin Gilley
Kathy Le
Kelson Smith
Oussama Azzam
Pascal Rodmacq
Randall Granier
Aaron Steele
Casey Pense
Chris Tsantiris
Javier Martin
Justin Gilley
Kathy Le
Kelson Smith
Oussama Azzam
Pascal Rodmacq
Randall Granier