• Post category:StudyBullet-3
  • Reading time:11 mins read


An in depth overview of the entire Power BI suite, with a focus on using Power BI to extract compelling insights

What you will 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

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


Get Instant Notification of New Courses on our Telegram channel.


  • 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.

English
language

Content

Introduction
Goals for this training
Resources we will be using in this course
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
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 & organising your measures
Context! – What is this?
Evaluation (initial) context
Aggregating formulas or filter context
Iterating formula or row context
Main table functions
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
Power BI Online Service
How to publish your data to the web
Power BI service explained
Apps & Workspaces explained
Reports vs Dashboards
Email subscriptions, comments and other compelling features
Q+A feature in-depth
Admin settings within the online service
Tips For Using Power BI Within An Organisation
Enterprise architecture recommendations for Power BI
Develop Power BI desktop templates to scale reporting requirements
Row level security
The Microsoft Power Platform
Why Power BI is going to be huge!
Review Questions