English | MP4 | AVC 1920×1080 | AAC 44KHz 2ch | 3h 55m | 1.78 GB
Achieve the next level of Microsoft Business Intelligence Power BI
In a world of data, business intelligence and business analytics are in high demand. Companies are constantly searching for ways to make better and faster and smarter decisions. This heavily involves getting insights from their data. Whether you’re a small company or a multinational, data-driven decision making is the key to success for any business in the world of tomorrow. Because of that companies are drastically looking out for skilled employees and freelancers worldwide with the necessary capabilities to help them analyze and understand their data. It is a “War for talent”. This offers tremendous job opportunities for all who are interested in the topic and want to dive into it. MS Power BI is an advanced yet easy to get started self service business analytics / business intelligence solution provided by Microsoft which is currently in very hot demand. Gartner has labelled Power BI as a leader in their BI quadrant – and considers Power BI visionary. The author’s experience is that companies will more and more replace old Powerpoint and standard Excel with Power BI. We are already in the process towards this data-driven future. That is why Daniel created his 6 hour Power BI Masterclass – Beginners to Advanced (master self-service business intelligence in no time) course which is his first course to help you get started 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!
Together we continue our journey and increase our knowledge 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.
What You Will Learn
- Create powerful and outstanding reports to create the wow effect
- Improve the 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 will prepare you to start your data analytics career
Table of Contents
Let’s get into it! Together we make it happen!
1 Introduction – Why are you here and what we will accomplish here
2 Think with the end in mind
3 Datapreparation – Dataset and setup for diving into DAX
DAX in Microsoft Power BI
4 DAX – the basic calculations we need
5 DAX – timeintelligence – Find out your cummulative Sales
6 DAX – How to get the past Sales
7 DAX – How to compare any timeframe
8 DAX – How much did we sell on the first day last day and in between
9 DAX – How to do moving averages
10 DAX – How to compare selected countries
11 DAX – What’s my best selling day on average
12 DAX – Do I depend on my top sales people
13 How many customers did we lose
14 DAX or not to DAX that is the question
Report best practices and WOW effect
15 Reports creation – how to create different views on your data
16 Report creation – how to show further details on specific data
The final part
17 Leverage multiple data inputs
18 Bonus DAX – Apples to apples comparison in time periods
19 The final report part 1
20 the final report part 2
21 Thanks, wrap up and final words for now
Resolve the captcha to access the links!