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

July 17 - 21

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

July 18 - 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

Coming Soon

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

Coming Soon

Here's an outline of the

Power BI Accelerator Curriculum

DAY 1

Power BI Overview

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

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

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

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

Main table functions
Iterating formula or row context
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

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

Coming Soon

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

Coming Soon

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