Power BI Masterclass

Name: Power BI Masterclass
Price: 134.99 USD
Rating: 3.0 (1 reviews)
Author: Packt Publishing

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.

updated on icon Updated on Sep, 2023

language icon Language - English

person icon Packt Publishing

architecture icon Development,Power BI

Add to Cart Buy Now

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 19,000+ top Tutorialspoint courses anytime, anywhere.

Course 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

Audience

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

Goals

What will you learn in this course:

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

Curriculum

Check out the detailed breakdown of what’s inside the course

DAX, Excel, and More
23 Lectures

Introduction 00:41 00:41
Set Up the Data Model 14:12 14:12
Learning DAX: Does the Pareto Rule Apply for Our Dataset 14:39 14:39
Calculate Our Base Measures 04:32 04:32
Learning DAX: Sales Forecast on Prior 3 Months Average 06:46 06:46
Learning DAX: Customer Transactions Within the Last 30 Days 08:04 08:04
Learning DAX: Customer Classification with Custom Label Calculation 10:09 10:09
Learning DAX: Dynamic Measure Comparison in Power BI 11:45 11:45
Power BI Tip - How to Remove All Filters from the Report with One Click 07:43 07:43
Growth Insights - Profit and Sales Evaluation for Customer Base 07:23 07:23
Learning DAX: Model Structure Challenge Applying Bridge Tables 22:02 22:02
Learning DAX: Calculated Columns for Employee Sales Classification 09:07 09:07
Learning DAX: Dynamic Calculation of Sales for the Last X Days 11:24 11:24
Export Data into csv and Excel 02:45 02:45
Learning DAX: Advanced Searching in Power BI 11:57 11:57
Idea - Animate Our Power BI Reports 07:26 07:26
QA Feature Introduction in Power BI 13:38 13:38
Global Filters in Power BI Synchronize Slicers Across Report Pages 09:28 09:28
Learning DAX: How to Replace Calculate with Iterators 10:32 10:32
Learning DAX: Customer Ranking on Multiple Criteria 12:36 12:36
Learning DAX: Fixing Total Issues in Dynamic Visualizations 15:10 15:10
Learning DAX: How to Build a Pareto Chart Step-By-Step 18:04 18:04
Cluster Analysis in Power BI 05:49 05:49

Additional Tips and Tricks
27 Lectures

Solving Data Prep Challenges
8 Lectures

DAX, R, and Gateways
16 Lectures

Python Finance and Advanced DAX
16 Lectures

The Next Level
19 Lectures

Instructor Details

Packt Publishing

Founded in 2004 in Birmingham, UK, Packt's mission is to help the world put software to work in new ways, through the delivery of effective learning and information services to IT professionals.

Working towards that vision, we have published over 6,500 books and videos so far, providing IT professionals with the actionable knowledge they need to get the job done - whether that's specific learning on an emerging technology or optimizing key skills in more established tools.

As part of our mission, we have also awarded over $1,000,000 through our Open Source Project Royalty scheme, helping numerous projects become household names along the way.