O'Reilly logo
live online training icon Live Online training

Analyzing and Visualizing Data with Microsoft Power BI

Daniil Maslyuk

This Live Training is about how you can use Power BI to analyze and visualize your data. The training starts with getting your data into Power BI Desktop, then looks at creating a data model and writing your own calculations using DAX, building reports, and sharing them with others online.

Power BI is part of the Microsoft business intelligence platform, which has seen dramatic progress in the recent years. Gartner has recently named Microsoft one of the leaders in the BI and analytics space. Power BI increasingly becomes a platform of choice for many organizations, and knowing how to work with Power BI becomes an important skill in the current job market.

What you'll learn-and how you can apply it

  • Connect to various data source and perform transformations on your data
  • Create data models and enrich them with DAX measures, calculated columns, and calculated tables
  • Create reports and share them through Power BI service

This training course is for you because...

  • You want to learn how to get data, transform it, and load in Power BI
  • You want to know how to enrich your reports with your own measures
  • You want to get an overview of how you can share your reports with others

Prerequisites

  • Basic experience with Excel
  • Basic familiarity with relational databases (especially relationships)

Course Set-up:

Power BI Desktop: download from the official website and follow the installation prompts:https://powerbi.microsoft.com/en-us/desktop/

Recommended Preparation:

Have a basic understanding of what Power BI is. Refer to the general overview on the official website: https://powerbi.microsoft.com/en-us/what-is-power-bi/

Recommended Follow-up:

About your instructor

  • Daniil Maslyuk, MCSA, MCSE is a Microsoft business intelligence consultant who specializes in Power BI, Power Query, and Power Pivot; the DAX and M languages; and SQL Server and Azure Analysis Services tabular models. He is the author of the official Power BI exam reference book. Daniil blogs at xxlbi.com and tweets as @DMaslyuk.

Schedule

The timeframes are only estimates and may vary according to how the class is progressing

Course overview (5 min)

  • Consuming and transforming data using Power Query Editor (50 min)
  • Connect to data sources (15 min)
  • Perform transformations (25 min)
  • Cleanse data (10 min)

10 min Q&A + break

Modeling and visualizing data (65 min)

  • Create a data model (10 min)
  • Create hierarchies (5 min)
  • Create measures and calculated columns with DAX (25 min)
  • Use KPIs, gauges, and cards (5 min)
  • Create interactive visualizations (15 min)
  • Use custom visuals (5 min)

10 min Q&A + break

Using Power BI service (30 min)

  • Publish reports (5 min)
  • Configure a dashboard (15 min)
  • Configure app workspaces and apps (10 min)

Q&A (10 min)