Powerful Reports and Dashboards with Microsoft Power BI
4.4 (392 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,230 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Powerful Reports and Dashboards with Microsoft Power BI to your Wishlist.

Add to Wishlist

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.4 (392 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,230 students enrolled
Created by Ian Littlejohn
Last updated 6/2017
English
Current price: $10 Original price: $100 Discount: 90% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4.5 hours on-demand video
  • 20 Articles
  • 8 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Create powerful reports and dashboards with Microsoft PowerBI with ease
  • Publish reports and dashboards on the Internet and view using laptops, tablets or smartphones in minutes
  • Learn to use the free Microsoft PowerBI to easily ask questions of your data
  • Easily create a wide range of graphs and visualizations using drag and drop technologies
  • Gain valuable insight and intelligence from your business and marketing data in a fraction of the time of traditional spreadsheets
  • Create a powerful dashboard and Business Intelligence system for free
View Curriculum
Requirements
  • You will need to know how the basics of working with data in Excel
  • In the course you will need to sign up for the free Microsoft PowerBI service
Description

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 powerful drag and drop capabilities 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 PowerBI Desktop Designer.

The course covers 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
  • 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 is the target audience?
  • All Excel users who work with data, reports or dashboards
  • All existing Business Intelligence developers and users
  • This course is not for users who are not yet familiar with working with data in Excel
Students Who Viewed This Course Also Viewed
Curriculum For This Course
60 Lectures
04:27:25
+
Introduction
5 Lectures 09:16
Introduction Section
00:00

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 02:14

Download the Training Data Files and Learner Guide
00:04

Practical Activity
00:14

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 06:44
+
The Power BI Desktop Designer
2 Lectures 10:31
Intro to PowerBI Desktop Section
00:00

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.

Download the Power BI Desktop Designer
10:31
+
Creating Reports in Power BI Desktop
16 Lectures 01:08:54
Create Reports in Power BI Desktop Section
00:00

In this lesson we learn how to load data into the PowerBI Desktop. We review the different types of data that can be loaded and also the methods and processes for loading data.

Introduction to Reports in Power BI
10:29

Tables and Metrics Practical Activity
00:21

In this lesson you will learn to summarize your data using Cards and Gauges. These visualization options are powerful for displaying key metric data and key performance indicator calculations.

Answers to Tables and Metrics Practical Activity
04:40

In this lesson you will learn to analyze your data using Tables and Matrix visualizations. Tables and Matrixes make it easy to aggregate your data and provide quick summaries. Different methods of aggregation such as Sum, Average, Count, Distinct Count, MIn and Max are also shown.

Preview 05:58

In this lesson you will learn how to use Slicers to easily filter your data. Slicers are text or category items that can easily filter your data. For example you may have a list of different branches in your company and then want to filter your reports to display one branch at a time.

Changing the Method of Aggregation
07:28

Challenge 2
00:38

In this lesson you will learn to filter data in reports using page filters. Page allow conditions such as Start With, Contains, Is Greater Than and Before and After Dates.

Challenge 2 Completed
06:14

In this lesson we will review how to create tables, key metrics and filters in this practical activity

Tables and Cards
09:39

Challenge 3
00:29

The Quick Calc Option
03:39

Filtering Data - Using Slicers
07:40

Filtering Data - Visual Filters
08:15

Filtering Data - Page Filters
02:17

Challenge 4
00:33

Challenge 4 Completed
00:31
+
Graphs and Visualizations
9 Lectures 01:00:27
Intro to Visualization Section
00:00

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.

Column Graphs
11:36

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
08:34

Challenge 5
00:18

In this lesson you will learn the power of cross filtering between Column and Bar graphs.

Graph Options
06:20

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:48

In this lesson we will learn how to create Pie charts in PowerBI. Pie charts are useful for showing the percentage that item contributes to the whole or the 100%

Additional Graphs
13:56

In this lesson we will learn how to create area graphs. Area graphs are useful when you want to see how data changes over time and also see how the magnitude of the data changes over time.

Scatterplots
07:12

In this lesson you will learn how to create a Treemap visualizations. TreeMap is another method of visualizing your data to understand which items contribute the most or the least to the total.

Bubbleplots
04:43
+
Interactive Dashboards
6 Lectures 27:13
Creating Interactive Dashboards
00:00

Interactive Dashboard Section
12:02

Publishing Dashboards
01:55

Pinning and Q & A
05:56

Sharing Dashboards
02:40

Power BI on Mobile
04:40
+
DAX Formulas
5 Lectures 29:28
Relationships Section
00:00

In this lesson you will learn to create relationships between different tables of data. Relationships allow the creation of reports using fields from different tables such as lookup fields. For example you may have a Product ID in your main table, but want to know what the Product Name is. Relationships are used to join the two tables.

DAX Formulas
06:10

In this lesson you will learn how to analyze and create reports using relationships between more than one table of data.

Time Intelligence
10:35

Formatting Dates
05:00

Date Master Tables
07:43
+
DAX Measures
3 Lectures 19:18
DAX Measures Section
00:00

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
11:13

In this lesson you will learn how to create Sum, Count, Distinct Count, Average, Min and Max calculations in PowerBI.

The =Calculate Formula
08:05
+
Relationships
4 Lectures 10:11
Relationships Section
00:00

In this lesson you will learn how to create an interactive dashboard that can be uploaded to the PowerBI cloud.

Creating and Managing Relationships in Power BI
03:41

In this lesson you will learn how to load your dashboard into the cloud.

Using Custom Visualizations in Power BI
04:12

Using the Related Formula
02:18
+
Enhancing Power BI
3 Lectures 14:47
Enhancing Power BI Section
00:00

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

Transforming Data with Power BI
09:47

In this lesson you will learn how to transform and correct data errors in PowerBI

Aggregating Data
05:00
+
Analyze Data with Excel
4 Lectures 16:00
Setting up Power BI Data to work with Excel
00:00

Introduction to Analyze Power BI Data with Excel
04:21

Creating Measures for Excel Analysis
03:33

Additional Measures for Excel
08:06
1 More Section
About the Instructor
Ian Littlejohn
4.4 Average rating
1,502 Reviews
9,506 Students
11 Courses
Excel Power Tools, Power BI and Google Data Studio Trainer

Ian is a trainer that specializes in Microsoft Excel Business Intelligence tools and Google Data Studio.  Ian is an experienced trainer that teaches techniques and tools making it easy for learners to harness the power of Excel PivotTables, PowerPivot, Power Query,  Power BI and Google Data Studio.

Ian has been training learners on these powerful technologies for over 10 years making it easy for business users to easily create management reports, develop interactive dashboards and generate new insight and intelligence from business data.

Ian has over 10 years of Management Consulting experience and he brings this knowledge and skills to his training course showing Excel and Google Data Studio users how to easily create sophisticated management reports, perform data analysis and create amazing interactive dashboards without using any complex programming or specialized tools.

Ian has consulted and worked with major organizations in the Banking, Insurance, Manufacturing, Telecommunications and Logistics industries across a number of countries and continents.