
This video will show you the Power BI report you will be creating. It gives an overview of what Power BI skills you will be learning during this course. What this video doesn't show is the DAX formulas we will be getting into later in the course.
This video will guide you though the Power BI installation process.
This video will show you how to obtain the COVID-19 dataset we will be using for this class.
This video will show you how to import the dataset you downloaded from the previous lecture into Power BI.
We will cover how to group fields in Power BI to make them easier to work with.
We will cover how to format fields in Power BI to make them display nicer.
Our first step at creating the world map visual.
The first DAX measure we will be using.
We use our Total Cases measure formula as a basis for creating a New Cases measure.
Showing you how to correcting some common map issues.
We being creating our multi-row card.
A demonstration of how a 7 day average works in a spreadsheet.
We create a Power BI Calendar table and set up a relationship to our main table with it.
We fix a common problem of "future dates" in our report.
We begin creating our initial charts.
I explore the dataset to show why our Population measure is a little trickier than expected.
We create a robust Population measure that can be used anywhere.
We create the first of our "per million" measures.
We add in some new charts using the new measures we have created previously.
We combine multiple measures to create a new one.
We move away from our World Map page temporarily to work on our Country Comparison page.
Additional work on our Country Comparison page.
We explore the basics of Bookmarks in Power BI.
We use a more advanced feature of Bookmarks.
We use a trick to make the page feel more interactive using Bookmarks.
We cleanup the World Map measures and combine measures to allow them to display more data in less space.
We apply our formatting to the World Map page to make it look nice.
We apply our formatting to the Country Comparison page to make it look nice.
How to enable Trendlines on your charts.
An overview of how and why you should create a Glossary page on your reports.
An end to the class and some ideas for future projects for yourself.
Create your own interactive COVID-19 Dashboard in Power BI. 4+ hours of videos show you every step of the process. Follow along with a free dataset that shows COVID-19 Cases around the world. We start with the basics of Power BI and move on to using DAX formulas and other more advanced features. At the end of the class you will have a Power BI project that you can use.
Some of the topics included in this class:
Installing Power BI
Importing data into Power BI
Using a World Map visual
Charts and Trendlines
Displaying data on Cards
Creating robust DAX formulas
Create a Calendar table
Relationships between tables
Cosmetic formatting of visuals
You will learn how to use DAX measures to:
Get the most recent value from a dataset
Calculate values on a "per million" basis based on the country's population so countries of different population sizes can be compared
Create 7-day moving averages
And much more.
This class gives you all the tools and knowledge you need to have a strong foundation with Power BI. No prior business intelligence experience required. Power BI Desktop is a free tool that can be downloaded from Microsoft (instructions in video) so no need to spend any additional money on software.
Power BI is becoming more important as a Business Intelligence tool every day. Learn it now with this engaging course!