Become Power BI specialist by enabling yourself to make confident decisions using up-to-the- minute analytics. Get empowered to translate data into insights and insights into result-driven actions. Gain the knowledge and apply skills to import and merge large amounts of data, summarize and aggregate data, present strategic data and empower informed decision-making.

This training program also covers advanced tools and techniques which include Data Normalization, Data Modeling Analysis, Visualization, Python integration, and using Built-in Artificial Intelligence features in Power-BI.


    Integrate existing data with Power BI seamlessly with any source

    Apply Artificial Intelligence features in Power BI to automate the repetitive tasks in a workflow to boost efficiency

    Create advanced queries using query editor in Power BI

    Add user-controlled elements in dashboards

    Create interactive dashboards in Power BI to see whole company data in one snap-shot

    Create advanced visuals in Power BI that help in clear understanding of data in dynamic dashboards

    Integrate Python as a data source in Power BI

    Apply SQL in Power BI application to integrate the data


    1.1 Introduction to Pivot Table

    1.2 Create a Basic Pivot Table Report

    1.3 Rearranging a Pivot Table Report

    1.4 Customizing a Pivot Table

    1.5 Adding and Removing Subtotals

    1.6 Sorting in a Pivot Table

    1.7 Filtering in a Pivot Table

    1.8 Create Report Filter Pages

    1.9 Using Slicers in Pivot Table

    1.10 Working with Pivot Chart

    2.1 Introducing Busniess Intelligence for MS Excel

    2.2 Understanding BI Data

    2.3 Creating Data Models

    2.4 Defining a Report

    2.5 Understanding and Creating PowerPivot Data reports

    2.6 Creating DAX (Data Analysis Expressions) Functions

    2.7 Mining for information with date and time analysis

    2.8 Dates and Hierarchies and Shaping Reports

    2.9 Creating Calendar Table

    2.10 Working with multiple date columns

    2.11 Apply ETL (Extraction, Transformation & Loading) process using Power Query

    2.12 Query Editor Transformations

    3.1 Getting started with Power BI Desktop

    3.2 Data Sources in Power BI Desktop

    3.3 Connect to live Web Data and MS Access

    3.4 Import Excel Workbooks

    3.5 Analysis Services Tabular Data

    3.6 Shape and Combine Data

    3.7 Data Categorization

    3.8 Relationship View

    3.9 Create and manage relationships in Power BI Desktop

    3.10 Data Type in Power BI Desktop

    3.11 Measures in Power BI Desktop

    3.12 Calculated Columns and Tables

    3.13 DAX Basics

    3.14 Report View

    4.1 Tips and tricks for creating reports

    4.2 Import and display KPIs

    4.3 Creating Tables in Power BI

    4.4 Matrix Visualization

    4.5 Tables and Matrices

    4.6 Methods of Aggregation

    4.7 Cards and Multi Row Cards

    4.9 Percentage Calculations

    4.10 Filtering Data - Using Slicers, Visual Filters, Page Filters, Drill Through Filter

    4.11 Clustered Column Graphs

    4.12 Stacked and 100% Graphs

    4.13 Graph Options

    4.14 Trend Analysis Graphs

    4.15 Area Graphs

    4.16 Ribbon Graphs

    4.17 Scatterplots and Bubbleplots

    4.18 Using Smart Narrative feature in Power BI

    4.19 Creating Dashboard report using Q&A feature

    4.20 Publish from Power BI Desktop

    4.21 Share Dashboards through Power BI Desktop and Mobile Application

    5.1 M Language Basic Syntax

    5.2 Text Comparison Tools

    5.3 M Language Intellitext

    5.4 Learning New Functions

    5.5 Query Editor Concepts

    5.6 Query Order of Operations

    5.7 Query Parameters

    5.8 Introducing Functions

    5.9 Optional Parameters: Extending Functions

    5.10 Function Short-Hand

    5.11 Function in Function

    5.12 Records

    5.13 The Underscore Parameter

    5.14 Running Totals & Grouped Indexes

    5.15 Create a Grouped Index

    5.16 Create a Running Total

    5.17 Create a Running Total within a Grouped Index

    6.1 Chapter Introduction - Advanced Data Modeling & DAX

    6.2 DAX Functions for Advanced Data Modeling

    6.3 Build the Visual Dimension

    6.4 Create the Visual Measure with CROSSFILTER()

    6.5 Build a Multi-Relationship Visual Dimension

    6.6 Create the Visual Measure with USE RELATIONSHIP()

    6.7 Build Visuals with Other Dynamic Elements

    6.8 Create Dynamic Metric Selection

    6.9 Advanced Data Modeling & DAX Use Case

    6.10 Create the Filter Dimension in Power Query

    6.11 Relate the Filter Dimension in the Data Model

    7.1 Artificial Intelligence in Power BI

    7.2 Generate a Summary with a Smart Narrative

    7.3 Create a Q&A Visual

    7.4 Configure the Q&A Visual

    7.5 Analyze to Explain the Increase or Decrease

    7.6 Identify the Key Influencers

    7.7 Create a Decomposition Tree

    7.8 Detect Anomalies

    7.9 Forecast Future Values

    7.10 Generate Insights in Power BI Service

    8.1 Understanding SQL and its Role in Data Analysis

    8.2 Connecting Power BI to SQL Server

    8.3 Exploring Power BI Interface and Data Model

    8.4 Using SQL Queries in Power BI

    8.5 Basic SQL Querying in Power BI

    8.6 Advanced SQL Queries in Power B

    8.7 Using SQL Views and Stored Procedures

    8.8 Parameterized SQL Queries

    8.9 Optimizing Query Performance

    9.1 Introduction - Python Integration in Power BI

    9.2 Download & Connect Python to Power BI

    9.3 Create Data with a Python Script

    9.4 Import External Data with Python

    9.5 Run a Python Script in Power Query

    9.6 Machine Learning with Python in Power BI

    9.7 Load & Inspect the Dataset

    9.8 Build a Classification Model

    9.9 Update the Classification Model in Power Query

    9.10 Visualize Classification Model with a Decision Tree


Tahir Ali

Dashboard Reporting and Analysis with Power BI

Tahir Ali is a highly motivated corporate trainer with experience in training small and large groups across diverse industries. Proven success with over 16 years of professional experience of industry in leveraging educational theories and methodologies to design, develop, and deliver successful training programs and integrate instructional technology to provide onsite and virtual training.


  • Microsoft Certified Trainer
  • Microsoft Office Specialist Master – 2013 & 2016
  • Microsoft Excel Expert - 2013 & 2016
  • Microsoft Word Expert - 2016
  • Microsoft Office Specialist - 2013 & 2016

View More


36 hours


Intermediate level of MS Excel skills
Hands on knowledge of pivot tables


  • Experienced professional trainers with practical field exposure
  • 100% job and business oriented training
  • Certificate of completion recognized from Trade Testing Board, Government of Pakistan
  • Claim Continuing Professional Development (CPD) hours for the training
  • Video recorded session with personalized Learning Management System (LMS) access login id
  • Lifetime access to exclusive YouExcel alumni via WhatsApp and Facebook groups
  • Fully equipped training center venue for on-campus trainings readily available with laptops, projectors and air-conditioning
  • Virtual training facility available
  • Guest speaker sessions for latest market insights from business leaders


  • MIS Reporting Analyst
  • Business Intelligence Analyst
  • Data Analyst
  • Data Visualization Specialist
  • Quantitative Analyst
  • Data Scientist
  • IT Operations Analyst