Overview
Learn how to find, read and interpret reports and to find the story in the data. Users requiring these skills exist at all levels of an organisation.
A number of our clients raised the issue that they’d trained staff to create Power BI Reports, but that staff across the organisation struggled to use them.
This course was designed to address that issue, teaching the skills necessary to dive deep into an existing Power BI Report and gain actionable insight.
This is a fun course, thanks to the use of interesting real-world datasets, and lots of hands-on time with interesting reports to analyse.
What you’ll need
- Laptop and headphones and microphone
- Microsoft Office (Word, PowerPoint, Excel)
- Google Chrome or Microsoft Edge
- Power BI Desktop; Power BI Pro or Premium Per User (PPU) licence
Learning outcomes
Attendees will be able to:
- Read and analyse data from a variety of Power BI Reports
- Interpret and explain what their analysis shows
- Present actionable insight in the form of a presentation
Course topics
- What is Power BI?
- A quick introduction to Power BI, with example power BI Reports to demonstrate what it can do
- Overview of Power BI features and functionality
- Common Chart Types in Power BI
- Hands-on experience with the Power BI Power BI service. We’ll look at the most commonly used chart types in Power BI, as well as some of the gotchas to look out for when analysing data
- Leveraging the Interactivity of Power BI Reports
- Learn to use the interactivity of the report to provide a deeper level of understanding from the data
- Filtering Reports (using Charts, the Filter pane, or Slicers)
- Learn how to perform basic and advanced filtering on a Power BI Report.
- Advanced Filtering e.g. searching for patterns of text, or ranges of dates
- Understanding the difference between Highlighting and Filtering charts
- Focus Mode
- Exporting Data
- Printing and Exporting Reports
- Creating and using Bookmarks, and resetting a Report
- Learn how to create personal bookmarks that you can revisit later
- Using “Show as table”
- Marking a Report as a favourite
- Investigating data with Maps
- Drilling Down and Drilling Through
- Deep dive into your data with the Drill Down and Drill through features.
- Using Reports, Dashboards and Apps
- Looking at the differences between Reports, Dashboards and Apps in Power BI
- Sharing Reports, providing feedback and subscribing to changes
- Viewing a Chart’s data as a Table and exporting the data
- How to perform an in-depth analysis using Charts
- Presentation of a Power BI dashboard to peers (final session)