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 4
How to Create a Proper Data Model Data Enrichment from the Web
In this video, we will explore how to add a crucial dimension table, the dates table, to our Power BI data model. We will utilize a provided M function to create this dates table, ensuring that our data model is properly structured for analysis. Additionally, we will enrich our data with currency conversion rates from a public web source and demonstrate how to handle decimal separators for different locales.