<< VIEW FULL COURSE LIST

Microsoft 2.X - Power BI

Power BI Fundamentals

COURSE DESCRIPTION

Power BI Fundamentals is for students just getting started with Power BI. It provides an end-to-end overview, from data sources to visualizations.

This is a fully interactive course. Participants will have practice performing the skills in our online classroom. The instructor is able to see each student's computer screen and offer guidance. Students will be provided an electronic copy of the course manual.

Class Length

One Day

SUGGESTED ATTENDEES

Business analysts who want to learn the fundamentals of data acquisition, modeling, visualization and dashboarding with Power BI. No previous experience with is required.

COURSE OUTLINE

Power BI end-to-end: Power BI from sources to visualizations

  • Introduction and overview of Power BI
  • Overview of Power BI Desktop
  • Overview of Power BI service

Introduction to data modeling with Power BI

  • Introduction to data modeling with Power BI
  • Data sources and connections: Power BI Desktop
  • Data sources and connections: Power BI service

Introduction to data analysis expressions (DAX)

  • Introduction to DAX functions
  • Data sources and connections: Power BI Desktop
  • Calculated columns vs. measures
  • DAX calculations in action with examples
  • DAX function groups
  • Review of measures and evaluation context
  • Manipulating context

Reports, visualizations and dashboards in Power BI

  • Reporting in Power BI
  • Working with reports
  • Creating dashboards

Transforming data with Power BI

  • Query editor environment
  • Transforming data
  • Advanced features