Book Image

Power BI Masterclass 2023 [Video]

By : Daniel Weikert
3 (1)
Book Image

Power BI Masterclass 2023 [Video]

3 (1)
By: Daniel Weikert

Overview of this book

Welcome to the Power BI masterclass! This masterclass course is designed to equip you with the expertise needed to leverage Power BI effectively. Throughout this course, we will guide you through a multifaceted journey, unraveling the intricacies of Power BI step by step. Starting with the fundamentals, we will explore the Power BI interface and its various features. We will learn how to create visually engaging reports and gain insights into advanced dataset management. We will also delve into DAX calculations, time intelligence, and data modelling to elevate our analytical capabilities. The course comprises three sections, each building upon the last. In the first section, we will discover how to enable interactive features, navigate the interface, create dynamic reports, and employ data manipulation techniques. Advanced dataset management and DAX calculations await us in the second section, enabling us to tackle complex data challenges. In the third section, we will dive into the heart of Power BI, mastering the art of creating a robust data model. Learn how to transform and structure data efficiently, connect dimension tables, and add critical elements such as a dates table. By the end of this course, we will be proficient in harnessing Power BI’s capabilities to turn raw data into actionable insights.
Table of Contents (3 chapters)
Free Chapter
1
Power BI Essentials and Advanced Techniques
Chapter 3
Data Modelling Essentials
Content Locked
Section 1
How to Create a Proper Data Model the Facts Table
In this video, we will explore the process of transforming and unpivoting data in Power BI. We start with a case study involving hotel data sent by a client. The data is structured in Excel files with multiple sheets and columns. We learn how to extract and clean this data efficiently, removing unnecessary columns, empty rows, and repeated headers. The video covers steps such as data type assignment, creating a unique ID for each hotel, and achieving a structured format suitable for analysis.