Complete a Data Visualization Project under 1 hour
0.0 (0 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.
0 students enrolled

Complete a Data Visualization Project under 1 hour

using Power Bi with COVID-19 data
0.0 (0 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.
0 students enrolled
Created by Jason Khoo
Last updated 4/2020
English
English [Auto]
Price: $39.99
30-Day Money-Back Guarantee
This course includes
  • 1 hour on-demand video
  • 1 downloadable resource
  • 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
  • Learn 7 common views of data visualization to create a complete project using COVID-19 data
Requirements
  • Know how to use excel to store data
Description

This course allows you to create a 7 views data report on COVID-19 data. The data is used so that you do not have to make extra effort to understand the numbers. This means that you can focus on understanding how to create the views as a layman. No coding is required to develop this data visualization project.

Who this course is for:
  • For managers who wish to learn how to create a data visualization project from scratch
Course content
Expand 12 lectures 01:09:29
+ Main Content
12 lectures 01:09:29

This is a must read so that you can understand how the course is designed and maximize the benefits from this course.

Preview 01:58

The layout for the data is critical to the use of any Data Visualization tools, including Power BI. In this section, I will explain how the data is arranged to prepare you on the use of the fields and the DAX formulas.

Preview 05:19

In this section, you will learn how to launch Power BI and get the data into the App for data visualization. The source file we are going to use is in CSV format. CSV is a text file, not an Excel file. It is commonly mistaken to be an Excel file because it opens up in Excel when you double click on it. You can also open a CSV file using Notepad.

The data file for the training could be downloaded below.

Preview 06:50

Contrary to common perception, the MAP chart is the easiest to create as compared to other views. In this section, I will show you how to create a MAP view with just a few clicks.

Creating the Map View
09:50

Column chart is a common view which allows you to look at the increase over previous days or periods. In this section, I will show you how to create a column chart and learn how to use the drill down functions, both through instant click and the other through permanent setting.

Create Column Chart view
12:00

Presenting an overall number provide a good overview of your data story telling. Creating this view requires you to understand how your data is organized. In this section, I will also touch on formatting the views we have just created.

Create a Card view
02:43

This is the first DAX formula you will learn for Power BI. I believe the formula is universal across any data visualization tool. Even though it seems unnecessary here, it is a good start to learn about DAX.

Use of Measure - SUM
02:50

The last date is an important DAX formula to pick up as it allows you to know how old your data is. You will learn how to set it up in this video.

Finding the last date of the data
03:44

Now that you have learnt about last date in the previous section, it is time to learn one of the most important formula in Power BI, called CALCULATE. This video shows you a simple setup to get you started on using CALCULATE.

DAX - Caculate and Last Date
03:46

Pie chart is common in Excel and any other charting software. I am sure you know how to create it. The question is how do you create one using the data we have without having to prepare a separate set of source data for it.

Creating a Pie Chart
03:56

Creating a bar chart is a piece of cake. But what most people did not know how to do in Pivot Table and Power BI is presenting the TOP 5 or 10 categories in the data. This section will show you how to do it easily and also the reason why you should do it.

Create Top5 Bar Chart
11:19

This training is incomplete if you can create all the views and not able to share it with your boss and colleagues. In this video, you will learn how to publish your data report to show off your skills as a data visualizer/ story teller.

Publish the Visuals to the browser
05:14