Upgrade to Enterprise DNA On-Demand

JOIN THIS SUBSCRIBER-ONLY EVENT

POWER BI ACCELERATOR

10pm BST, April 10th - 13th, 2023

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

Register For This Live Session

Here's What You'll Get Through

This Accelerator Program

Over 4 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

Power BI Super Users Workshop
  • Time Commitment:
    - 4 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

Here's an outline of the

Power BI Accelerator Curriculum


DAY 1

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

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

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

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

What you get from participating in
an accelerator program

  • Access to 4 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
Power BI Super Users Workshop

This Accelerator Program is Tailored for:

Data Analysts

Reporting Managers

Excel Users

Your Instructor For This Accelerator Program

Sam McKay

Sam McKay

Sam is Enterprise DNA's CEO & Founder. He help individuals and organisations develop data driven cultures and create enterprise value by delivering business intelligence training and education on Microsoft’s Power BI platform

He partners with business decision makers and analysts across all industries and business functions.

  • Industries include: Financial Services, Consumer Goods, Energy, Retail, Insurance and others
  • Functions include: Finance, Accounting, Sales, HR, Marketing and more
  • People include: Directors, Executives, Team leaders, Analysts

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

Use our accelerator programs to further advance your career in data and analytics.

What our Students Say

Get full access to unparalleled training

& skill-building resources

For Individuals

Enterprise DNA

On-Demand

Empowering the most valuable Power BI users to expand their analytical thinking and insight generation possibilities

For Teams

Enterprise DNA

Center of Excellence

Training, tools, and guidance to unify and upskill the Power BI analysts in your workplace