English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 105 lectures (20h 18m) | 8.24 GB
Microsoft Power BI How to learn Power BI fast. The best Power BI Training online for beginners. Best Master Class
Microsoft Power BI in 12 hours beginners to advanced
Business Intelligence / Business Analytics is in high demand. Companies are constantly searching for ways to make better and faster decisions. Therefore they rely heavily on data. Data driven decision making is the key to success for any business in the world of tomorrow.
Because of that companies are constantly searching for skilled employees and freelancers with the necessary capabilities to help with analyzing data and creating valuable highly profitable insights. This will be the key advantage to succeed in business.
MS Power BI is an andvanced yet easy to get started self service business analytics / business intelligence solution provided by Microsoft which is currently in very hot demand. From my personal experience I can tell you that companies will actively searching for you if you master Power BI. Diving into data & analytics can not only immensly improve your career opportunities but also your job satisfaction!
Power BI is also a great tool for datascience too. A lot of data scientists like to use it for visualizing and presenting the findings. Therefore learning to use this tool can also be a valuable skill for datascience jobs.
That is why I created this course to help you get started to dive into on of the hottest and best business analytics / business intelligence software currently out there. Starting from scratch we will learn all the relevant PBI basics and also master more advanced concepts step by step. Power BI has a very strong active community and with Microsoft pushing this solution to it’s enterprise customers, Power BI has a bright future ahead. And you can be part of this future!
There is no coding required! Power BI allows you to do that but it’s not necessary.
In this guided learning course you will start form zero to hero in 6 hours and you will learn:
- the ETL capabilities of Microsoft Power BI (“get messy data easily into the right format”)
- Master simple and very advanced DAX (Power BI language, similar to like excel formulas) calculations
- Create outstanding visualisations and reports
- Derive valuable highly profitalbe insights
What we learn in this course might also help you later with your Power BI certification exam.
You can follow along with the provided learning material in Power BI on your own computer at your own pace. Much better then only reading a book right? Exited? You should be. So how to learn Microsoft Power BI Desktop? Buckle up and meet me in the first lecture starting today!
What you’ll learn
- Taking the Power BI Masterclass series on udemy will prepare you to start your data analytics career
- You can quickly create stunning reports in Power BI
- You can transform messy data into the right format
- You can generate valuable insights for yourself and your company
- You can improve strategic decision making and create competitive advantages
- You can write powerful advanced Dax calculations in Microsoft Power BI
- You can design Power BI Reports
- You can create Power BI Dashboards (Reports) in no time
- Please note! Mac Users have currently only the option to use Power BI via the Power BI Service in their browser (some limitations ) or with Turbo
Table of Contents
The Power BI Masterclass – Updated
1 The Power BI Masterclass 2022 lets get started
2 About this Update
3 Before you start
4 Download the latest course files here to follow along
5 If necessary enable the new format pane preview feature
6 A complete tour through the Power BI Interface
7 Our first Power BI Report lets get started
8 Finishing our first report
9 Power BI the more advanced way exploring the dataset
10 Preparing the dataset using Power Query Editor
11 How to create a proper Datestable in Power BI
12 Datatransformation and cleaning Lets explore the Power Query Editor
13 Data enrichment with web data extraction
14 Datamodel setup Modelview and Relationships
15 Introduction to calculated columns and measures in Power BI
16 The measures table trick
17 Creating DAX measures in Power BI practise round
18 Flexibility of DAX Measures why they are so great
19 Dates and Drilldown functionality in Power BI
20 Additional info to the Auto datetime feature in Power BI
21 Timeintelligence DAX Calculations in Power BI getting started
22 Timeintelligence DAX Calculations in Power BI more flexibility
23 Timeintelligence DAX Calculations Cumulative Sum or Running Totals
24 DAX Measure Cleanup and Formatting best practise
25 The final Power BI Report creation
26 Advanced Training 2 New dataset setup
27 Practising DAX measures and Bulk Formatting Tricks
28 DAX Timeintelligence different Functions allow different Insights
29 Ranking and dynamic Ranking in Power BI
30 Power BI DAX Expressions Cumulative Sales for the prior year
31 Introduction to Scenario Analysis in Power BI
32 Rolling 30 day Sales DAX Expression
33 DAX Table functions in Power BI lets get into it
34 Advanced DAX Top 10 Customers
35 Customer Insights How many customers by weekday
36 DAX or No DAX that is the question
37 Advanced DAX Customer Classification
38 Introducing Variables while calculating Weekday Sales
39 Lets create our final report
40 Addon Buttons and Page Navigation in Power BI
41 NEW – A free resource for bonus videos tips and tricks
42 Congratulations and Motivation
This is the slightly older part of section 1. Will be removed in the future
43 Power BI Masterclass – beginners to advanced Introduction
44 Download latest course files
45 A first tour through the Power BI Interface
46 Power BI the easy way – lets get started
47 Power BI the easy way lets finish our first report in Power BI Desktop
48 Power BI the advanced way – lets dive into our dataset
49 The Power BI Query Editor – Datapreparation in action
50 Import the new and advanced date table into our model
51 Walk through Transformation steps in Powerquery Editor
52 Data enrichment importing web data into Power BI
53 Exploring the Model View and setting up Relationships
54 First Calculations in Power BI Calculated Columns and Measures
55 The Measures Table Trick – Structuring our report
56 Power BI DAX – Practise creating further Measures
57 The Beauty of Flexibility – Power BI Slicing and Dicing
58 Date drill down functionalities in Power BI
59 Autodatetime in Power BI – What you need to know about Date hierarchies
60 Advanced Dax – Intro to Timeintelligence DAX Measures
61 Advanced Dax – Flexibility in Timeintelligence DAX Functions
62 Advanced Dax – Cumulative or Running Total Sales Calculation in DAX
63 Power BI Lets create our final report
64 Welcome to Part 2 Setting up our new model structure
65 Power BI DAX – creating our base measures
66 Advanced TimeIntelligence in DAX – Parallelperiod and potential use cases
67 Advanced DAX – Dynamic Sales Rankings
68 Advanced DAX – Running Total Sales and prior year sales
69 Power BI – visualizing insights from our data
70 Scenario Analysis in Power BI
71 Advanced DAX – Running Total X Day Sales
72 DAX – An Introduction to table functions
73 Advanced DAX What are the Top 10 Clients
74 Advanced DAX – How many Customers per Weekday
75 Power BI DAX or no DAX – that is the question
76 Advanced DAX – Customer Classification in Power BI
77 Advanced DAX – Variables and Sales per Weekday and Weekends
78 Create our final Report in Power BI
How to use CALCULATE in Power BI Desktop
79 About this section
80 Download latest course files for this section
81 Introduction to the CALCULATE function starting from scratch
82 Filter Contexts Row Context and Context Transition in Power BI explained
83 Combine Calculate with ALL and VALUES
84 Excourse dynamic selection with CALCULATE
85 How to apply multiple criteria filter with CALCULATE in Power BI
86 How to use multiple Filtercriteria with CALCULATE in Power BI OR
87 CALCULATE with multiple criteria from different columns in Power BI
88 Salesclassification using CALCULATE
89 Cleaning up and quickly set up the new model
90 Applying ALL and ALLSELECTED with CALCULATE in Power BI
91 CALCULATe with the Keepfilters modifier
92 Modify model relationships with CALCULATE
93 Using Context Transition with CALCULATE to evaluate the maximum sales on a da
94 Visual understanding of the expanded table concept
95 CALCULATE modifiers remove all filters except one
96 Using CALCULATE with Timeintelligence Expressions
Bonus section
97 Download resources for the bonus videos here
98 Bonus 1 How to improve your Reports even further with custom visuals a few examp
99 Bonus 2 How to publish and share your power bi Report
100 Bonus 3 How to create your own Datestable with DAX explore available Options
101 Bonus 4 Power BI Interview question SUM vs SUMX Difference
102 Bonus 5 Best and Worst Customer Identification and dynamic Sales Thresholds with
103 Power BI Masterclass 2 Expand Excellence Preview What we will learn
104 Power BI Bonus Tip Cascading slicers without bidirectional relationships
105 You want to become a Power BI Expert Here are more learning resources
Resolve the captcha to access the links!