Master Microsoft Power BI and learn to perform Power BI Calculation Groups, Power BI Charticulator, Power BI Performance Tips, Power BI AI, DAX table calculations, and Excel.
About This Video
In Detail
Microsoft Power BI is an advanced yet easy-to-get-started self-service business analytics/business …
Master Microsoft Power BI and learn to perform Power BI Calculation Groups, Power BI Charticulator, Power BI Performance Tips, Power BI AI, DAX table calculations, and Excel.
About This Video
In Detail
Microsoft Power BI is an advanced yet easy-to-get-started self-service business analytics/business intelligence solution. Power BI is also a great tool for data science. A lot of data scientists like to use it for visualizing and presenting the findings. Therefore, learning to use this tool can be a valuable skill for data science jobs.
This course is divided into six sections. We will first start with understanding DAX table calculations with Power BI Desktop and Excel and master DAX. In the second section, we will learn Microsoft Power BI tips and tricks from project experience and research. In the third section, we will be solving data prep challenges. In the fourth section, we will master advanced DAX calculations and build on your acquired knowledge from the prior sections.
In section five, we will be combining data science tools such as Python with Power BI. In the last section, we will cover Power BI best practices, Power BI Calculation Groups, Power BI Charticulator, Power BI performance tips, and Power BI AI.
By the end of this course, you will have the skills and capabilities to analyze and understand data with Power BI.
Who this book is for
The course is not meant for total beginners. You should have some prior knowledge of Power BI. This course is for data analysts and everyone who strives for a career in data analytics.
Chapter 1 : DAX, Excel, and More
Introduction
Set Up the Data Model
Learning DAX: Does the Pareto Rule Apply for Our Dataset
Calculate Our Base Measures
Learning DAX: Sales Forecast on Prior 3 Months Average
Learning DAX: Customer Transactions Within the Last 30 Days
Learning DAX: Customer Classification with Custom Label Calculation
Learning DAX: Dynamic Measure Comparison in Power BI
Power BI Tip - How to Remove All Filters from the Report with One Click
Growth Insights - Profit and Sales Evaluation for Customer Base
Learning DAX: Model Structure Challenge Applying Bridge Tables
Learning DAX: Calculated Columns for Employee Sales Classification
Learning DAX: Dynamic Calculation of Sales for the Last X Days
Export Data into csv and Excel
Learning DAX: Advanced Searching in Power BI
Idea - Animate Our Power BI Reports
QA Feature Introduction in Power BI
Global Filters in Power BI Synchronize Slicers Across Report Pages
Learning DAX: How to Replace Calculate with Iterators
Learning DAX: Customer Ranking on Multiple Criteria
Learning DAX: Fixing Total Issues in Dynamic Visualizations
Learning DAX: How to Build a Pareto Chart Step-By-Step
Cluster Analysis in Power BI
Chapter 2 : Additional Tips and Tricks
How to Always Get the Latest File from a Folder into Power BI
Tip Import Latest Tab from Excel File Automatically
Cumulative Total Sales for Custom Financial Years with Power BI DAX
Reference Rows or Lookup Values from Tables with DAX in Power BI
Create Your Own Personal Filter Pane in Power BI
How to Dynamically Show Specific Measures in Your Report - Playing with the Po
Client Request - Filter Trick for Different Aggregations in Power BI
Tracking Open Customer Issues with Power BI DAX
Your Turn: Real-World Power BI DAX Challenge
Learning DAX: Apples to Apples Comparison in Power BI
Dynamically Highlight the Current Sales Period with DAX in Power BI
Let Us Quickly Clean Up Our Report
Learning DAX: How to Create a Stepped Line Chart
Learning DAX: Dynamically Highlight Highest and Lowest Sales
Heatmap in Power BI: Let Us Get Creative
DAX or No DAX: That is the Question
Learning DAX Ranking and Nested Ranking
Dynamic Color-coding for Gauge chart in Power BI
Power Query Editor Tips and Tricks: How to Extract Patterns from Columns
Data Modelling - How to Create Dynamic Hierarchies
Project Management Burndown Chart Calculation with DAX in Power BI
The Disconnected Table Concept Hands-On Explained
How to Create Our Own KPI (Key Performance Indicators) Visual
Extension on How to Create Our Own KPI Visual
How to Make Interaction in Your Reports More Intuitive
How to Add Visual Toop Tips to Images
Power BI Trick Incremental Refresh Tables Using DAX
Chapter 3 : Solving Data Prep Challenges
Power BI Data Prep Challenge 1 - Date Time Conversion
Power BI Data Prep Challenge 2 - Bulk Replacement of Text Values in One Shot
Power BI Data Prep Challenge 3 - Count Customer Ratings and Sorting
Power BI DAX Challenge 4 - How Many Subscriptions Do We Have Currently
Power BI Data Prep Challenge 5 - Handling Missing Values in Power BI
Power BI Data Prep Challenge 6 - How to Handle Various Local Date Types
Power BI Data Prep Challenge 7 Currency Conversion - Exchange Rates for Specific
Power BI Data Prep Challenge 8 - How to Fix the Pivoting Issue
Chapter 4 : DAX, R, and Gateways
Advanced DAX - Price Changes in Power BI - Setting Up Our Data Model
Advanced DAX - How to Handle Price Adjustments in Power BI
Power BI DAX - How to Calculate Ages
Advanced DAX - Total Open Customer Complaints in Power BI
Additional Time Intelligence for Your Power BI Toolbox
How to Automatically Always Show the Latest Data in Our Report
Advanced DAX - Which Product was Ordered First by Each Customer
R in Power BI - Visualizing Data Using R Scripts
R in Power BI - Importing and Transforming Data with R Example
R Visuals in Power BI - Let’s Get a Little Help to Plot Amazing Visuals
Advanced DAX - Which were the Last Products the Customer Ordered from Us
Advanced DAX - Recurring Customers and Their Sales Calculation
Let’s Build Our Final Report
A Quick Introduction to Publishing Reports to the Power BI Service
How to Create a Dashboard in the Power BI Service Online
Setting Up a Data Gateway to Refresh Local Files in the Power BI S
Chapter 5 : Python Finance and Advanced DAX
Welcome: Let’s Set Up the Data Model
Setting Up Our Python Environment for Power BI
Python for Data Visualization in Power BI
Python for Data Visualization in Power BI Part2
Python for Data Visualization in Power BI Part3
How to Use Python in the Query Editor for Data Transformation in Power BI
Import Data Via Python into Power BI
Bonus: Let’s Do Data Science in Power BI: A Little Case Study
Learning DAX - Table Functions
Learning DAX - Advanced Example for Table Functions in DAX
Learning DAX: Evaluate Our New Customer Sales
Learning DAX: How to Evaluate the Lost Customers
Learning DAX - Dynamic Visualization and Disconnected Tables
Learning DAX - Daily Sales Comparison When Having Gaps in Your Dataset
Learning DAX - Show Top 3 Employees and Others
Report Best Practice Cascading Filters Using DAX in Power BI
Chapter 6 : The Next Level
Basic Model Structure Setup
Let’s Talk About Measures: Introduction to Tabular Editor
The Switch Statement for Dynamic Measures Rehearsal
Calculation Groups in Power BI: Let’s Get Started
Calculation Groups - Customize Helpful Settings
Calculation Groups: Let’s Explore a Different Use Case
Best Practices Report Creation - Use Templates
Let Us Talk About Performance - Best Practices
Let Us Talk About Visuals
Create Your First Own Custom Visual
Bump Chart and Issues with Charticulator
Visualization Tips and Tricks
Merging Tables in Power BI: Tips and Major Pitfalls
DAX Cohort Customer OrderDate Analysis
DAX - Cohort Customer Order Analysis
How to Get the Latest Refresh Time in Our Power BI Report
DAX How to Get Different Formatting in the Same Column in Power BI
AI (Artificial Intelligence) - Summarize Your Report in Power BI
Log Out and Final Words