Power BI Introduction (2 days)

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!

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

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.