(Create and Manage Interactive Dashboard with Excel BI)

By the end of this training, participants will be able to design, build, and manage interactive dashboards using Excel Business Intelligence (BI) tools. They will learn to transform raw data into meaningful insights through the use of Power Query, Power Pivot, and Power View, and to create dynamic visual reports that support data-driven decision-making and performance tracking.

  • Date

    10 to 14 November 2025

  • Duration

    15 Hours

  • Price

    Rs 20,000

Content
Module 1 : Introducing to Power BI
  • Introduction to Power BI
  • What is PowerPivot for Excel vs Power BI
  • Importing Your Excel Data
  • Creating a Data Model
  • Creating a PowerPivot Data Model
  • Creating PivotTables with PowerPivot
  • Creating a Date Table
  • Link data queries using PowerPivot
  • Creating Relationships to different datasets
  • Using Slicers to Filter Data
  • Connecting Slicers to more than one PivotTable
  • Using Charts and Slicers to create interactive Dashboards
  • Creating Calculated Columns
  • Creating Measures
  • Implicit and Explicit Calculated Fields
  • Using Count Rows and Distinct
  • Creating Key Performance Indicators
Module 2 : Power Query
  • Adding Data to Power Query from various data sources
  • Creating a Query, the Query Editor Window Load to Worksheet and Load to Data Model Remove duplicate Data in Columns Split and Merge Columns of Data
  • Group data to create summary
  • Queries
  • Working with Applied Steps
  • Importing Data from a Folder
  • Date Columns
  • Merge and Append Queries
  • Transpose Data to swap Rows and Columns Filling data down to populate missing values
  • Unpivot Columns: flatten a “cross tab” table Duplicate Columns
  • Creating Custom Columns and Additional
Module 3 : Create dashboard using Power BI Desktop
  • Launching Power BI Desktop
  • Connecting data from an Excel File
  • Connecting data from a CSV File
  • Quick overview on Measures and calculated columns
  • Quick overview on PowerQuery
  • Create Visualizations
  • Creating text visuals: Cards, table and Matrix
  • Formatting Chart Visuals
  • Using Slicer to filter Visuals
  • Creating a Map Visuals
Module 4 : Power Map
  • Create a Power Map and Plot Geographic Data
  • Creation Visualisation; Column, Bubble, Heatmap, Regions
  • Using the 3-D Environment
  • Using Charts with Power Maps
  • Working with Layers and adding Scenes
  • Adding Annotations Visualising Data over Time Playing the Tou
Register Here.
Fill in the fields and send your application!