![Power BI Masterclass [Video]](https://content.packt.com/V17323/cover_image_small.jpeg)
Power BI Masterclass [Video]
Video
Subscription
FREE
Video + Subscription
$29.99
Video
$134.99
What do you get with a Packt Subscription?
This book & 7000+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with Video + Subscription?
Download this video in MP4 format, plus a monthly download credit
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with eBook?
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do I get with Print?
Get a paperback copy of the book delivered to your specified Address*
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do I get with Print?
Get a paperback copy of the book delivered to your specified Address*
Access this title in our online reader
Online reader with customised display settings for better reading experience
What do you get with video?
Download this video in MP4 format
Access this title in our online reader
DRM FREE - Watch whenever, wherever and however you want
Online reader with customised display settings for better learning experience
What do you get with Audiobook?
Download a zip folder consisting of audio files (in MP3 Format) along with supplementary PDF
Subscription
FREE
Video + Subscription
$29.99
Video
$134.99
What do you get with a Packt Subscription?
This book & 7000+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with Video + Subscription?
Download this video in MP4 format, plus a monthly download credit
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with eBook?
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do I get with Print?
Get a paperback copy of the book delivered to your specified Address*
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do I get with Print?
Get a paperback copy of the book delivered to your specified Address*
Access this title in our online reader
Online reader with customised display settings for better reading experience
What do you get with video?
Download this video in MP4 format
Access this title in our online reader
DRM FREE - Watch whenever, wherever and however you want
Online reader with customised display settings for better learning experience
What do you get with Audiobook?
Download a zip folder consisting of audio files (in MP3 Format) along with supplementary PDF
-
Free ChapterDAX, 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
-
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
-
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
-
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
-
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
-
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
About this video
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.
The complete course bundle is available at https://github.com/PacktPublishing/Power-BI-Masterclass
- Publication date:
- November 2021
- Publisher
- Packt
- Duration
- 19 hours 24 minutes
- ISBN
- 9781801070959
Download code from GitHub