This repository contains support material used during the Masterclass Introduction to Power BI offered by JADS MKB datalab to JADS' students.
During these hands-on session students learn some concepts of Power BI, one of the most popular business intelligence platforms. We will explore topics such as:
- Power BI Features
- Power BI Interface
- How to load data into Power BI
- How to transform data (Power Query Editor)
- Introduce DAX (New measure, Quick Measure, …)
- Build visualizations (types, hierarchies, drill-down paths, sorting, filtering, controlling interactivity) After completing this workshop, you will be able to further explore and use Power BI o build impactful reports and dashboards!
Furthermore, during this session we present some real datasets and some challenges that might be encountered when working with real data.
In Docs you find the support material including:
- Workshop presentation: MKB_datalab_PowerBI_2023.pptx
- Exercises covered during workshop: Exercises_PowerBI_2023.docx
- Instructions: How_to_update_location_of_data_sources.pdf on how to change the location of your data sources so you can verify the solutions presented in Reports.
- Manual: Power-BI-Manual.pdf to help users of Mac to be able to run Power BI:
- Whitepaper from Tableau with Visual Analysis Best Practices
Power BI files with the answer of exercises are found in Reports.
For the hands-on part we work with a subset of the Adventure Works Data Warehouse 2019.
The subset with selected tables can be download from AdventureWorksDW_subset.
✅ Download subset of AdventureWorksDW2019 (available in this repository)
✅ Take a quick look at the data to have an idea what the data is about