Introduction
Introduce yourself to the world of Power BI with this unique introductory training!
Here you will learn the basic principles of Power BI, enabling you to create efficient and beautiful reports and visualizations.
I will guide you step by step through the Power BI Desktop and provide you with the tools to analyze and present your data.
Whether you are a beginner or already have some experience, this training is suitable for anyone looking to improve their data analysis skills.
Register now and discover the power of Power BI for yourself!
Target Audience
This 2-day course is ‘essential’ for anyone who wants to combine and report data from various sources
such as Excel, CSV files.
Prerequisites
You have a good knowledge of Excel.
Information
Interested in this training? Click here for more information.
Topics
Introduction
- Power BI Architecture
- Data Warehousing: Tables, Star Schemas
Importing Data (PowerQuery)
- Importing data from:
- CSV, Excel
- Creating Calculated Columns
- Cleaning + Transforming Data
- Automatically reading multiple Excel sheets from a folder
Modeling and Analyzing
- Creating a Data Model (star schemas): 1-to-many, many-to-many relationships
- Creating a Date Table
- DAX Formulas
- Difference between Row context and Filter context.
- Calculated Columns and Measures: when to use what?
- Measures: SUM, AVERAGE + COUNT
Graphical Representation
- Creating Table, Matrix + Graph
- Adding Filters: visual, page or report
- KPI Dashboard: Actuals vs Targets