“I took the Power BI Fundamentals 2-day class and it was fantastic. I learned everything I needed to be up and running with Power BI over the course of the class. The instruction was clear and concise, the materials are great, and they provide a ton of great information to continue learning after the class. I'd recommend CSG Pro to anybody and I'll be back for more classes.”

Jeffrey Farnsworth

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
-Lunch-
Building a table-driven report with conditional formatting and drill through
Introduction to publishing
Data wrangling primer (extract, clean, and load two Excel tables)
Q&A

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)
-Lunch-
Intermediate transformation of data sources (joining, appending, and data structures)
Introduction to dimensional modeling
Setting relationships and building simple DAX measures
Q&A

Pricing

$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.

Pricing

$4,000 for 10 students, then $250/student

Stay Connected

Subscribe to CSG Pro. We’ll supply your inbox with the latest blog posts, training videos, and upcoming events.