Description

Power BI Super Users Workshop Download Now

An in depth overview of the entire Power BI suite, with a focus on using Power BI to extract compelling insights What you’ll learn:
Learn the background of how Power BI got to its current form
Optimize the use of the key features across the entire Power BI suite
Utilize Power BI effectively
Master the 4 pillars to developing analytical solutions in Power BI Desktop
Practice loading & transforming data, data modelling, DAX calculations & report development
Build analytical models using theoretical and practical concepts
Utilize DAX formulas and advanced DAX techniques for analysis
Develop reports that look compelling and showcase quality insights
Use the online service as a distribution mechanism for your analysis
Implore best practice tips for using Power BI within your organizations

Requirements
Microsoft Power BI Desktop account
Reporting and analytical skills
Basic knowledge on Power BI and DAX

Description
An outline of this training course

This training course gives a beginner to intermediate user of Power BI a complete overview of the various different parts of Power BI Desktop, Power BI online service and Power BI mobile applications. Reviewed are best practice techniques in how to develop reports in Power BI desktop and then how to use Power BI within your organization by harnessing the online service features.

Details of what you will learn during this course

Learn – the background of how Power BI got to its current form

Understand – the key features across the entire Power BI suite

Learn – the ‘must knows’ around how to use Power BI effectively

Master – the 4 pillars to developing analytical solutions in Power BI Desktop

Practice – loading & transforming data, data modelling, DAX calculations & report development

Grasp – theoretical and practical concepts of building analytical models

Review – DAX formulas and how to put these into practice in your analysis

Learn – some advanced DAX techniques

Learn – how develop reports that look compelling and showcase quality insights

Understand – how to use the online service as a distribution mechanism for your analysis

Learn – best practice tips for using Power BI within your organizations

What you get with the course

6 hours of course videos

1x demo data set to use alongside the course instructions and examples

1x Power BI file (pbix file) downloads showcasing all the examples used during the course

Here are the specifics for the course

Receive an introduction and overview of the entire Power BI suite of tools

Key components of Power BI, including a deep dive into Power BI desktop

Deep dive into the 4 pillars of high quality Power BI development

Learn how to load and transform data in the query editor

Learn simple to advanced query transformation techniques

Query data from multiple data sources at the same time

Review how important and how to implement a high quality date table

Introduction to data modelling

Learn how to create relationships between tables and about different type of relationships

Beginner concepts of DAX calculations

Key techniques to understanding DAX – evaluation, filter & row context

Some advanced concepts and techniques for implementing DAX formula

Data visualizations techniques and best practice report design techniques

Online service deep dive into the best consumption and distribution features

Tips for using Power BI within organizations effectively

Testimonials

“I’ve found DAX really hard, but it makes far more sense now. The explanations are clear and more simplified than I’ve read and watched elsewhere which is what I needed. The examples are great too.” – Scott T. – Michigan

“I’ve been looking for resources like this everywhere but couldn’t find any. So good to have these all in one place, with detailed explanations on how to build this myself. Seriously awesome stuff.” – Renee M. – Melbourne

“I just started learning Power BI with the courses on this page and they are awesome and easy to follow and understand, even if English is not your origin language..” – Álvaro, Chile

For more testimonials and to see how Enterprise DNA is helping thousands more Power BI users, check out the testimonial wall on Enterprise DNA’s website

Other details

Number of Recommended CPE credits: 15.0

Field(s) of Study: Computer Software & App

Course Level: Beginner

Participants of this module should have reporting and analytical skills. It is recommended to have completed the Ultimate Beginners Guide to Power BI and DAX modules. No other advance preparation needed to take this course.

This course module is tailored to: Excel users, data analysts, reporting managers

This course was last updated on January 2021.

Who this course is for
Data analyst who are users of Power BI who want to level-up their skills
Excel users who want to explore the capabilities of Power BI
Report managers who want to elevate their reporting and analysis