Original subtitles

Welcome to this course.

I'm really looking forward to taking you through this course on Power BI.

You're going to find with that that it's one of the most powerful and easiest business intelligence

tools to use.

You're going to find that a fundamentally changes the way that you do your data analysis.

Quick introduction before we get going.

My name is Ian Littlejohn and I'm going to be your instructor for the course.

My background is, is that I'm a Udemy partner instructor.

I'm also a data analyst and a consultant.

But let's have a look at a little bit more detail as to what we're going to cover in this course.

So in this course, we've got a lot to cover.

I'm going to start off by looking at our different Power BI products.

We're going to get an understanding and an overview of them.

I'm going to look at how we sign up for them, how we also load data into them and get a little bit

of an understanding.

I know we're going to be looking at how do we create some simple reports.

We're going to be looking at some tables, some matrices, some cards and putting that together.

The next step is we're going to be looking at publishing into the Power BI service.

So we're going to see how we can publish up from your desktop and how we get that information available

within the power of your service.

From there, the next step is we're going to be looking within the Power BI our service.

How do we create dashboards, how do we look at things like Q&A and some other things that we can do,

like for example, looking at mobile reports.

Once we completed those steps, we're going to be moving backwards.

So we're going to be looking back at our data model.

So we're going to come back into our Power BI desktop.

We're going to look at how we create some formulas, how we create, look at different functions, how

we use our Dak's functions.

So we'll be looking at how we build up our data model.

We're going to be then going on from there, looking at our relationships.

We're going to be seeing how we can create relationships within the Power BI data model.

We're then going to look at our query editor.

You're going to find that the query editor is an incredibly powerful product.

It's going to allow us to be able to transform and to clean up our data before we actually bring it

into our power.

BI So we're I have a look at that.

We're going to see some certain transformations we can do and get an understanding of it.

We're also going to be looking at how Power BI and Excel works together, so we're going to be seeing

that we can use Excel to actually analyze and understand our Power BI data.

Then we're going to be looking at a case study.

It's just in data that I've worked with over the years from the coronavirus, So we get the data from

the World Health Organization.

So I'm just going to run you through a report that I've created and also how we embed it.

And we hosted up on a website.

So as you can see, we've got a lot to cover in the course.

Can't wait to get going.

Let's jump into the lessons.

I will see you there.