Video description
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 advanced yet easy to get started self-service business analytics/business intelligence solution provided by Microsoft and it's currently in very hot demand. Daniel can confirm that companies will actively be searching for you if you master Power BI. 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.
What You Will Learn
- 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
Audience
You may want to become better at your job or explore a new career opportunity. You want to master self-service BI. You might want to get valuable insights from you data. You want to be in high demand (as employee or freelancer). You want to succeed in the working world of tomorrow. You want to create stunning visualizations to impress management or your coworkers. You want to stand out from the crowd. You want to learn and to improve.
About The Author
Dan We: Daniel Weikert is a 33-year-old entrepreneur, data enthusiast, consultant, and trainer. He is a master’s degree holder certified in Power BI, Tableau, Alteryx (Core and Advanced), and KNIME (L1–L3).
He is currently working in the business intelligence field and helps companies and individuals obtain vital insights from their data to deliver long-term strategic growth and outpace their competitors.
He has a passion for learning and teaching. He is committed to supporting other people by offering them educational services and helping them accomplish their goals, gain expertise in their profession, or explore new careers.
Publisher resources
Table of contents
-
Chapter 1 : Let's get into it! Together we make it happen!
- 0 Introduction - Why are you here and what we will accomplish here
- 0.5 Think with the end in mind
- 1 The Power BI interface -what you need to know
- 2 Power BI Masterclass - the easy way 1
- 3 Power BI Masterclass - the easy way 2
- 4 The Query Editor - clean up messy data
- 5 Start exploring the Editor
- 6 Time intelligence - How to create datetables in Power BI
- 7 Query Editor Transformations
- 8 Advanced transformation techniques
- 9 Special bonus lecture in advanced transformation techniques
- 10 Views in Power BI - the relationship view
- 11 Introduction to calculations in Power BI Desktop
- 12 The measure table trick
- 13 DAX calculations continuation
- 14 The power of Power BI - Context and Dimensions
- 15 Advanced Dax - Time Intelligence
- 16 Visualizing your findings
- 17 A view on the generated report
- 18 Custom visualizations - let's try something new
-
Chapter 2 : Advanced Dax Section
- 19 Advanced Dax - Data preparation
- 20 Advanced Dax - Time intelligence continuation
- 21 Advanced Dax - Time intelligence the third
- 22 Advanced Dax - What are my Top Customers by Product?
- 23 Advanced Dax - A year over year comparison
- 24 - Which countries contributed most to our sales
- 25 Advanced Dax - Scenario Analysis Price and Volume changes
- 26 Advanced Dax - Running Total Sales last 30 days
- 27 Advanced Dax - How to get the Top 10 clients
- 28 Advanced Dax - At which weekday did most Customer buy
- 29 Advanced Dax or not Advanced Dax - that is the question
- 30 Advanced Dax - What percentage did my top 5 customers contribute
- 31 Advanced Dax - How much did we sell on working days / weekends
- The final report creation
- Chapter 3 : Student questions and Teaser for Power BI Masterclass 2 Expand Excellence
Product information
- Title: Power BI Masterclass - Beginners to Advanced
- Author(s):
- Release date: June 2018
- Publisher(s): Packt Publishing
- ISBN: 9781789533095
You might also like
video
Power BI Masterclass
Microsoft Power BI is an advanced yet easy-to-get-started self-service business analytics/business intelligence solution. Power BI is …
video
The Complete Excel Guide: Beginners to Advanced
Everyone knows that the Microsoft Office suite is used by millions worldwide. Unlocking its full potential …
video
Microsoft Power BI - The Complete Masterclass [2023 EDITION]
Microsoft Power BI is an interactive data visualization software primarily focusing on business intelligence, part of …
video
Introduction to Microsoft Power BI (Video)
7+ Hours of Video Instruction Discover how you can use Power BI to help your organization …