Power BI Fundamentals
Power BI Fundamentals is a rigorous 1-day or 2-day training course for aspiring report developers and data professionals seeking to hone their skills in Power BI. The class is instructor-led and paced as a group.
The course is designed to walk you through each important capability of Power BI and provide you sample situations to practice your skills. The goal is to build “muscle-memory” for Power BI best practices on report creation and data transformations.
You will learn how to:
- Follow report and data visualization best practices
- Transform your data with Power Query
- Write basic DAX calculations
- Build an analytical data model
Power BI Fundamentals (2-day) Course Outline
Day One – Basic Report Building
Introduction to Power BI development stages
Introduction to data visualization best practices
Building a chart driven report using best practices
Building a table-driven report with conditional formatting and drill through
Introduction to publishing
Data wrangling primer (extract, clean, and load two Excel tables)
Day Two – Data Wrangling and Modeling
Review of Power BI development stages
Accessing Data Sources (Excel sheets/named-ranges, CSV files, and folders of workbooks)
Basic transformations of data sources (date/text parsing, filtering, pivoting)
Intermediate transformation of data sources (joining, appending, and data structures)
Introduction to dimensional modeling
Setting relationships and building simple DAX measures
$8,000 for 10 students, then $500/student
Power BI Fundamentals (1-day) Course Outline
This 1-day version of our 2-day Power BI Fundamentals offering is meant specifically for organizations that either want to focus on Day One – Basic Report Building or Day Two – Data Wrangling and Modeling.
$4,000 for 10 students, then $250/student
Subscribe to CSG Pro. We’ll supply your inbox with the latest blog posts, training videos, and upcoming events.