Improving Your Power BI Game: A One Day Introductory Workshop

Full Course Description: Using the Power BI Desktop, members of the workshop will connect to multiple data sources, cleanse and model the data to gain critical insights, and create powerful visualizations quickly. Reports will be published to the Power BI Service, where users will learn about dashboards, report sharing, security and data refreshes.

Audience:

Business Analysts, Power Users, BI Developers.

Course Agenda

1. Intro & Getting your data

• Choose a licensing strategy

• Connect to and import data from cloud and on-premises data sources

• Use Direct Query

• Use Power BI query editor to transform data

2. Building your data model

• Create relationships in Power BI model

• Create and use hierarchies

• Use PBI Desktop to create quick measures

• Use DAX to create calculated columns and measures

3. Building your reports

• Create visualizations

• Create interactive reports using visualizations

• Explore advanced visualization techniques

4. Sharing your reports

• Publish reports to Power BI service

• Create dashboards

• Create and leverage app workspace

• Create and leverage row level security

• Refresh data in published reports