Search icon Close icon
Search icon CANCEL
Subscription
0
Cart icon
Cart
Close icon
You have no products in your basket yet
Save more on your purchases!
Savings automatically calculated. No voucher code required
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Home > Data > Data Analysis > Power BI Masterclass [Video]
Power BI Masterclass [Video]
Power BI Masterclass [Video]

Power BI Masterclass: Master Dax in Power BI and learn the best data preparation and analysis practices with Power BI

Profile Icon Dan We
By Dan We
$134.99
Video Nov 2021 19 hours 24 minutes 1st Edition
Video
$134.99
Subscription
Free Trial
Renews at $19.99p/m
Profile Icon Dan We
By Dan We
$134.99
Video Nov 2021 19 hours 24 minutes 1st Edition
Video
$134.99
Subscription
Free Trial
Renews at $19.99p/m
Video
$134.99
Subscription
Free Trial
Renews at $19.99p/m

What do you get with a video?

Product feature icon Download this video in MP4 format
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
Table of content icon View table of contents Download code icon Download Code

Key benefits

  • Learn to handle many-to-many relationships in Power BI
  • Master DAX and use Python with data science tools
  • Learn additional tips and tricks to improve your skills

Description

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

What you will learn

  • Understand DAX Logic and Table Calculations
  • Learn Power BI tips and tricks from project experience and research
  • Solve common Power BI data preparation issues
  • Learn how to improve the look and feel of standard dashboards
  • Combine data science tools such as Python with Power BI
  • Learn how to start creating your own custom visuals without coding

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Nov 23, 2021
Length 19 hours 24 minutes
Edition : 1st Edition
Language : English
ISBN-13 : 9781801070959
Vendor :
Microsoft
Category :
Data
Concepts :
Data Analysis
Tools :
Power BI (Intermediate)

What do you get with a video?

Product feature icon Download this video in MP4 format
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want

Product Details

Publication date : Nov 23, 2021
Length 19 hours 24 minutes
Edition : 1st Edition
Language : English
ISBN-13 : 9781801070959
Vendor :
Microsoft
Category :
Data
Concepts :
Data Analysis
Tools :
Power BI (Intermediate)

Packt Subscriptions

See our plans and pricing
Modal Close icon
$19.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
START FREE TRIAL
BUY NOW
$199.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts
START FREE TRIAL
BUY NOW
$279.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts
START FREE TRIAL
BUY NOW

Frequently bought together

Microsoft Power BI Cookbook
Microsoft Power BI Cookbook
Read more
Sep 2021 656 pages
ebook
eBook
  • ebook eBook $38.99
  • print Print $69.99
$38.99 $55.99
$69.99
Expert Data Modeling with Power BI
Expert Data Modeling with Power BI
Read more
Jun 2021 612 pages
ebook
eBook
  • ebook eBook $38.99
  • print Print $69.99
$38.99 $55.99
$69.99
Power BI Masterclass
Power BI Masterclass
Read more
Nov 2021 19h 24m
video Video
$134.99
Stars icon
Total $ 212.97 246.97 34.00 saved
Microsoft Power BI Cookbook
$38.99 $55.99
Expert Data Modeling with Power BI
$38.99 $55.99
Power BI Masterclass
$134.99
=
Book stack Total $ 212.97 246.97 34.00 saved Stars icon

Table of Contents

6 Chapters
1. DAX, Excel, and More Chevron down icon Chevron up icon
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
2. Additional Tips and Tricks Chevron down icon Chevron up icon
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
3. Solving Data Prep Challenges Chevron down icon Chevron up icon
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
4. DAX, R, and Gateways Chevron down icon Chevron up icon
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
5. Python Finance and Advanced DAX Chevron down icon Chevron up icon
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
6. The Next Level Chevron down icon Chevron up icon
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

Recommendations for you

Left arrow icon
Building LLM Powered Applications
Building LLM Powered Applications
Read more
May 2024 342 pages
ebook
eBook
  • ebook eBook $27.98
  • print Print $49.99
$27.98 $39.99
$49.99
Machine Learning with PyTorch and Scikit-Learn
Machine Learning with PyTorch and Scikit-Learn
Read more
Feb 2022 774 pages
Full star icon 5
ebook
eBook
  • ebook eBook $29.99
  • print Print $54.99
$29.99 $43.99
$54.99
Harnessing Open Source LLMs and ChatGPT with Minimal Code
Harnessing Open Source LLMs and ChatGPT with Minimal Code
Read more
Jul 2024 1h 59m
video Video
$79.99
Transformers for Natural Language Processing and Computer Vision
Transformers for Natural Language Processing and Computer Vision
Read more
Feb 2024 728 pages
ebook
eBook
  • ebook eBook $29.99
  • print Print $43.98
$29.99 $43.99
$43.98 $54.99
The Machine Learning Solutions Architect Handbook
The Machine Learning Solutions Architect Handbook
Read more
Apr 2024 602 pages
ebook
eBook
  • ebook eBook $22.99
  • print Print $40.99
$22.99 $32.99
$40.99
Mastering NLP from Foundations to LLMs
Mastering NLP from Foundations to LLMs
Read more
Apr 2024 340 pages
ebook
eBook
  • ebook eBook $29.99
  • print Print $46.99
$29.99 $42.99
$46.99 $52.99
The Definitive Guide to Power Query (M)
The Definitive Guide to Power Query (M)
Read more
Mar 2024 758 pages
ebook
eBook
  • ebook eBook $43.99
  • print Print $54.99
$43.99
$54.99
Python Data Cleaning Cookbook
Python Data Cleaning Cookbook
Read more
May 2024 486 pages
ebook
eBook
  • ebook eBook $27.98
  • print Print $39.98
$27.98 $39.99
$39.98 $49.99
Machine Learning for Algorithmic Trading
Machine Learning for Algorithmic Trading
Read more
Jul 2020 822 pages
ebook
eBook
  • ebook eBook $31.99
  • print Print $57.99
$31.99 $46.99
$57.99
Generative AI with LangChain
Generative AI with LangChain
Read more
Dec 2023 360 pages
Full star icon 3
ebook
eBook
  • ebook eBook $27.98
  • print Print $39.98
$27.98 $39.99
$39.98 $49.99
Right arrow icon

People who bought this also bought

Left arrow icon
Machine Learning with PyTorch and Scikit-Learn
Machine Learning with PyTorch and Scikit-Learn
Read more
Feb 2022 774 pages
Full star icon 5
ebook
eBook
  • ebook eBook $29.99
  • print Print $54.99
$29.99 $43.99
$54.99
Machine Learning for Time-Series with Python
Machine Learning for Time-Series with Python
Read more
Oct 2021 370 pages
ebook
eBook
  • ebook eBook $29.99
  • print Print $54.99
$29.99 $43.99
$54.99
Modern Time Series Forecasting with Python
Modern Time Series Forecasting with Python
Read more
Nov 2022 552 pages
Full star icon 5
ebook
eBook
  • ebook eBook $29.99
  • print Print $52.99
$29.99 $42.99
$52.99
Deep Learning with TensorFlow and Keras – 3rd edition
Deep Learning with TensorFlow and Keras – 3rd edition
Read more
Oct 2022 698 pages
Full star icon 5
ebook
eBook
  • ebook eBook $27.98
  • print Print $49.99
$27.98 $39.99
$49.99
Hands-On Data Preprocessing in Python
Hands-On Data Preprocessing in Python
Read more
Jan 2022 602 pages
Full star icon 5
ebook
eBook
  • ebook eBook $29.99
  • print Print $54.99
$29.99 $43.99
$54.99
Power BI Masterclass
Power BI Masterclass
Read more
Nov 2021 19h 24m
video Video
$134.99
Right arrow icon

About the author

Profile icon Dan We
Dan We is a 32-year-old entrepreneur, data scientist, and data analytics/visual analytics consultant. He holds a master’s degree and is certified in Power BI as a qualified associate in Tableau. He is currently working in business intelligence and helps major companies get key insights from their data in order to deliver long-term growth and outpace their competitors. He is committed to supporting other people by offering them educational services to help them accomplish their goals and become the best in their profession or explore a new career path.
Read more
See other products by Dan We
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

How can I download a video package for offline viewing? Chevron down icon Chevron up icon
  1. Login to your account at Packtpub.com.
  2. Click on "My Account" and then click on the "My Videos" tab to access your videos.
  3. Click on the "Download Now" link to start your video download.
How can I extract my video file? Chevron down icon Chevron up icon

All modern operating systems ship with ZIP file extraction built in. If you'd prefer to use a dedicated compression application, we've tested WinRAR / 7-Zip for Windows, Zipeg / iZip / UnRarX for Mac and 7-Zip / PeaZip for Linux. These applications support all extension files.

How can I get help and support around my video package? Chevron down icon Chevron up icon

If your video course doesn't give you what you were expecting, either because of functionality problems or because the content isn't up to scratch, please mail customercare@packt.com with details of the problem. In addition, so that we can best provide the support you need, please include the following information for our support team.

  1. Video
  2. Format watched (HTML, MP4, streaming)
  3. Chapter or section that issue relates to (if relevant)
  4. System being played on
  5. Browser used (if relevant)
  6. Details of support
Why can’t I download my video package? Chevron down icon Chevron up icon

In the even that you are having issues downloading your video package then please follow these instructions:

  1. Disable all your browser plugins and extensions: Some security and download manager extensions can cause issues during the download.
  2. Download the video course using a different browser: We've tested downloads operate correctly in current versions of Chrome, Firefox, Internet Explorer, and Safari.