Microsoft Power BI Course: Master DAX and Dashboard Creation

Welcome to the Power BI Desktop course. This is completely built with lots of Practicals that will make you work with any real-life datasets

Are you a data professional or aspiring analyst looking to learn the top business intelligence platform on the market, taking this course will build your confidence in data and analytics in general.

Throughout the course, we will guide you through how to approach real-life projects.

This is the scenario:

You just got hired as a DATA analyst in a sales and distribution company. Your first task is to use POWER BI to get insight from the company’s historical data.

Request from your Employer:

Your employer needs you to help them TRACK KPIs like Revenue, Returns, Refunds & Profit etc. Create a dashboard that helps them find trends and other useful insights. They want to identify highly profitable Products, Customers, Locations etc.

You don't need to worry about how to go through this project, we'll be here to walk you through every single step with intuitive, crystal-clear explanations and helpful resources you need to get better.

Step 1: Connecting to data and transformation

In this first stage we are going to look at how to get data, get it clean and transformed and load it into a PowerBI desktop.

We will explore how to append data from CSV and further use the advanced way to combine data from CSV which is using the folder option to consolidate your yearly, weekly, quarterly or monthly data for easy updates.

Step 2: Data modelling or Creating a Relationship

In this stage, we will look at how to best connect your data table and the lookup tables together.

Step 3: Adding Calculated Fields with DAX

In this stage, things will start to get more interesting. This is the stage where you are going to be introduced to Data Analysis. Expressions (DAX) At this stage we will learn how to create calculated columns and measures, explore when to use calculated columns and when to avoid them.

Step 4: Visualization (Dashboard)

This final stage is where we bring our data to LIFE with a report and dashboard. We will learn the best way to create an outstanding dashboard, create custom tooltips, and explore bookmarks and Power BI What-If Parameters.

See you in the classroom!