Power BI Quick Start - Create a PBI Dashboard in 90 Minutes

Beginners step-by-step guide to creating a Power BI dashboard. The 5 step process for building an effective dashboard.

4.35 (509 reviews)
Udemy
platform
English
language
Other
category
instructor
11,340
students
1.5 hours
content
Apr 2020
last update
FREE
regular price

What you will learn

Learn my 5 step process to building an Effective Dashboard and why each step is vital.

How to create a new Power BI report and import data from Excel.

What calculated columns are and how to add them to your data model.

What a measure is and how to add it to your data model.

Create basic DAX expressions using IF(), SWITCH(), COUNTROWS() and SUMX()

Importing a theme to format fonts and colours in Power BI.

My recommended report setting. How best to configure the Power BI report options.

How to add and configure card visuals.

How to add and configure an on-screen filter (slicer) to your report.

Set-up a bar graph visual.

Set-up a calculated column that segments work orders into days old groupings.

Add and configure a matrix visualisation with column and row categories.

Add a drillthrough from the home page charts and matrix to a work order details screen. View the detailed transactions that are behind the numbers.

How to publish your dashboard to the Power BI Service. This is the starting point to sharing your dashboard with the world.

Description

Power BI is the fastest-growing data analytics tool on the market. Demand for skills in Power BI is rocketing. Most major organisations are now using it as part of their standard desktop toolkit.

This course is for you if you are pushed for time and want to quickly learn how to create a new dashboard and understand the key features and capability of Power BI.

The good news is that it's very easy to quickly learn how to start creating effective dashboards.

After completing this short, practical, hands-on course you'll have the knowledge you need to take advantage of Power BI's capability to create your first dashboard in your organisation or role.

----------------------------------------

Project Scenario Overview:

----------------------------------------

For this course, you will play the role of a business analyst who has been tasked with creating a report to analyse the overdue maintenance activities at an oil production facility.

The course takes you step-by-step through the end-to-end process of defining, building and deploying a professional and effective dashboard. The dashboard will allow managers to analyse the company's overdue maintenance activities and drill into the detailed transactions that make up the overdue work.

I'll provide you with everything you need to guide you through the process of building the solution and configuring the dashboard, including my key hints and tips for success and how to make the dashboard user-friendly and easy to read (you can learn from my mistakes!).

--------------------------

Course Overview:

--------------------------

The course has 4 key learning objectives:

Objective #1: Learn the 5 Step Process for Building an Effective Dashboard

  • My 5 step process provides you with a clear structure to follow when creating a new dashboard. (Note: It's not just about Power BI)

--------------------------

Objective #2: Import Data using Power Query

  • Understand how to load data into your Power BI data model.

--------------------------

Objective #3: Building a Data Analysis Dashboard in Power BI

  • Learn the difference between a calculated column and a measure.

  • Add a new column to your data model based on the IF() function.

  • Create some basic measures using the SUMX() and COUNTROWS() DAX functions.

  • Import a theme to your dashboard - including my best practice recommendation for selecting a colour scheme.

  • Add and configure Card, Bar Chart, Matrix and Table visuals.

  • Create an on-screen filter using the Slicer visualisation.

--------------------------

Objective #4: Publishing the Dashboard to the Power BI Service

  • Share your dashboard through the Web with the Power BI Service.

--------------------------

By the end of this short project, you'll understand how to get started with Power BI and will have the skills and knowledge to build your own basic dashboards with confidence.

Note this course is not designed to be a compreshensive Power BI course. It's a quick start course built to provide you with a solid foundation in key features of Power BI. From here you'll be in a great position to accelerate your Power BI skills development.

Power BI is currently a highly desirable skill set. It allows you to easily create beautiful dashboards, track KPIs and gain insights into your data, then share these with the world!

Remember, this quick start course is for anyone looking to get started with Power BI. If you are a budding data analyst, an IT professional, a department manager or just someone who wants to add to Power BI to their skillset and CV, this course is for you.

--------------------------

Sign up today and in under 90 minutes, you'll be up and running with Power BI.

Included in the course package you'll get:

  • Downloadable presentation of my 5 Step Process to Building an Effective Dashboard.

  • All the files and resources you need to complete your first dashboard project.

  • Q&A Forum.

  • Final Power BI project file.

Talk to you in the course! - Jason (Founder of Effective Dashboards)

Content

The 5 Step Effective Dashboard Building Process

Introduction
The 5 Step Effective Dashboard Building Process

Section 2 - Importing Data

Importing Data and Carrying out Basic Transformations

Section 3

Adding Calculated Columns containing DAX IF() and SWITCH() statements
Adding Measures containing DAX SUM(), COUNTROWS(), SUMX() Functions
Best Practice Page Layout, Adding and Customising Cards and Importing a Theme
Adding Cards and Applying Visual Level Filters
Adding a Slicer, Sorting One Field By Another and Dealing with (Blank) Values
Add and Format Column Chart Visuals
Add Matrix Visual and Heat Map Conditional Formatting

Section 4 - Adding Interaction To Your Dashboard

How to Control Cross Filtering of Visuals Using Edit Interactions
Creating and Configuring a Drillthrough Report
Adding Colour Conditional Formatting Using a DAX Measure
Adding a Help Popup Tooltip to a Visualisation
Creating a Bookmark for Drilling Through to Total Backlog
Adding a Pop-up Tooltip with Additional Information

Section 5 - Publishing the Dashboard to the Power BI Service

Publishing Your Dashboard to the Power BI Service
Final Overview of Dashboard Functionality
Copy of Final Power BI Dashboard File

Screenshots

Power BI Quick Start - Create a PBI Dashboard in 90 Minutes - Screenshot_01Power BI Quick Start - Create a PBI Dashboard in 90 Minutes - Screenshot_02Power BI Quick Start - Create a PBI Dashboard in 90 Minutes - Screenshot_03Power BI Quick Start - Create a PBI Dashboard in 90 Minutes - Screenshot_04

Reviews

Paula
October 31, 2023
This course was very informative for a beginner, the only issue I had was the Layout in Power BI desktop has changed, so it was a struggle to find some of the settings. (Totally on Microsoft, not the instructor.) I learned a lot.
Clare
September 19, 2023
Played it on super high speed, but still got some very good information and understanding of how PowerBI works (I do have a strong background in Excel also).
Paul
June 21, 2023
Video fonts are way too small. It is not clear what keyboard keys need to be pressed to invoke options.
Tiffany
April 5, 2023
learnt a lot of new things, would of like more detailed information behind some of the tools but was a good start
Mohamed
December 26, 2022
Thanks for providing this useful content for free of cost.Looking forward for few more of your videos. Also suggest any new learners on which order they need to go through the videos and topics.
Michael
October 12, 2022
I have been working in Data Analystics for some time, so for someone like me this course is perfectly fine, but this is no beginner's course, nor is it a quick start. If you have never worked in Power BI or have never done any type of data development. You will be lost. Anyone could learn anything at any pace, but he goes straight into DAX Dev and IF Statements by lesson 4 and there is no explanation of why or where he's going. I would recommend going over the basics with the already existing data from Excel before creating custom columns with DAX and Programming
Mohammed
September 10, 2022
The content was up to the point its simple enough for a beginner to understand and manage to get the fruitful information. Thanks for the free course as it helps enough to have basic understanding of "POWER BI" application.
Leah
August 19, 2022
Simple enough for quick comprehension, but substantial enough for deeper learning- excellent balance!
Dionisio
July 14, 2022
Gostei muito do curso. Tenho visto aulas elaboradas por si. Essas aulas ajudaram-me muito no meu trabalho do dia a dia. Muito obrigado Jason e força aí.
Aadesh
April 30, 2022
Bro atleast give explaination what kind of data it is disappointed because cant understand data why we are creating columns why there is a need to do certain things the instructor is running over things worst not recommended for beginner.
Brandi
March 16, 2022
The videos are simple to follow and contain manageable amounts of information to digest as a beginner.
Anna
December 31, 2021
Short, but very good course - thank you, Jason!!! It's good for: - beginners who want to start their journey with PowerBI - anyone who has some background in creating dashboards and visualisations and wants to brush up/refresh what they know. Lots of interesting examples, the course content is very well organised and the way the author explains it - very clear and easy to follow. Fully recommend! 90 mins is not a long time but it can make a big difference if you watch this course and apply the knowledge in your own work!!!
Dave
November 10, 2021
Although I'm a little familiar already with Power BI, and can reason out some things from having used reporting tools in the past, I still found a lot of useful information in this course
Kevin
October 13, 2021
Good course - what is says on the tin with respect to fitting everything in, in 90 mins but pace was a little fast particularly around explanations of formulae
Mahmud
July 11, 2021
Truly awesome course. I need to watch again a number of times as there is so much information here. Thank you.

Charts

Price

Power BI Quick Start - Create a PBI Dashboard in 90 Minutes - Price chart

Rating

Power BI Quick Start - Create a PBI Dashboard in 90 Minutes - Ratings chart

Enrollment distribution

Power BI Quick Start - Create a PBI Dashboard in 90 Minutes - Distribution chart

Related Topics

2861974
udemy ID
3/10/2020
course created date
4/18/2020
course indexed date
Angelcrc Seven
course submited by