Power BI Super Users Workshop
What you'll learn
- Learn the background of how Power BI got to its current form
- Optimize the use of the key features across the entire Power BI suite
- Utilize Power BI effectively
- Master the 4 pillars to developing analytical solutions in Power BI Desktop
- Practice loading & transforming data, data modelling, DAX calculations & report development
- Build analytical models using theoretical and practical concepts
- Utilize DAX formulas and advanced DAX techniques for analysis
- Develop reports that look compelling and showcase quality insights
- Use the online service as a distribution mechanism for your analysis
- Implore best practice tips for using Power BI within your organizations
- Microsoft Power BI Desktop account
- Reporting and analytical skills
- Basic knowledge on Power BI and DAX
An outline of this training course
This training course gives a beginner to intermediate user of Power BI a complete overview of the various different parts of Power BI Desktop, Power BI online service and Power BI mobile applications. Reviewed are best practice techniques in how to develop reports in Power BI desktop and then how to use Power BI within your organization by harnessing the online service features.
Details of what you will learn during this course
Learn - the background of how Power BI got to its current form
Understand - the key features across the entire Power BI suite
Learn - the 'must knows' around how to use Power BI effectively
Master - the 4 pillars to developing analytical solutions in Power BI Desktop
Practice - loading & transforming data, data modelling, DAX calculations & report development
Grasp - theoretical and practical concepts of building analytical models
Review - DAX formulas and how to put these into practice in your analysis
Learn - some advanced DAX techniques
Learn - how develop reports that look compelling and showcase quality insights
Understand - how to use the online service as a distribution mechanism for your analysis
Learn - best practice tips for using Power BI within your organizations
What you get with the course
6 hours of course videos
1x demo data set to use alongside the course instructions and examples
1x Power BI file (pbix file) downloads showcasing all the examples used during the course
Here are the specifics for the course
Receive an introduction and overview of the entire Power BI suite of tools
Key components of Power BI, including a deep dive into Power BI desktop
Deep dive into the 4 pillars of high quality Power BI development
Learn how to load and transform data in the query editor
Learn simple to advanced query transformation techniques
Query data from multiple data sources at the same time
Review how important and how to implement a high quality date table
Introduction to data modelling
Learn how to create relationships between tables and about different type of relationships
Beginner concepts of DAX calculations
Key techniques to understanding DAX - evaluation, filter & row context
Some advanced concepts and techniques for implementing DAX formula
Data visualizations techniques and best practice report design techniques
Online service deep dive into the best consumption and distribution features
Tips for using Power BI within organizations effectively
"I've found DAX really hard, but it makes far more sense now. The explanations are clear and more simplified than I've read and watched elsewhere which is what I needed. The examples are great too." - Scott T. - Michigan
"I've been looking for resources like this everywhere but couldn't find any. So good to have these all in one place, with detailed explanations on how to build this myself. Seriously awesome stuff." - Renee M. - Melbourne
"I just started learning Power BI with the courses on this page and they are awesome and easy to follow and understand, even if English is not your origin language.." - Álvaro, Chile
For more testimonials and to see how Enterprise DNA is helping thousands more Power BI users, check out the testimonial wall on Enterprise DNA's website
Number of Recommended CPE credits: 15.0
Field(s) of Study: Computer Software & App
Course Level: Beginner
Participants of this module should have reporting and analytical skills. It is recommended to have completed the Ultimate Beginners Guide to Power BI and DAX modules. No other advance preparation needed to take this course.
This course module is tailored to: Excel users, data analysts, reporting managers
This course was last updated on January 2021.
Who this course is for:
- Data analyst who are users of Power BI who want to level-up their skills
- Excel users who want to explore the capabilities of Power BI
- Report managers who want to elevate their reporting and analysis
Enterprise DNA empowers analysts and teams to raise their standard of reporting and analysis from basic to high value through our customized learning pathways, skills assessment tools, comprehensive resources, well-structured online training, and support community.
For over five years, we have trained our students to unlock the potential of their data and demystify Power BI as a business intelligence tool; turning over 100,000 data professionals into Power BI authorities.
Power BI is an amazingly powerful analytical tool. Harnessing its potential can create so many possibilities and Enterprise DNA can guide you in the journey.
"I 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, I was amazed that I could re-create most of those things about 10% of the time with Power BI."
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.
With a strong history in Finance, previously working at ANZ, PIMCO, and Fonterra. A CFA charterholder, achieving the designation in 2011.
With passion for building highly scalable analytical solutions within organisations, and wants to see others learn how to do the same.