Master Microsoft Power BI in 21 Days

Welcome to the Power BI course, lets's try to understand what are the topics going to be covered in this video.

What is Power BI? what are key areas of Power BI?

Learn about how to install Power BI and do necessary Project setup to get started with power BI project creation

Learn how we can connect Power BI Desktop to Source files.

Query Editor is an important part of Power BI Desktop and is one thing that helps us to connect to the Database and then performs data transformation.

Learn what is Data model is and how we can create our first data model.

What we are going to see, lets try to see.

Let's try to understand how to use the project resources.

Before we progress into the course, we must understand the power BI Desktop workflow, various important concepts related to Power BI, and different terminology, understanding workflow will help you provide more clarity about different topics about Power BI and related content. We are going to cover the entire course with this Power BI Desktop workflow. This will make it easy to go through and learn the Power BI tool.

Let's understand the interface of the Data model in more detail and the various operations we can perform in the Data Model.

Let's understand the project File and recommended settings we need to do for our project.

There are attached files you can find as helpful resources and different stages of the course.

In case you’re stuck, please download a project close to the lecture you’re currently working on, unzip the .zip file and open the .pbix file.

For our project, now we will connect our CSV files to Power BI Desktop and then we will take these files data to next level. Power BI can connect to various sources, CSV is one of the data source it connects.

When we have data, there may be various operations we need to perform on Data, basically, we should be able to understand which data to keep and which does not, so Keeping and removing rows helps us in this.

Append Queries is a very powerful feature and is required at many times when we work on real time projects.

Formatting data is important and when it comes to handling errors, let's understand how we can fix the data formatting errors.

Understand how we can pivot and unpivot the data in Query editor.

There is always the possibility that we may need to split data and it can be possible that we need to split the columns, so to understand better, let's learn this from video.

organizing the project and creating groups, so that it will be helpful  to organize the project

Star schema is important to understand when we are implementing the data model. Let's try to understand what is Star Schema?

We need to use this star schema in our project, for this we need to understand how to use star schema in our project, what are the table we need to create and how to join them

understand detail about Query Duplicates and Query references.

Practical steps to create DIM table.

What is merging, lets's understand it.

how to perform merging, let's see how to implement it.

Let's understand different types of Jons in the Power BI Data Model.

Merging queries to finalize the DIM table.

Let's see how we can create another DIM  table.

Fact table is important for any data model, let's see how we can create it..

Let's see how we can improve queries performance

Module introdction

What is relationships?

Types of Cardinality and what is the use of Cardinality.

Cross Filter direction and active properties in Power BI.

Let's try to understand what is M Language and DAX.

Module introduction points to be covered in this module

Lets learn how to stay upto date with power BI.