Book Image

Power BI Masterclass 8 - Python, Finance, and Advanced DAX [Video]

By : Dan We
5 (1)
Book Image

Power BI Masterclass 8 - Python, Finance, and Advanced DAX [Video]

5 (1)
By: Dan We

Overview of this book

Microsoft Power BI is a powerful business analytics/data visualization tool that enables users to connect to various data sources, create interactive reports and dashboards, and gain insights from the data. With its intuitive interface and robust features, Power BI empowers users to make data-driven decisions and effectively communicate information with stakeholders. The course begins with setting up the Python environment for Power BI and then dives into using Python for data visualization in Power BI. It covers advanced DAX expressions and calculations, exploring a business dataset. You will also learn how to leverage Python libraries for data science in Power BI and create a balance sheet structure. The course includes applying custom visuals and culminates in creating a final dashboard. However, the Python concepts covered in this course cannot be considered comprehensive, only content related to Power BI usage requirements. Upon completing the course, you will gain advanced knowledge and skills in using Power BI for data visualization, analysis, and science. You will be proficient in setting up the Python environment in Power BI, leveraging Python for data visualization, and applying advanced DAX expressions and calculations, enabling you to effectively analyze/present data in various business scenarios.
Table of Contents (2 chapters)
Chapter 1
Power BI Masterclass Updated Python and DAX in Power BI
Content Locked
Section 14
Learning DAX - Daily Sales Comparison When Having Gaps in Your Dataset
In this video, you will learn to perform daily sales comparisons in Power BI using DAX, even when there are gaps in the dataset. We will explore techniques to handle missing data and effectively calculate daily sales performance metrics, such as year-over-year comparisons and rolling averages.