How long do I have access to the course?

This resource is free and you may access it anytime.

Can I purchase a single course instead of the full Enterprise DNA membership

The option to purchase a single course has been discontinued. To access any of our courses, you will need to upgrade to full membership

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 Membership or CoE access to receive support.

What if I need to train my team?

We recommend exploring Enterprise DNA Center of Excellence platform

Upgrade to Enterprise DNA Membership

Power BI Accelerator

June 16 - 21

2pm Los Angeles (PDT)
5pm New York (EDT)
10pm London (BST)

June 17 - 22

7am Sydney (AEST)
9am Auckland (NZST)

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 Through

This Accelerator Program

Over 5 days, accelerate your Power BI skills within our unique learning experience.

Get personal guidance and experience during instructure lead sessions from global experts

Best practice frameworks for elevating your Power BI skillset and development techniques

Build the exact skills you need around Power BI in the fastest way possible

Time Commitment:
- 5 days
- 2 hour workshop each day
- 1 hour project based learning each day

Benefits:
- Condensed learning
- Collaborative environment
- Ask questions live
- Network with other data professionals

A UNIQUE LEARNING EXPERIENCE FROM ENTERPRISE DNA

What specifics will you learn during this Power BI Accelerator Program

Enterprise DNA‘s four pillar framework to mastering Power BI
Build your DAX and Power Query skills
Create solutions to practical and real-world scenarios
Implement best practices and techniques and data analytics implementation

Use correct DAX and Power Query functions
Understand the right approach to building your data model
Become more proficient in combining all of the key elements to a high-quality report

Join Power BI Accelerator Now

Here's an outline of the

Power BI Accelerator Curriculum

DAY 1

Power BI Super Users

Let's get started
Definition of Terms
Goals for this training
Resources we will be using in this course
Power BI Workshop Resource Pack
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

DAY 2

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

DAY 3

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

DAY 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

DAY 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

Join the Power BI Accelerator Now

What you get from participating in
an accelerator program

Access to 5 days worth of training with two hour live sessions each day
Ability to collaborate with other data analysts during the week during workshops and through projects
Access will be given to all replays and instructor-led Q&A‘s will be available throughout the program
A certification to showcase your participation and learning experience
Tons of resources and directions to maintain your skills through time
Live support throughout the week to improve your skills and development abilities

Join Here Now

This Accelerator Program is Tailored for:

Data Analysts

Reporting Managers

Excel Users

Your Instructor For This Accelerator Program

Reid Havens

Reid is a Microsoft Most Valued Professional (MVP), providing deep-level business analysis, data reporting, database development, and project management services working with large multi-national corporations, local companies, nonprofits, and many Fortune 50, 100, and 500 companies.

He has an extensive formal background in technology and organizational management, having earned his master’s in leadership, organizational development, and business analytics.

There is no faster way to build your practical skills and make a difference within your teams than by attending one of our accelerator programs