Power BI Super Users Workshop
- Description
- Curriculum
- FAQ
- Reviews
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.
-
1Goals for this trainingVideo lesson
-
2Resources we will be using in this courseVideo lesson
-
3Power BI explainedVideo lesson
-
4Why reporting in Power BI is better than in excelVideo lesson
-
5Why you are now building analytical solutionsVideo lesson
-
64 Pillars of high quality Power BI solutionsVideo lesson
-
7What is the query editor?Video lesson
-
8The essential way to source data for Power BIVideo lesson
-
9Fundamentals of using the query editorVideo lesson
-
10Querying multiple data sources in the same modelVideo lesson
-
11Best practices for transforming data in the query editorVideo lesson
-
12Row & Column transformationsVideo lesson
-
13Making sure data types are correctVideo lesson
-
14Create groups for your queriesVideo lesson
-
15What is 'M' and why do you need to have an understandingVideo lesson
-
16Query dependenciesVideo lesson
-
17Importance of date tablesVideo lesson
-
18Introduction to the importance of the data modelVideo lesson
-
19Where to manage relationships for your data modelVideo lesson
-
20Understanding what types of tables you have & setup techniquesVideo lesson
-
21Setting up relationships in your modelsVideo lesson
-
22Difference between active and inactive relationshipsVideo lesson
-
23Building out additional dimensions in your dataVideo lesson
-
24DAX explained & key techniques to learning itVideo lesson
-
25Getting started & naming conventions tipsVideo lesson
-
26Calculated columns versus measuresVideo lesson
-
27Creating a measure table & organising your measuresVideo lesson
-
28Context! - What is this?Video lesson
-
29Evaluation (initial) contextVideo lesson
-
30Aggregating formulas or filter contextVideo lesson
-
31Iterating formula or row contextVideo lesson
-
32Main table functionsVideo lesson
-
33Building measures on measures (measure branching)Video lesson
-
34CALCULATE function - the most important function in DAXVideo lesson
-
35Simple Time Intelligence functionsVideo lesson
-
36More advanced DAX formula examplesVideo lesson
-
37What you can achieve if you learn DAX wellVideo lesson
-
38Design best practice tipsVideo lesson
-
39Developing visualizations in Power BIVideo lesson
-
40How to create colour themes for your reportsVideo lesson
-
41Visualization and report formattingVideo lesson
-
42Managing interactions between visualsVideo lesson
-
43Additional filtering across your reportsVideo lesson
-
44Analytics automation featuresVideo lesson
-
45Importing custom visualsVideo lesson
-
46How to publish your data to the webVideo lesson
-
47Power BI service explainedVideo lesson
-
48Apps & Workspaces explainedVideo lesson
-
49Reports vs DashboardsVideo lesson
-
50Email subscriptions, comments and other compelling featuresVideo lesson
-
51Q+A feature in-depthVideo lesson
-
52Admin settings within the online serviceVideo lesson
External Links May Contain Affiliate Links read more