Power BI Masterclass

Focused View

Dan We

19:23:49

245 View

00001 Introduction.mp4

00:41

00002 Set Up the Data Model.mp4

14:12

00003 Learning DAX - Does the Pareto Rule Apply for Our Dataset.mp4

14:39

00004 Calculate Our Base Measures.mp4

04:32

00005 Learning DAX - Sales Forecast on Prior 3 Months Average.mp4

06:46

00006 Learning DAX - Customer Transactions Within the Last 30 Days.mp4

08:04

00007 Learning DAX - Customer Classification with Custom Label Calculation.mp4

10:09

00008 Learning DAX - Dynamic Measure Comparison in Power BI.mp4

11:45

00009 Power BI Tip - How to Remove All Filters from the Report with One Click.mp4

07:43

00010 Growth Insights - Profit and Sales Evaluation for Customer Base.mp4

07:23

00011 Learning DAX - Model Structure Challenge Applying Bridge Tables.mp4

22:02

00012 Learning DAX - Calculated Columns for Employee Sales Classification.mp4

09:07

00013 Learning DAX - Dynamic Calculation of Sales for the Last X Days.mp4

11:24

00014 Export Data into csv and Excel.mp4

02:45

00015 Learning DAX - Advanced Searching in Power BI.mp4

11:57

00016 Idea - Animate Our Power BI Reports.mp4

07:26

00017 QA Feature Introduction in Power BI.mp4

13:38

00018 Global Filters in Power BI Synchronize Slicers Across Report Pages.mp4

09:28

00019 Learning DAX - How to Replace Calculate with Iterators.mp4

10:32

00020 Learning DAX - Customer Ranking on Multiple Criteria.mp4

12:36

00021 Learning DAX - Fixing Total Issues in Dynamic Visualizations.mp4

15:10

00022 Learning DAX - How to Build a Pareto Chart Step-By-Step.mp4

18:04

00023 Cluster Analysis in Power BI.mp4

05:59

00024 How to Always Get the Latest File from a Folder into Power BI.mp4

12:42

00025 Tip Import Latest Tab from Excel File Automatically.mp4

06:11

00026 Cumulative Total Sales for Custom Financial Years with Power BI DAX.mp4

16:13

00027 Reference Rows or Lookup Values from Tables with DAX in Power BI.mp4

11:45

00028 Create Your Own Personal Filter Pane in Power BI.mp4

19:52

00029 How to Dynamically Show Specific Measures in Your Report - Playing with the Po.mp4

06:57

00030 Client Request - Filter Trick for Different Aggregations in Power BI.mp4

10:06

00031 Tracking Open Customer Issues with Power BI DAX.mp4

09:07

00032 Your Turn - Real-World Power BI DAX Challenge.mp4

07:46

00033 Learning DAX - Apples to Apples Comparison in Power BI.mp4

11:57

00034 Dynamically Highlight the Current Sales Period with DAX in Power BI.mp4

10:22

00035 Let Us Quickly Clean Up Our Report.mp4

02:48

00036 Learning DAX - How to Create a Stepped Line Chart.mp4

12:36

00037 Learning DAX - Dynamically Highlight Highest and Lowest Sales.mp4

13:16

00038 Heatmap in Power BI - Let Us Get Creative.mp4

05:45

00039 DAX or No DAX - That is the Question.mp4

06:02

00040 Learning DAX Ranking and Nested Ranking.mp4

14:28

00041 Dynamic Color-coding for Gauge chart in Power BI.mp4

10:15

00042 Power Query Editor Tips and Tricks - How to Extract Patterns from Columns.mp4

05:46

00043 Data Modelling - How to Create Dynamic Hierarchies.mp4

18:42

00044 Project Management Burndown Chart Calculation with DAX in Power BI.mp4

16:21

00045 The Disconnected Table Concept Hands-On Explained.mp4

20:26

00046 How to Create Our Own KPI Key Performance Indicators Visual.mp4

09:45

00047 Extension on How to Create Our Own KPI Visual.mp4

09:13

00048 How to Make Interaction in Your Reports More Intuitive.mp4

09:19

00049 How to Add Visual Toop Tips to Images.mp4

08:12

00050 Power BI Trick Incremental Refresh Tables Using DAX.mp4

09:13

00051 Power BI Data Prep Challenge 1 - Date Time Conversion.mp4

13:34

00052 Power BI Data Prep Challenge 2 - Bulk Replacement of Text Values in One Shot.mp4

19:49

00053 Power BI Data Prep Challenge 3 - Count Customer Ratings and Sorting.mp4

09:51

00054 Power BI DAX Challenge 4 - How Many Subscriptions Do We Have Currently.mp4

15:03

00055 Power BI Data Prep Challenge 5 - Handling Missing Values in Power BI.mp4

10:29

00056 Power BI Data Prep Challenge 6 - How to Handle Various Local Date Types.mp4

10:23

00057 Power BI Data Prep Challenge 7 Currency Conversion - Exchange Rates for Specific.mp4

21:20

00058 Power BI Data Prep Challenge 8 - How to Fix the Pivoting Issue.mp4

10:25

00059 Advanced DAX - Price Changes in Power BI - Setting Up Our Data Model.mp4

11:18

00060 Advanced DAX - How to Handle Price Adjustments in Power BI.mp4

14:58

00061 Power BI DAX - How to Calculate Ages.mp4

08:34

00062 Advanced DAX - Total Open Customer Complaints in Power BI.mp4

09:40

00063 Additional Time Intelligence for Your Power BI Toolbox.mp4

17:33

00064 How to Automatically Always Show the Latest Data in Our Report.mp4

06:09

00065 Advanced DAX - Which Product was Ordered First by Each Customer.mp4

07:25

00066 R in Power BI - Visualizing Data Using R Scripts.mp4

10:06

00067 R in Power BI - Importing and Transforming Data with R Example.mp4

08:28

00068 R Visuals in Power BI - Let s Get a Little Help to Plot Amazing Visuals.mp4

03:19

00069 Advanced DAX - Which were the Last Products the Customer Ordered from Us.mp4

10:01

00070 Advanced DAX - Recurring Customers and Their Sales Calculation.mp4

07:59

00071 Let s Build Our Final Report.mp4

09:51

00072 A Quick Introduction to Publishing Reports to the Power BI Service.mp4

15:58

00073 How to Create a Dashboard in the Power BI Service Online.mp4

03:56

00074 Setting Up a Data Gateway to Refresh Local Files in the Power BI S.mp4

07:40

00075 Welcome - Let s Set Up the Data Model.mp4

14:10

00076 Setting Up Our Python Environment for Power BI.mp4

05:48

00077 Python for Data Visualization in Power BI.mp4

11:50

00078 Python for Data Visualization in Power BI Part2.mp4

10:36

00079 Python for Data Visualization in Power BI Part3.mp4

08:15

00080 How to Use Python in the Query Editor for Data Transformation in Power BI.mp4

12:59

00081 Import Data Via Python into Power BI.mp4

11:25

00082 Bonus - Let s Do Data Science in Power BI - A Little Case Study.mp4

16:17

00083 Learning DAX - Table Functions.mp4

15:07

00084 Learning DAX - Advanced Example for Table Functions in DAX.mp4

18:01

00085 Learning DAX - Evaluate Our New Customer Sales.mp4

10:33

00086 Learning DAX - How to Evaluate the Lost Customers.mp4

10:07

00087 Learning DAX - Dynamic Visualization and Disconnected Tables.mp4

10:23

00088 Learning DAX - Daily Sales Comparison When Having Gaps in Your Dataset.mp4

11:24

00089 Learning DAX - Show Top 3 Employees and Others.mp4

06:23

00090 Report Best Practice Cascading Filters Using DAX in Power BI.mp4

11:29

00091 Basic Model Structure Setup.mp4

16:30

00092 Let s Talk About Measures - Introduction to Tabular Editor.mp4

08:24

00093 The Switch Statement for Dynamic Measures Rehearsal.mp4

07:51

00094 Calculation Groups in Power BI - Let s Get Started.mp4

19:40

00095 Calculation Groups - Customize Helpful Settings.mp4

07:55

00096 Calculation Groups - Let s Explore a Different Use Case.mp4

10:21

00097 Best Practices Report Creation - Use Templates.mp4

07:31

00098 Let Us Talk About Performance - Best Practices.mp4

07:23

00099 Let Us Talk About Visuals.mp4

06:46

00100 Create Your First Own Custom Visual.mp4

16:18

00101 Bump Chart and Issues with Charticulator.mp4

13:07

00102 Visualization Tips and Tricks.mp4

02:31

00103 Merging Tables in Power BI - Tips and Major Pitfalls.mp4

14:38

00104 DAX Cohort Customer OrderDate Analysis.mp4

10:00

00105 DAX - Cohort Customer Order Analysis.mp4

06:31

00106 How to Get the Latest Refresh Time in Our Power BI Report.mp4

04:01

00107 DAX How to Get Different Formatting in the Same Column in Power BI.mp4

16:10

00108 AI Artificial Intelligence - Summarize Your Report in Power BI.mp4

07:18

00109 Log Out and Final Words.mp4

01:11

Power-BI-Masterclass-main.zip

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

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Power BI

Dan We

Instructor's Courses

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.

PacktPub

View courses PacktPub

Packt is a publishing company founded in 2003 headquartered in Birmingham, UK, with offices in Mumbai, India. Packt primarily publishes print and electronic books and videos relating to information technology, including programming, web design, data analysis and hardware.