![Power BI Masterclass 2023 [Video]](https://content.packt.com/V21759/cover_image_small.jpg)
Power BI Masterclass 2023 [Video]
Subscription
FREE
Video + Subscription
$29.99
Video
$109.99
What do you get with a Packt Subscription?
What do you get with a Packt Subscription?
What do you get with Video + Subscription?
What do you get with a Packt Subscription?
What do you get with eBook?
What do I get with Print?
What do I get with Print?
What do you get with video?
What do you get with Audiobook?
Subscription
FREE
Video + Subscription
$29.99
Video
$109.99
What do you get with a Packt Subscription?
What do you get with a Packt Subscription?
What do you get with Video + Subscription?
What do you get with a Packt Subscription?
What do you get with eBook?
What do I get with Print?
What do I get with Print?
What do you get with video?
What do you get with Audiobook?
-
Free ChapterPower BI Essentials and Advanced Techniques
- Enable the new On Object Interaction Feature in Power BI
- A Complete Guided Tour Through the Power BI Interface
- Let's Create Our First Power BI Report
- Finishing Our First Report
- On Object Feature Update
- Exploring the Advanced Dataset
- Introduction to Data Preparation of the Advanced Model with Power Query Editor
- The Importance of a Proper Dates Table and How to Create It
- Power Query Editor Deep Dive: What Can We Do with Our Data
- Data Enrichment with Web Data Extraction
- Data Modelling, The Most Important Thing in Power BI
- Creating Our First Calculated Columns and Measures in Power BI
- The Measures Table Trick
- Creating Our First DAX Measures in Power BI Desktop
- Flexibility of DAX Measures: What Makes Them Great
- Dates and Drilldown Functionality in Power BI
- How to Create Your Own Date Hierarchy in Power BI
- Let's Get Started with Time Intelligence DAX Calculations in Power BI
- Time Intelligence in a More Flexible Way in Power BI
- Calculating Cumulative or Running Total Sales in Power BI
- Measure Cleanup and Easy Formatting Trick
- Let's Create Our Power Report Like Magic
- Advance Training Part 2: Setting Up the Data Model
- Practice Building DAX Measures and Bulk Formatting Trick
- DAX Time Intelligence More DAX Formulas and Use Cases
- Calculating Sales Rankings in Power BI DAX
- Dynamic Ranking Using Parameters in Power BI
- Fixing Time Intelligence Problems: A Very Important Lesson to Understand
- Scenario Analysis in Power BI Desktop
- Calculating Rolling 30-Day Sales Periods in Power BI
- Introduction to Table Functions in Power BI Desktop
- Identifying and Visualizing Our Top 10 Clients Using DAX in Power BI
- Customer Insights Per Weekday Per Category and a Few Tricks
- DAX or No DAX—That Is the Question
- Introduction to Quick Measures and the AI Copilot
- Advance Customer Classification with Power BI DAX
- Introduction to Variables and Weekday Sales in Power BI
- Tips and Tricks for Power BI Design and Report Creation
- Addon Introduction to Buttons Use Cases and Configurations in Power BI
-
Powering Up Your Power BI Skills
- Brief Course Introduction
- Importing Project Data Cleaning and Model Setup
- Warming Up: Create DAX Base Measures Together
- Time Intelligence Measures for Our Reports
- Time Intelligence in Power BI with PREVIOUS Functions and Use Cases
- Time Intelligence with Static and Dynamic Windows in DAX
- Time Intelligence First Last Day and Days Between
- Time Intelligence Moving Averages with Power BI
- ALL and ALLSELECTED: A Common Power BI Interview Question
- Top Three Employee Sales Contribution with DAX and Virtual Tables
- Advanced DAX Customer Insights
- Introduction to Bookmarks in Power BI Desktop
- Bookmarks Buttons and Formatting Tips
- Bookmarks for Resetting All Slicers in Power BI
- The Drillthrough in Power BI Great Report Enhancement
- Page Navigation Ideas in Power BI
- Popups for Additional Information in Our Reports
-
Data Modelling Essentials
About this video
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.
- Publication date:
- September 2023
- Publisher
- Packt
- Duration
- 15 hours 6 minutes
- ISBN
- 9781835462980