Power BI
Transform raw data into interactive dashboards and reports with Microsoft Power BI. Learn to connect to data sources, model relationships, write DAX measures, and publish insights that drive business decisions.
Need a custom curriculum for your team? Contact us
What You Will Learn
Build a solid foundation with core concepts and essential skills.
Course Curriculum
2 modulesDay 1: Connecting Data and Building Reports
- Installing Power BI Desktop and navigating the interface
- Connecting to Excel, CSV, and database sources
- Loading and previewing data in the data model
- Building your first report: tables, cards, and matrices
- Creating bar charts, line charts, and pie charts
- Formatting visuals: colors, labels, titles, and borders
- Saving and sharing .pbix files
Day 2: Relationships, Filters, and Power Query Basics
- Understanding table relationships and star schema concepts
- Creating and editing relationships between tables
- Using slicers and filters for interactive exploration
- Introduction to Power Query: cleaning and shaping data
- Removing columns, filtering rows, and changing data types
- Basic DAX: SUM, AVERAGE, COUNT, and DISTINCTCOUNT measures
- Publishing reports to the Power BI Service
After This Level
- Connect to multiple data sources and load data into Power BI
- Build interactive reports with charts, tables, and slicers
- Understand table relationships and star schema basics
- Clean data with Power Query and write basic DAX measures
Who Is This For
- Business analysts and data analysts
- Finance and operations teams
- Managers who need self-service reporting
- Anyone building dashboards for stakeholders
Prerequisites
Basic data literacy. Familiarity with Excel is helpful.
Frequently Asked Questions
Do I need Power BI Pro to take this course?
Power BI Desktop is free and used for all hands-on exercises. A Pro license is helpful for the Advanced level when we cover the Power BI Service, but not required.
Is this course suitable for non-technical users?
Absolutely. The Fundamental level assumes no Power BI experience. If you can use Excel, you can learn Power BI.
How long does it take to learn Power BI?
Each level is 2 days of training. Most professionals become productive with basic reports after the Fundamental level. The full program across all three levels is 6 days.
Will I receive a certificate after completing the Power BI course?
Yes. Upon completing each level, you receive a GrowWM certificate of completion that you can share with employers or add to your LinkedIn profile.
Is Power BI training available online?
Yes. All sessions are delivered live via virtual classroom, so you can join from anywhere in Canada or internationally. On-site training is also available for teams in Ottawa and Ontario.
What is the difference between Power BI and Excel?
Excel is ideal for smaller datasets and calculations. Power BI is designed for connecting multiple data sources, building interactive dashboards, and sharing reports across teams. Many professionals use both together.
Can this Power BI course be customized for my team?
Yes. We offer tailored curricula for corporate and government teams, focusing on the specific Power BI skills and data sources your organization uses. Contact us for group rates.
Do I need to know DAX before starting?
No. DAX is introduced gradually starting in the Fundamental level with basic measures, and we cover advanced DAX patterns in the Intermediate and Advanced levels.
Ready to master Power BI?
Get in touch to discuss scheduling, group rates, or a customized curriculum for your team.