ABOUT THE COURSE:

Certificate in Dashboard Reporting Analysis with Power BI enables you 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.

WHAT YOU WILL LEARN

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

    Integrate existing data with Power BI seamlessly with any source

    Automate repetitive tasks to boost efficiency

COURSE OUTLINE:

    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.9 Relationship View

    3.10 Create and manage relationships in Power BI Desktop

    3.11 Data Type in Power BI Desktop

    3.12 Measures in Power BI Desktop

    3.13 Calculated Columns and Tables

    3.14 DAX Basics

    3.15 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.15 Ribbon Graphs

    4.15 Scatterplots and Bubbleplots

    4.15 Using Smart Narrative feature in Power BI

    4.15 Creating Dashboard report using Q&A feature

    4.15 Publish from Power BI Desktop

    4.15 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.9 Introducing Functions

    5.10 Optional Parameters: Extending Functions

    5.11 Function Short-Hand

    5.12 Function in Function

    5.13 Records

    5.14 The Underscore Parameter

    5.15 Running Totals & Grouped Indexes

    5.15 Create a Grouped Index

    5.15 Create a Running Total

    5.15 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.9 Create Dynamic Metric Selection

    6.10 Advanced Data Modeling & DAX Use Case

    6.11 Create the Filter Dimension in Power Query

    6.12 Relate the Filter Dimension in the Data Model

    7.1 Articial Intelligence in Power BI

    7.2 Generate a Summary with a Smart Narrative

    7.3 Create a Q&A Visual

    7.4 Congure the Q&A Visual

    7.5 Analyze to Explain the Increase or Decrease

    7.6 Identify the Key Inuencers

    7.7 Create a Decomposition Tree

    7.9 Detect Anomalies

    7.10 Forecast Future Values

    7.11 Generate Insights in Power BI Service

    8.1 Introduction - Python Integration in Power BI

    8.2 Download & Connect Python to Power BI

    8.3 Create Data with a Python Script

    8.4 Import External Data with Python

    8.5 Run a Python Script in Power Query

    8.6 Machine Learning with Python in Power BI

    8.7 Load & Inspect the Dataset

    8.9 Build a Classication Model

    8.10 Update the Classication Model in Power Query

    8.11 Visualize Classication Model with a Decision Tree

TRAINER PROFILE

Tahir Ali

Dashboard Reporting and Analysis with Power BI

Microsoft Certified Trainer Microsoft Office Master Certified (2016) MBA Finance

Tahir Ali is a highly motivated corporate trainer with experience in training small and large groups across diverse industries.

View More

DURATION

36 hours

PRE-REQUISITE

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

VALUE ADDED SERVICES

  • 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

CAREER-PATHS

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

REGISTRATION FORM