Learn how to clean, optimize and model data tables to develop effective, insightful and actionable Power BI reports. This course covers in detail the query editor and how to develop effective Power BI data models.
Develop an effective reporting solution by mastering two important areas in Power BI
Intermediate to advanced techniques that enable you to optimize your raw data tables and then connect them into a functioning analytical model to get the correct results that will answer your analytical questions
Participants of this module should have basic knowledge and understanding of how to use Power BI and DAX. It is recommended to have completed the Ultimate Beginners Guide to Power BI and DAX, and the Power BI Super Users Workshop modules. No other advance preparation needed to take this course.
LEARN HOW TO
Utilize the key features within Power BI
Utilize the query editor to clean up and optimize your raw data tables
Learn the great functionality hidden away in the query editor
Implement advanced transformation techniques to improve your solutions
Organize your queries so you can manage complexity
Manage tables of data from multiple different data sources
Design and execute on an effective data model
Analytical think about your data model and then create the correct relationships
Lay out your data model so it is designed intuitively
Sam very early on saw the immense opportunity of using Power BI to create analytical solutions. After years of developing some advanced analysis and tools in excel, he was amazed that he could re-create most of those things in about 10% of the time with Power BI.
He is the founder and CEO at Enterprise DNA, a business intelligence training & consultancy business primarily focused on driving better decision making within organisations by empowering individuals and teams to transform raw data into unmatched insights using Microsoft's Power BI suite of tools.
Sam has a strong history in Finance, previously working at ANZ, PIMCO, and Fonterra. He is also a CFA charterholder, achieving the designation in 2011.
He has a passion for building highly scalable analytical solutions within organisations, and wants to see others learn how to do the same.
Frequently Asked Questions
How long do I have access to the course? You have access to this course as long as you have Enterprise DNA On-Demand Subscription.
Can I purchase a single course instead of the Enterprise DNA On-Demand? The option to purchase a single course has been discontinued. To access any of our courses, you will need to upgrade to full On-Demand Subscription here.
Do you offer one-off support or coaching? All support around Power BI and Enterprise DNA's online training content now occurs at the Enterprise DNA Forum. You must have an Enterprise DNA On-Demand Subscription or CoE access to receive support.
What if I need to train my team? We recommend exploring Enterprise DNA Center of Excellence platform. To learn more, see here.