Report Dashboards
Duration: one-day
Course Overview
On this course, you will learn how to use the visualisation tools in Power BI, and how to create, and design report dashboards that works for you and your colleagues. It also focuses on the art of storytelling with data, looking at different types of visuals that best highlight trends and patterns in data.
Course content includes maps, charts, gauges, and tables and covers design tools like KPIs (Key Performance Indicators), heatmaps, sparklines, and tools to compare variations in trends. By the end of the course you will be able to use dynamic visuals that represents key trends and variation in business data.
Prerequisite
The assumption is you know something about working with datasets, because Power BI is all about visualising data and sharing insights with others. For example, you know how to create charts, and format data in Excel, and can create Excel Pivot Tables.
Course Content
Lesson 1. Creating Dashboards
1.1. The Power BI environment
1.2. Things to keep in mind
1.3. Selecting dashboard colours
1.4. Importing online visuals
1.5. Analysing data sources
1.6. Data modelling in Power BI
Lesson 2. Working with Visuals
2.1. Utilise a report theme
2.2. Table visuals
2.3. Matrix visuals
2.4. Drill into a visual’s layers
2.5. Apply static filters
2.6. Create a filter list
2.7. Create a bin range
2.8. Add measures to visuals
Lesson 3. Creating Visuals
3.1. Create a heatmap
3.2. Visualising trend patterns
3.3. Rank categorical totals
3.4. Compare proportions
3.5. Chart labels as percentages
3.6. View trends with sparklines
Lesson 4. Comparing Variables
4.1. Insert a KPI
4.2. Visualise trendlines as KPI
4.3. Forecast with trendlines
4.4. Analyse data with violin plots
4.5. Visualising flow patterns
Lesson 5. Setting up Maps
5.1. Drill into maps by region
5.2. Map with ArcGIS map
Lesson 6. Creating Dashboards
6.1. High-level dashboard
6.2. Add slicers to filter dashboards
6.3. Promote dashboard interaction
6.4. Create dynamic labels
6.5. Customise visual tooltips
6.6. Activate and deactivate slicers
6.7. Reports for mobile devices
6.8. Export data
Lesson 7. Sharing Dashboards
7.1. Publish to the Power BI service
7.2. Edit online reports
7.3. Download online reports
7.4. Sharing reports in SharePoint