Powerful Reports and Dashboards with Microsoft Power BI
4.5 (4,899 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
22,798 students enrolled

Powerful Reports and Dashboards with Microsoft Power BI

Learn to use the free Microsoft Power BI to create reports, analyze data and develop interactive dashboards in minutes
4.5 (4,932 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
22,815 students enrolled
Created by Ian Littlejohn
Last updated 5/2020
English
English [Auto-generated], Italian [Auto-generated]
Current price: $69.99 Original price: $99.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 6 hours on-demand video
  • 11 articles
  • 5 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Enjoy CLEAR and CONCISE step by step lessons from a best selling Udemy instructor
  • Learn to create POWERFUL reports and dashboards with Microsoft PowerBI with a few clicks of the mouse
  • Gain valuable INSIGHT and INTELLIGENCE from your business and marketing data in a FRACTION of the time of traditional spreadsheets
  • PUBLISH reports and dashboards on the Internet and view using laptops, tablets or smartphones in minutes
  • Learn to create Data Models and use the DAX Formula language to develop POWERFUL calculations
  • Easily create a wide range of GRAPHS and VISUALISATIONS using drag and drop technologies
  • Use the Power BI Q & A feature to easily ask QUESTIONS of your data and provide new insight
Requirements
  • You will need to know the basics of working with data in Excel
  • In the course you will need to sign up for the free Microsoft PowerBI service
  • Download the Power BI Desktop app which is available free from Microsoft
Description

Recent reviews:

"Great experience of learning and a bunch of thanks for those Challenges. It helped a lot and are very helpful while revising the sections rather than going through each lesson."

"Really good course, easy to follow and wonderful examples combined with useful insights."

"Clear and concise, the course provided all the information needed for using power BI, and did so while providing enough details and examples however without stretching too long"

**** Updated April 2020 - This best selling Udemy Power BI course has been updated to the new Power BI interface ****

In this course you will learn the BEST techniques and tools for turning data into MEANINGFUL analysis using Microsoft Power BI

This course is lead by Ian Littlejohn - an international trainer, consultant and data analyst with over 50 000 enrollments on Udemy and consistently high reviews.  Ian specialises in teaching data analysis techniques, Excel Pivot Tables, Power Pivot, Microsoft Power BI and Google Data Studio. 

**** Life time access to course materials and practice activities.  100% money back guarantee ****

In this course we are going to show you how to SUPERCHARGE your Power BI skills, and learn to create INTERACTIVE Dashboards and INCREDIBLE reports.  

In this course we are going to teach you the following:

  • Using the  Table and Matrix visualizations for cross filtering and drill downs

  • Creating Drill through between different sheets.  For example you could be reviewing a list of Products and want to select one Product to view a summary of this product

  • Themes - Learn how to add  Power BI Themes from the Community Theme Gallery

  • Changes in  Custom Visuals - We look at how to easily add Custom Visualizations from the new Microsoft Office Store

  • Creating Apps - Learn how to easily share your dashboards and reports using Power BI apps and App workspaces

  • Relative Date Filters - In this lesson we show how to easily create a dashboard displaying Microsoft stock data.  Easily filter your data to display the last 7 days, last 14 days, last month or previous 3 months using relative date filters

  • Drill Through - Create drill throughs between different pages in a report

  • Ribbon Chart - Learn to use the new Ribbon Chart to visualize the ranking of items across dates ranges or other categories.

Microsoft Power BI is the easiest to use reporting, data analysis and interactive dashboard tool available today!  Microsoft Power BI is available for free - all you need to do is sign up!

In this course I will teach you how to easily turn your data into powerful intelligence and insight to drive your business decisions.  Power BI uses simple drag and drop techniques that make it a breeze to create reports and dashboard.  I will also show you how easy it is to publish your dashboards and to access them through your smartphone, tablet or laptop.

This course is for anybody who works with data and wants to learn how to quickly and easily get to speed with the cloud version of Power BI or learn the more powerful Power BI Desktop Designer.   

The course has the following topics:

  • Introduction to Power BI and how to signup

  • How to create your first online report and dashboard

  • How to download the Power BI Desktop Designer

  • Loading, transforming and filtering data in Power BI

  • Creating tables and reports

  • Using filters and slicers

  • Learning how to use the wide range of graphs and visualizations

  • Creating relationships between tables of data

  • Creating powerful calculations, key metrics and key performance indicators

  • Creating interactive dashboards

  • Publishing dashboards to Power BI

In this course we use a step by step video based approach to show you how to create reports, analyze data and develop interactive dashboards.  The videos are extremely easy to follow and data is provided so you can follow the instructions at the same time.


Who this course is for:
  • All Excel users who work with data, reports or dashboards
  • All existing Business Intelligence developers and users
  • Business users who need to create reports using data
Course content
Expand all 78 lectures 06:17:35
+ Introduction
3 lectures 03:43

In this introduction we discuss the different topics and modules that we will be covering in the course. Different topics include Loading data, creating tables and reports, creating visualizations, developing dashboards and sharing data through the PowerBI cloud solution.

Preview 01:57
About the Course
01:42

Download the data files that will be used during the course

Download the Training Data Files
00:04
+ Sign Up for Power BI
4 lectures 13:32
Introduction to Signing Up for Power BI
01:24

In this lesson we will show how you will sign up for the PowerBI service. This will create a user login and password for the PowerBI service.

Preview 05:41

In this lesson we learn how to load data into the Power BI Service

Preview 06:16

Practical activity to sign up and start using Power BI

Practical Activity
00:11
+ The Power BI Desktop
2 lectures 09:12

Introduction to the Power BI Desktop section

Intro to PowerBI Desktop Section
00:40

In this lesson we will learn how to access and use the PowerBI interface. The PowerBI Interface consists of functions to upload or access data, create reports and create dashboards.

Preview 08:32
+ Creating Reports in Power BI Desktop
19 lectures 01:44:32
Create Reports in Power BI Desktop Section
00:54

In this lesson we learn how to create tables in Power BI

Creating Tables in Power BI
05:58

In this lesson you will learn to format and style your table

Preview 08:23
Matrix Visualization
06:11
Tables and Metrics Practical Activity
00:17

In this lesson we go through the answers to the practical

Answers to Tables and Metrics Practical Activity
05:12

In this lesson you will learn to change the method of aggregation from Sum to other options such as Average, Count, Max, Min and Distinct

Changing the Method of Aggregation
07:28
Methods of Aggregation Challenge
00:41

In this lesson we will go through the answers to the practical activity

Methods of Aggregation Challenge Completed
06:58

In this lesson we will review how to create cards and multi row cards in Power BI

Cards and Multi Row Cards
07:31
Cards, Matrix and Multi Row Card Challenge
00:31
Answers to Cards Challenge
09:18
Percentage Calculations
05:34
Filtering Data - Using Slicers
09:57
Filtering Data - Visual Filters
09:49
Filtering Data - Page Filters
03:20
Filtering Data - DrillThrough Filter
06:43
Practical Activity - Filters
00:34
Practical Activity Filters Completed
09:12
+ Graphs and Visualizations
12 lectures 01:00:04
Introduction to Visualization Section
01:40

In this lesson you will learn how to create clustered column and bar graphs. Clustered Column and Bar graphs are ideal for displaying data when you want to know which is the largest item or which is the smallest item or how much bigger one item is then another.

Clustered Column Graphs
08:56

In this lesson we will review the stacked bar and column graph. The stacked column and bar graph places each series on top of each other and displays the aggregated total.

Stacked and 100% Graphs
04:57
Column Graph Challenge
00:17
Column Graph Challenge Completed
03:00

In this lesson you will learn the different features that can activated with Power BI 

Graph Options
04:49

In this lesson you will learn how to create line charts to display trends. Displaying and analyzing how data changes over time is a powerful method of analysis that provides input into forecasting.

Trend Analysis Graphs
07:50

In this lesson you will learn how to use area graphs to chart and understand trends

Area Graphs
05:50

In this lesson you will learn how to create a Ribbon graph visualizations.  The ribbon graph dispalys the ranking of the items that are being displayed.  If for example you are displaying Sales by Product Category then  it will display the Product Category with the highest Sales at the top and then the second highest and so on

Ribbon Graphs
04:43

In this lesson we will learn how to different types of graphs in Power

Additional Graphs
06:52

In this lesson we will learn how to create scatterplot and bubbleplot graphs. 

Scatterplots and Bubbleplots
07:56
Decomposition Tree
03:14
+ Interactive Dashboards
11 lectures 57:14
Creating Interactive Dashboards
01:46
Challenge - Create an Interactive Report
00:13
Completed Challenge - How to Create an Interactive Report
07:51
Publishing Reports to the Power BI Service
08:08
Pinning Visualizations to Dashboards
06:30
Mobile Reports
03:35
Q and A
03:42
App Workspaces
07:19
Publishing an App
06:54
Using Themes in Power BI
05:04
Using Custom Visualizations
06:12
+ DAX Formulas
5 lectures 31:28
DAX Formulas Section
01:47

In this lesson you will learn to create calculated columns using DAX formulas.  DAX formulas are very similar to Excel 

DAX Formulas
08:11

In this lesson you will learn how to create new time intelligence fields such as Year, Month and Week 

Date Functions
07:27
Formatting Dates
04:58
Date Master Tables
09:05
+ DAX Measures
5 lectures 27:24
Introduction to Measures Section
02:05

In this lesson you will learn about the power of calculated measures to create powerful key metrics and key performance indicator calculations.

Introduction to DAX Measures
10:40
DAX Measures Practical Activity
00:05
DAX Measures Activity Completed
07:31

In this lesson you will learn how to use the = calculate function to filter 

The =Calculate Formula
07:03
+ Relationships
3 lectures 12:15
Relationships Section
01:45

In this lesson you will learn how to create relationships between  tables

Creating and Managing Relationships in Power BI
05:10
Relationship Calculations
05:20
+ Power BI Query Editor
4 lectures 24:49
Introduction to Power BI Query Editor
01:30

In this lesson you will learn the Edit Query interface and how to load data

Basic Transformations - Part 1
10:49
Basic Transformations - Part 2
07:41

In this lesson you will learn how to transform data into aggregations using the Query 

Aggregating Data
04:49