Search
Close this search box.
5/5

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

$9,000 for 10 students, then $500 per 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,500 for 10 students, then $250 per student

Stay Connected

Subscribe and we’ll supply your inbox with the latest blog posts, training videos, and upcoming events.