Power Bi Beginner To Intermediate

Master the Basics & Build Confidence with Practical Projects, A Complete Guide for Beginners and Up-and-Coming Analysts

What you'll learn

Master Power BI Fundamentals – Learn how to install Power BI, connect to various data sources (Excel, CSV, SharePoint), and efficiently import data for analysis

Transform and Clean Data – Understand data types, column quality, and best practices for data cleaning. Create custom and conditional columns to prepare data fo

Build Data Models and Use DAX – Develop a solid understanding of data modeling, relationships, and DAX formulas for calculations, including SUM, IF, CALCULATE,

Create Interactive Visualizations – Design professional reports using visual elements like cards, bar charts, line charts, pie charts, slicers, and matrix forma

Publish and Share Reports – Learn how to publish reports on the Power BI Service, create workspaces, add members, and explore different sharing options.

Bonus Reports: End-to-End Creation - Finance Dashboard & Sales Report

Data Collection & Preparation: Get hands-on with financial datasets and learn how to prepare them for analysis.

Data Modeling: Build the underlying data model, integrating multiple tables and calculating key financial metrics like profit margins and revenue growth.

Creating the Dashboard: Learn to design a dynamic dashboard with charts, tables, and KPIs that tell a compelling financial story.

Real-World Reporting: Build and format a polished report ready for stakeholders, showcasing key financial insights.

Building KPIs and Metrics: Use DAX to create powerful KPIs that track performance, like sales growth, top-performing products, and regional sales comparisons.

Interactive Sales Dashboards: Build a sales report with filters, slicers, and interactive visuals to provide detailed insights.

Requirements

No prior experience in Power BI or data analytics is required.

Basic knowledge of Excel can be helpful but is not mandatory.

A computer with Windows OS (Power BI Desktop is not available on Mac).

Internet connection to download and install Power BI and access Power BI Service.

Description

Power BI is one of the most powerful tools for data analysis and visualization. This course is designed for complete beginners who want to learn Power BI from scratch. You don’t need any coding or technical background—just a basic understanding of data.In this course, you will learn how to connect to different data sources like Excel, CSV, and SharePoint. You will clean and transform raw data to make it ready for analysis. Then, you’ll build relationships between tables and use DAX formulas to perform calculations like SUM, IF, and CALCULATE.Next, you’ll create interactive dashboards with charts, slicers, and tables to present insights effectively. You’ll also learn how to format reports and make them look professional.Finally, you’ll publish your reports using Power BI Service, create workspaces, and explore different ways to share your reports with others.By the end of this course, you’ll be able to turn raw data into meaningful insights and create stunning reports—all without writing a single line of code! Whether you’re a student, business professional, or aspiring data analyst, this course will help you get started with Power BI.More Learning: Financial Report Project & Sales Report  ( End to End creation)At the end of the course, you’ll work on a real-world financial report project & Sales Report. This will introduce some advanced features of Power BI, helping you apply what you've learned in a practical way.Master Power BI and boost your data analytics career with confidence and real-world skills! Best of Luck

Overview

Section 1: Kickstart - Getting the Most Out of Your Learning Journey

Lecture 1 Welcome to the course

Lecture 2 Installation

Lecture 3 Microsoft Power BI Desktop Introduction

Lecture 4 Data set and Solved files

Section 2: Getting Started with Power BI Desktop

Lecture 5 Get Data From Excel

Lecture 6 Get Data From CSV

Lecture 7 Get Data From Folder

Lecture 8 Get Data from Sharepoint Excel

Lecture 9 Get Data From Sharepoint folder

Section 3: Data Transformation with Power Query

Lecture 10 Data Type and Column Quality

Lecture 11 Data Cleaning

Lecture 12 Add Custom & Conditional column in Power query

Section 4: Data Modeling & DAX

Lecture 13 Understand Data Modelling

Lecture 14 Build Relationship _Data Modelling

Lecture 15 DAX_Add New Column Simple Calculation

Lecture 16 DAX New Column IF _Switch

Lecture 17 DAX New Column_ IF RELATED

Lecture 18 DAX Implicit Measure SUM, COUNT, DISTINCTCOUNT

Lecture 19 DAX Explicit Measure SUM SUBSTRACTION

Lecture 20 DAX Explicit DIVIDE

Lecture 21 Page Formatting

Lecture 22 DAX_CALCULATE_ALL

Lecture 23 DAX_CALENDARAUTO

Section 5: Data Visualization

Lecture 24 DV_Single Value Card

Lecture 25 DV_Clustered Column Chart

Lecture 26 DV_Line Chart

Lecture 27 DV_Matrix Conditional Formatting

Lecture 28 DV_PIE Chart

Lecture 29 DV_Combo Chart Line Column

Lecture 30 DV_Slicer

Lecture 31 DV_Report Formatting

Section 6: Sharing and Collaboration

Lecture 32 Power BI Service , Create Workspace , Add Member, Publish report

Lecture 33 Other Sharing Option

Lecture 34 End of Part 1

Section 7: More Learning: Financial Report Project

Lecture 35 Part 2 - Introduction

Lecture 36 Understand Data and Problem statement

Lecture 37 Get Data into Power BI from folder

Lecture 38 Data Transformation Add Custom Column and Append Table

Lecture 39 Create Calendar Table & Build Relationship

Lecture 40 Create Blank Table to store DAX Measure

Lecture 41 Create DAX, Revenue Expense using CALCULATE

Lecture 42 Report Layout Design

Lecture 43 Show DAX in New Card Visual & Formatting

Lecture 44 Add Line Chart as Sparkline and Group with Card

Lecture 45 Add Slicer Drop down and Button, formatting and Edit Interaction

Lecture 46 Column Chart & Slicer setting

Lecture 47 Line Chart, Trend Forecasting

Lecture 48 Bar Chart, fix Negative axis and Formatting

Lecture 49 Create Matrix & formatting

Lecture 50 Conditional Formatting

Lecture 51 Add Reference Label and Symbol in Card

Lecture 52 Add Title and clear filter Bookmark

Lecture 53 Part 2 _Finance Report Closing

Section 8: MoreLearning: Sales Report Project

Lecture 54 Part 2 Sales report

Lecture 55 Understand & Get Data in Power BI

Lecture 56 Create Blank and Calendar Table

Lecture 57 Report Layout using Power Point

Lecture 58 Import Background Image

Lecture 59 Create KPI Measure

Lecture 60 Add Measure to Card & do Card Formatting

Lecture 61 Customize Current Theme

Lecture 62 Add more KPI Card

Lecture 63 Create Cluster Column Chart & Advance Formatting

Lecture 64 Add year Slicer & Formatting

Lecture 65 Create Min Max Sales Dax by Month

Lecture 66 Highlght Column Chart Color using DAX

Lecture 67 Organize Dax by Creating Folder

Lecture 68 Create Donut Chart

Lecture 69 Create Bar Chart & Basic Formatting

Lecture 70 Create Dummy Measure to create new series and Format

Lecture 71 Create ALL DAX and Combine Label & Variable DAX

Lecture 72 Create bar Chart

Lecture 73 Create Table & Add Conditional Formatting

Lecture 74 Create Summary page, Add Buttons and Test Hyperlink

Section 9: Congratulation

Lecture 75 Congratulation on Completing the entire course

Beginners who want to start their journey in Power BI and data analytics.,Excel users looking to enhance their data visualization and reporting skills.,Business professionals and analysts who need to create interactive dashboards.,Students and job seekers aiming for roles in data analysis and business intelligence.