Power BI
Super Users Workshop
An in-depth overview of the entire Power BI suite, with a focus on using Power BI to extract compelling insights from your own data
Here's What You'll Get With The Course
More than 6 hours of self-paced video training
Resource pack with 1x demo data set and 1x pbix file
Six review quizzes
One final assessment
9.5 CPE Credits Awarded
A complete overview of the various different parts of Power BI Desktop, Power BI online service, and Power BI mobile applications.
- Review of the best practice techniques on how to develop reports in Power BI desktop
- Techniques on how to use Power BI within your organization by harnessing the online service features
- A step-by-step process on how to develop dynamic reports, following the 4 pillars of Power BI development: data loading and transformation, data modeling, DAX calculations, reports and visualizations
- Program Level - Basic
- Field(s) of Study - Computer Software & App
- Instruction Delivery Method - QAS Self-study
- Prerequisites - Power BI account and possess reporting and analytical skills. No other advance preparation
Details Of What You Will Learn
During This Course
- Recognize - the key components of Power BI and the important features across the entire Power BI suite
- Link - the steps on how to bring in data from different sources into Power BI and transform the data in the Query Editor
- Distinguish - the process of setting up and managing data relationships for the data model
- Identify - appropriate DAX measures for your analysis
- Identify - the process of customizing reports using color themes, grids and custom visuals
- Determine - how to share report publicly using the Publish to Web feature
This Course Module is Tailored for:
Data Analysts
Reporting Managers
Excel Users
Participants of this module should have a Power BI account and possess reporting and analytical skills. It is recommended to have completed the Ultimate Beginners Guide to Power BI and DAX modules. No other advance preparation is needed to take this course.
LEARN HOW TO
Utilize the key features
within Power BI
- Upscale reporting that delivers comprehensive analysis and insights
- Develop dynamic reports
- Data loading and transformation
- Data modeling
- DAX calculations
- Reports and visualizations
Course Curriculum
1. Power BI Super Users Workshop
- Let's get started
- Definition of Terms
- Goals for this training
- Resources we will be using in this course
- Power BI Workshop Resource Pack
2. Introduction
- Power BI explained
- Why reporting in Power BI is better than in excel
- Why you are now building analytical solutions
- 4 Pillars of high quality Power BI solutions
- Review Question
- Review Question Feedback
3. Querying and Transforming Data
- What is the query editor?
- The essential way to source data for Power BI
- Fundamentals of using the query editor
- Querying multiple data sources in the same model
- Best practices for transforming data in the query editor
- Row & Column transformations
- Making sure data types are correct
- Create groups for your queries
- What is 'M' and why do you need to have an understanding
- Query dependencies
- Importance of date tables
- Review Question
- Review Question Feedback
2. Data Modeling
- Introduction to the importance of the data model
- Where to manage relationships for your data model
- Understanding what types of tables you have & setup techniques
- Setting up relationships in your models
- Difference between active and inactive relationships
- Building out additional dimensions in your data
- Review Questions
- Review Question Feedback
4. DAX Calculations
- DAX explained & key techniques to learning it
- Getting started & naming conventions tips
- Calculated columns versus measures
- Creating a measure table & organizing your measures
- Context! - What is this?
- Evaluation (initial) context
- Aggregating formulas or filter context
- Iterating formula or row context
- Main table functions
- Building measures on measures (measure branching)
- CALCULATE function - the most important function in DAX
- Simple Time Intelligence functions
- More advanced DAX formula examples
- What you can achieve if you learn DAX well
- Review Question
- Review Question Feedback
5. Reports and Data Visualizations
- Design best practice tips
- Developing visualizations in Power BI
- How to create colour themes for your reports
- Visualization and report formatting
- Managing interactions between visuals
- Additional filtering across your reports
- Analytics automation features
- Importing custom visuals
- Review Question
- Review Question Feedback
6. Power BI Online Service
- How to publish your data to the web
- Power BI service explained
- Apps & Workspaces explained
- Reports vs Dashboards
- Email subscriptions, comments and other compelling features
- Q+A feature in-depth
- Admin settings within the online service
- Review Question
- Review Question Feedback
7. Tips for using Power BI within an organisation
- Enterprise architecture recommendations for Power BI
- Develop Power BI desktop templates to scale reporting requirements
- Row level security
- The Microsoft Power Platform
- Why Power BI is going to be huge!
Your Instructor
Sam McKay
Sam is the founder and CEO at Enterprise DNA, a business intelligence training & consultancy business primarily focused on driving better decision making within organizations 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 charter holder, achieving the designation in 2011.
He has a passion for building highly scalable analytical solutions within organizations and wants to see others learn how to do the same.
Enterprise DNA is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org
Enterprise DNA is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org
Frequently Asked Questions
- How do I cancel my subscription? Cancellation of On-Demand subscription is possible by sending an email to [email protected].
- Who do I reach out to if I have questions or concerns on this course? If you have any question/s about the training content, please initiate a thread in the Enterprise DNA Forum. But if your concern is about your access or subscription, please reach out to our team at [email protected].
- How can I access the course? You can access this course by purchasing an Enterprise DNA On-Demand Subscription.
- Are refunds available if I want to cancel my subscription? If for valid reason you wish to cancel your yearly subscription and would like to process a refund, you may do so within 30 days after purchase. All you need to do is email [email protected].
Get full access to unparalleled training
& skill-building resourcess
For Individuals
Enterprise DNA
On-Demand
Empowering the most valuable data analysts to expand their analytical thinking and insight generation possibilities
For Teams
Enterprise DNA
For Business