Microsoft Power BI Masterclass - Expand Excellence
4.5 (474 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,437 students enrolled

Microsoft Power BI Masterclass - Expand Excellence

achieve the next Level of Business Intelligence with Microsoft Power BI Desktop. How to master Power BI Desktop
4.6 (469 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,437 students enrolled
Created by Dan We
Last updated 5/2020
English
English [Auto-generated]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4 hours on-demand video
  • 4 articles
  • 3 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Create powerful and outstanding reports - WOW effect
  • Improve look and feel of standard dashboards
  • Apply additional advanced DAX calculations
  • Apply tips and tricks when exploring data and creating reports
  • Taking the Power BI Masterclass series on udemy will prepare you to start your data analytics career
  • You can design Power BI Dashboards (Reports)
  • You can generate valuable insights for yourself and your company
Requirements
  • This course extends my compelentary courses e.g. "Power BI Masterclass - beginners to advanced"
  • It's the 2nd of total 6 courses of the complementary Power BI Masterclass Series to help students to dive into Data Analytics Jobs
  • I highly recommend to check out the beginners to advanced Masterclass course first
  • To get an indepth understanding of Power BI and it's unlimited possibilities check out the other five Power BI Masterclass courses as well
  • However everybody is free to join this course
  • Your willingness to learn and grow and explore new opportunities
Description

Microsoft Power BI in 4 hours - Expand Excellenc

Business Intelligence / Business Analytics is in high demand. Companies are constantly searching for ways to make better and faster and smarter decisions. Therefore they rely heavily on data. Small company or Multinational -  data driven decision making is the key to success for any business in the world of tomorrow.

Because of that companies are drastically increasing to step up their efforts to find skilled employees and freelancers with the necessary capabilities to help with analyzing data and creating valuable highly profitable insights. 

Since there is way more demand than supply it is a "War for talent". And the competition will increase further. This environment is a bless for anyone who acquires the necessary capabilities and positions herself/himself


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 the 6h Power BI Masterclass - beginners to advanced (master self service business intelligence in no time) course which is my first course to help you get started to dive into on of the hottest and best business analytics / business intelligence software currently out there. 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!

Because of the great feedback and the request from students to learn more and explore more DAX and best practices I decided to create this 4h follow up course Microsoft Power BI Masterclass - Expand Excellence. 

Together we continue our journey and increase our knowlege in DAX Calculations further to derive deep insights from our data. A great example dataset is included but you can also use your own data for exploration

In this course you will learn:

  • How to gain deeper insights in your data from a time aspect

  • How to evaluate your sales people

  • Additional advanced DAX measures which have not been covered in the first course yet

  • How to apply best practices when creating dashboards

  • How to improve the look and feel of your report to create the WOW Effect in your audience


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. Exited! You should be. So how to learn Microsoft Power BI Desktop? Buckle up and meet me in the first lecture starting today!


Update: The complete Power BI Masterclass Series on udemy

1.Power BI Masterclass - beginners to advanced

2.Microsoft Power BI Masterclass - Expand Excellence

3.Power BI Masterclass - Data Analysis Deep Dive

4.Business Intelligence with Microsoft Power BI

5.Power BI Masterclass - DAX, Excel And More

6.Power BI Masterclass - Your future in data analytics

7.Power BI Masterclass - Learn Advanced DAX, R and Gateways

8.Power BI Masterclass - Python, Finance and advanced DAX

9. Power BI Masterclass - How to use CALCULATE in DAX

Tips and Tricks courses:

10. The Power BI Masterclass - Tips and Tricks

11. The Power BI Masterclass - Additional Tips and Tricks

12. Power BI - Tips for your next data analytics project

13. Microsoft Power BI Desktop - simple tips and tricks edition

14. Power BI Desktop - Data Prep Challenges


 The complete Masterclass Series which covers all relevant features in Power BI consists these courses now. This one is the second class.The other consecutive classes are available here on udemy.  Each course covers additional DAX insights, Power BI features, tips and tricks and best practices in report creation and design. If you find this course helpful then feel free to check them out as well. You can easily find them by checking out my Instructor profile.

best regards and happy learning.

Who this course is for:
  • Students who have taken the "Power BI Masterclass - beginners to advanced"
  • You want to become better at your job OR explore a new career opportunity
  • You want get valuable insights from your data
  • You want to master self service bi
  • You want to extend your knowlege in advanced DAX calculations
  • You want to apply best practices and customization when creating reports
  • You want to expand excellence
  • You want to lay the foundations for a successful future in the era of data
Course content
Expand all 27 lectures 03:59:39
+ Let's get into Power BI 2020 - Together we make it happen!
22 lectures 02:54:21

Comment to video quality

One important thing before you start
00:46
Download all resources we need
00:01
3 Before we start first enable the new Interface if necessary
01:25
6 DAX Warm up - lets create the basic calculations we need
09:40
7 Advanced DAX - Timeintelligence with various cummulative sales timeframes
14:15
8 Additional Timeintelligence for our toolbox
05:28
9 Advanced DAX - Timeintelligence dynamic timeframe comparisons
10:49
10 Advanced DAX - Timeintelligence First and Lastday Sales
11:57
11 Advanced DAX - Moving Averages Timeintelligence in Power BI
06:10
12 Power BI DAX - All and Allselected example
08:22
Important information for the next lecture
00:16
13 Advanced DAX - Best selling weekday on average sales figures
11:04
14 Advanced DAX - Sales contribution of our top 3 employees
05:53
15 Advanced DAX - Customers with no sales within the last 90 days
12:03
16 Report Best practices - How to implement bookmarks to amaze your audience
17:22
17 Report Best practices - How to implement drillthrough features in Power BI
13:54
18 Lets build our final report and apply what we have learned
21:56
All Power BI Masterclass courses currently available on udemy
00:37
19 log out expand excellence
00:54
+ additional videos (old interface but still working for your learning journey)
5 lectures 01:05:18
Bonus - How to create a KPI
13:12
15 Leverage multiple data inputs
24:22
Bonus How to create Datestables in DAX
08:20

This file was part of the first Power BI Masterclass - beginners to advanced

Bonus - SUMX vs SUM in Power BI Whats the difference and when to use which examp
09:48
BONUS - How to create your own BUMP chart in Power BI
09:36