Original subtitles

Welcome to this case study.

So when the coronavirus started to make an impact upon the world's population, I decided to get the

information from the World Health Organization, put together a report.

And basically, over the time since then, World Health Organization keeps producing a new file each

day.

So basically, I try every day.

Don't always get it right, but we try every day to download the file, refresh the actual files.

So obviously, this has been going on for quite a bit of time now since pandemic started.

So what I wanted to do, though, in this case study was just run you through quickly exactly what we

kind of doing and the report that we've produced and also how we make it available on the website.

So as I say, this is just a little bit of a case study just to take you through how we do this.

Now, please note over time, the way that the World Health Organization has produced its data and also

produce the results has changed as well.

So this has gone through a few evolutions in terms of the way that it works At the moment, it's actually

pretty easy.

Basically what I do is I go to the World Health Organization that can see on the screen at the moment

and they have an option called data.

Now, there is a link to this in the in the actual course notes.

So you can go straight to this.

And basically if you go down, you'll see an option called data download.

When I select this, I am actually using this file at the moment.

Delhi cases and deaths by data reported to the World Health Organization.

So this is the file that I'm using.

It's a CSV file.

I download this file and basically then take it into power by now.

In the next lesson, I'm going to show you the Power BI desktop report that I'm using and just show

you some of the ideas that I had when I was putting it together.

Just some of the thoughts that I was thinking at the time of putting it together.

Before we get there, though, just while you're on the screen, there's a couple of things that you

may want to actually just explore yourself.

What you will find is the World Health Organization have also done their own data analysis, and some

of it can be really interesting.

So worth looking at.

If you go to the beginning, you'll see that there is actually an overview and you can see that there

is a map around the world just giving you an understanding of the sort of number of cases.

The totals does give you the option to be able to change things.

So you can say look at the death side of things, vaccination side of things as well, and get an overview

of the world.

Quite a nice map that they've got here also.

Then they've got some key metrics, sort of trend graphs.

They're showing a key metric here and then a trend graph of how things are changing.

Also, the total numbers that are associated with it by the different regions.

As you can see, you can go through this quite a lot of data to be able to look at and then then go

to some key countries as well, just showing the totals that have been confirmed.

Also see that they've got a number of different measures.

So if you wanted to go in this, you can see some different information on that as well.

And also a table view as well that can have a look at.

So as I say, quite a bit of interesting information.

They do update this, they do change this, but well worth having a look at.

Okay.

We're going to conclude the lesson here.

We're going to move into the Power BI desktop and the next one, just to show you an example of a report

I put together, it was quite some time ago now, but I'll show you some of the thinking that I had

at the time of putting it together.