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 1
Power BI Essentials and Advanced Techniques
Content Locked
Section 26
Calculating Sales Rankings in Power BI DAX
In this video, we will explore ranking in Power BI and learn how to use the RANKX function to rank categories based on their total sales. We will also understand the concept of context and how it affects ranking. The video will demonstrate the creation of a ranking measure and its application to a table.