by Daniel We | Released June 2018 | ISBN: 9781789534276

Achieve the next level of Microsoft Business Intelligence Power BIAbout This VideoIt's recommended to take the Beginners to Advanced Masterclass course first. This course extends the learning from Daniel's first MIcrosoft BI courseHow to gain deeper insights in your data from a time aspectHow to evaluate your sales peopleAdditional advanced DAX measures which have not been covered in the first course yetHow to apply best practices when creating dashboardsHow to improve the look and feel of your report to wow your audienceIn DetailIn 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! Show and hide more

1. Chapter 1 : Let's get into it! Together we make it happen!
   • Introduction - Why are you here and what we will accomplish here? 00:01:35
   • Think with the end in mind 00:01:52
   • 1 Datapreparation - Dataset and setup for diving into DAX 00:19:02
2. Chapter 2 : DAX in Microsoft Power BI
   • 2 DAX - the basic calculations we need 00:08:29
   • 3 DAX - timeintelligence - Find out your cummulative Sales 00:12:12
   • 4 DAX - How to get the past Sales 00:07:46
   • 5 DAX - How to compare any timeframe 00:12:48
   • 6 DAX - How much did we sell on the first day last day and in between 00:18:18
   • 7 DAX - How to do moving averages 00:07:12
   • 8 DAX - How to compare selected countries 00:11:16
   • 9 DAX - What's my best selling day on average 00:09:00
   • 10 DAX - Do I depend on my top sales people 00:09:19
   • 11 How many customers did we lose 00:13:51
   • 12 - DAX or not to DAX that is the question 00:06:59
3. Chapter 3 : Report best practices and WOW effect
   • 13 Reports creation - how to create different views on your data 00:14:01
   • 14 - Report creation - how to show further details on specific data 00:17:34
4. Chapter 4 : The final part
   • 15 Leverage multiple data inputs 00:24:23
   • 16 Bonus DAX - Apples to apples comparison in time periods 00:09:33
   • 17 The final report part 1 00:17:18
   • 18 the final report part 2 00:11:41
   • 19 Thanks, wrap up and final words for now 00:01:01
Show and hide more