Training on Analyzing and Visualizing Data using Microsoft Power BI




8th to 19th Jan 2024


5th to 16th Feb 2024


4th to 15th March 2024


1st to 12th April 2024


6th to 17th May 2024


3rd to 14th June 2024


1st to 12th July 2024


5th to 16th Aug 2024


2nd to 13th Sept 2024


7th to 18th Oct' 2024


4th-15th Nov' 2024


2nd to 13th Dec 2024


Microsoft Power BI is a Microsoft business intelligence solution that collects and processes data, analyzes it, and gives data-driven insights to managers, business analysts, and key decision makers in real time. It enables users to ask questions and receive answers regarding their data. By interacting with the technology, Power BI users may generate interactive dashboards and insights.

Who Can Attend?

This course is aimed at professionals who need to analyze and visualize data utilizing Microsoft Power BI.

Training Objectives

  • Connect, import, shape, and transform data for business intelligence (BI)
  • Model data with Power BI desktop
  • Custom create data visualizations and style reports for lucid data representation
  • Visualize data, author reports, and schedule automated refresh of your reports
  • Create and share dashboards based on reports in Power BI desktop
  • Share and collaborate with data with Power BI
  • Understand Power BI Data Analysis Expression(DAX), and its functions

Course Outline

Introduction to Power BI

  • Components of Power BI
  • Features of Power BI
  • Power BI workflow
  • Self Service ETL (Extract Transform Load)
  • Setup and Configuration of Power BI

Connecting to Data Sources

  • Excel
  • Online sources
  • SQL

Data Transformation: Data Management and Data Cleaning in Power BI (Power Query)

  • Using first rows as headers
  • Rename fields & replacing data values in cells, rows
  • Changing data types & change order of columns
  • Un-pivoting columns
  • Grouping and splitting column into multiple
  • extract feature (before /after delimiter)
  • Adding new columns
  • Filters and parameters
  • View native queries vs unfold queries


  • Table relationship (one to one, one to many, many to many)
  • Data Analysis Expression (DAX)
  • Measures and calculated Columns
  • Mastering DAX using quick measures

Visualization and Charts (Power View)

  • Stacked bar chart and stacked column chart
  • Clustered bar chart and clustered column chart
  • Line chart & area chart
  • Line and clustered column chart
  • Line and stacked column chart
  • Ribbon & waterfall chart
  • Funnel & tree map visuals
  • Pie-chart and doughnut chart
  • Table chart and matrix chart
  • Slicer, gauge, card visuals
  • Map and filled map
  • ArcGIS maps for Power BI
  • KPI
  • Q & A visual
  • Fine tune your visualization using parameters and slicers
  • Deciding on when to use a particular visual

Building and Sharing a Dashboard

  • Workspace
  • Datasets
  • Reports
  • Create Dashboard
  • Modify and update Dashboard
  • Share your Dashboard
  • Power Q&A and Insights

Data Security in Power BI

  • Configuring row level security
  • Setting up user roles

Configuring Data Refresh

  • Types of data refresh (Package Refresh, Model/Data refresh, Tile Refresh, Visual/Container Refresh)
  • Understand & configure data management gateways
  • Configuring & scheduling data refresh

Power BI for Mobile

  • Configuring Power BI for Mobile
  • Visualize dashboards and report on Power BI Mobile
  • Commenting on eports and dashboards in Power BI Mobile

Excel Power BI

  • Power Query and Power Pivot on Excel
  • Visualize and Edit Power BI reports using excel analyzer
  • Building reports on Excel and Publishing to Power BI service
error: !!
Scroll to Top
Open chat
Can we help you?