During this one-day introduction training, attendees will learn how to go through the entire cycle of producing a Power BI dashboard, including:
- Accessing data
- Transforming data
- Combining different sources
- Explore data (find hidden insights)
- Visualize insights (create a dashboard)
- Share a dashboard (either in the cloud or on the on-premises report server)
Subjects
- Accessing, transforming and mashing up data using the Power Query Editor
- Data modelling basics
- Dashboard creation
- Dashboard distribution in the cloud or the Power BI Report Server
Prerequisites
Some previous experience with Power BI is nice to have, yet not a requirement for this course.
Objectives
- Import data into Power BI from various data sources
- Describe storage options using Power BI when connecting to a database
- Perform various types of transformations on data in the Power Query Editor
- Mashup data (bring different data sources together)
- Describe Power BI desktop data modelling
- Understand how relationships between tables are created
- Create visualizations in order to explore data
- Build an interactive dashboard
- Share a dashboard with colleagues