Power BI for Data Analysis

From data to beautiful insights

I have created this course with a very simplified approach and many students who have taken this course have found it clear and easy to understand. The Power BI course is designed to give the participants with knowledge on using the most highly rated Data Analytics and Business Intelligence Tool, Power BI to extract from their data to gain great insights.​

What you’ll learn

  • Able to analyze data with Power BI and gain insight.
  • Able to connect and extract data from the web, excel etc..
  • Able to design interactive reports and dashboards.
  • Able to understand the logical steps in data models.
  • Able to write DAX expressions.
  • Data mash ups using the Power query editor.
  • Able to write your own DAX measures.
  • Able to design and interactive reports and dashboards.
  • Able to understand the concepts of facts and dimension table.
  • Able to create a Power BI mobile dashboard.

Course Content

  • Introduction & General Overview –> 8 lectures • 23min.
  • Data Visualization Reports using Power BI –> 11 lectures • 1hr 4min.
  • Data Modelling –> 9 lectures • 52min.
  • DAX Fundamentals –> 12 lectures • 48min.
  • Forecasting –> 1 lecture • 6min.

Power BI for Data Analysis

Requirements

I have created this course with a very simplified approach and many students who have taken this course have found it clear and easy to understand. The Power BI course is designed to give the participants with knowledge on using the most highly rated Data Analytics and Business Intelligence Tool, Power BI to extract from their data to gain great insights.​

At the end of the course, you would have progressed from a zero level to an intermediate level at a very tailored pace.

This course covers the essentials of Power BI Desktop including:

1. Data Preparation

2. Data Modeling

3. Data Visualization

4. DAX

In the Data Preparation section, I explained the rules for clean data structure. I also show how to connect Power BI to a system Folder and the minimum transformation that you can do for data clean up.

In the Data Visualization section, I have explained thoroughly and included a guide you that will hep you in selecting the right kind of charts for your reporting.

The Data Modeling section, I have shown how to methodologically create a data model and how you can eliminate redundant data by separating a large data set by separating the tables into Fact and Dimension Tables. You will see how to do this from scratch using a methodical approach on excel, before transferring to using the power query editor

Although, I have not gone very deep on DAX, the DAX content here is excellent, and it is a super place to start.

I hope you enjoy the course!

Get Tutorial