Power BI Masterclass

Name: Power BI Masterclass- Basics to Advanced
Rating: 4.2 (192 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 Apr, 2024

language icon Language - English

person icon Packt Publishing

English [CC]

category icon Development,Power BI

Lectures -109

Duration -19 hours

4.2 ★★★★ ★

Add to Cart Buy Now

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

Microsoft Power BI is a sophisticated yet simple-to-use self-service business analytics/business intelligence tool. Power BI is an excellent data science tool and it is popular among data scientists for use in visualizing and presenting the results. So, knowing how to utilize this tool can be a useful ability for positions in data science.

Power BI Masterclass Overview

The course consists of six sections. In order to master Data Analysis Expressions (DAX), the formula expression language used in Power BI Analysis Services, we will first need to comprehend DAX table computations with Power BI Desktop and Excel. We will learn Microsoft Power BI tips and tricks from project experience and research in the second segment. We will address difficulties involving data preparation in the third section. We will learn how to perform complex DAX calculations in the fourth session, building on the skills you already have.

We will combine data science tools like Python with Power BI in part five. Power BI best practices, Power BI Calculation Groups, Power BI Charticulator, Power BI performance advice, and Power BI AI will all be covered in the last segment.

You will be equipped with the knowledge and abilities necessary to use Power BI to analyze and comprehend data once this course is complete.

The complete course bundle is available at https://github.com/PacktPublishing/Power-BI-Masterclass

Complete beginners are not intended for the course. You ought to be familiar with Power BI already. Data analysts and anyone pursuing a career in data analytics should take this course.

Goals

What will you learn in this course:

DAX Logic and Table Calculations are understood
Use project experience and research to learn Power BI tips and methods.
Fix typical Power BI data preparation problems
Discover how to enhance the appearance and feel of standard dashboards.
Integrate Power BI with data science tools like Python.
See how to begin producing your own unique images without coding.

Prerequisites

What are the prerequisites for this course?

Basic understanding of data concepts and data visualization

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