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
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
- 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
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
This Accelerator Program is Tailored for:
Data Analysts
Reporting Managers
Excel Users
Your Instructor For This Accelerator Program
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.
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