• Duration

    3.5 Hours

  • Level

    Beginner

  • Course Type

    Short Course

Key Takeways

  • Master Business Intelligence and Power BI Fundamentals: Understand core BI concepts, the role of data visualization, and how Power BI helps turn raw data into actionable insights.

  • Clean, Transform, and Prepare Data Using Power Query: Learn to connect to data sources, clean datasets, handle missing values, and perform advanced transformations for analysis-ready data.

  • Build Interactive Dashboards and End-to-End Reports: Create multi-page Power BI reports including sales overviews, profit analysis, time-series trends, customer insights, and region-wise breakdowns using charts and filters.

Who should enroll?

  • Aspiring Students: Students aiming to build a career in data analytics or business intelligence and want hands-on skills in Power BI for creating impactful dashboards.

  • Professionals: Analysts, managers, or business professionals looking to upskill in data visualization to make data-driven decisions and present insights effectively using Power BI.

Course curriculum

  • 1
    Introduction to Power BI
    • Intro to data viz
    • What is Business Intelligence-
    • Overview of Data Analysis
    • What is Power BI
    • Power Bi Intro Part -2
    • Power BI Installation Guide - Key Features
  • 2
    Basic Data Visualization in Power BI
    • Understanding Bar charts - Part 1
    • Understanding Barcharts - Part 2
    • Creating a Report with Multiple Bar Charts
    • Clustered Barcharts
    • 100_ Clustered Barcharts
    • Understanding Line Charts
    • Creating a Report with Multiple Line Charts
    • Functionalities using Line Charts
    • Area Charts
    • Ribbon chart
    • Waterfall Chart
    • Funnel Chart
    • Scatter Charts
    • Donut - Pie chart
    • Creating Hierarchy Visuals
    • Types of Maps in Power BI
    • Gauge - Card Visuals
    • Creating a Page Layout
    • Iterations in Card Visuals
    • Slicers and Table Metrics
  • 3
    Advanced Visualizations in Power BI
    • Understanding Conditional Formatting
    • Conditional Formatting in Table Visuals
    • Creating Animations in Power BI
    • Designing Custom Tool Tips for Clients
  • 4
    Data Modeling and Cardinality in Power BI
    • The Importance to Data Warehousing
    • The Working of a POS Machine
    • Understanding Facts _ Dimensions
    • Understanding Normalization _ De-normalization
    • Converting a Flat File to a Data Model Scenario
    • Creating Relationships Between Tables
    • Cardinality in Power BI
    • The Need of Date Tables in Power BI
    • Creating Date Tables using DAX - Part 1
    • Creating Date Tables using DAX - Part 2
    • Creating Date Tables using Power Query
    • Resolving the Many-to-many Cardinality Problem
  • 5
    Advanced Data Modeling and Calculation Techniques in Power BI
    • Difference Between Calculated Column and Measure
    • Creating Various Measures in Power BI
    • Underatanding X Functions in Power BI
    • Calculating Categorical Functions from Tables
    • The Application of ALL in Measures
    • Dynamic and Static Ranking in Power BI
    • Understanding Selectedvalue in Power BI
    • Time-Intelligence Function in DAX
    • Cummulative Totals in Power BI
    • What-if Paramenters
  • 6
    Security, Service Accounts, and Reporting Insights
    • Static Row Level Security
    • Dynamic Row Level Security
    • The Power BI Services Account - A Walkthrough
    • The Advantages of a Services Account
    • Difference Between a Reports and Dashboards
  • 7
    Building An End-to-end Sales Analysis Report in Power BI
    • Data Cleaning
    • Data Study
    • Power query Data Transformation
    • Welcome Page
    • Sales Overview Page- Important Metrices and Filters
    • Sales Overview Page with Charts
    • Profit Analysis
    • Time Series Analysis
    • Region wise Analysismp4
    • Customer Analysis