BECOME POWER BI DASHBOARD SPECIALIST & GET CERTIFIED BY IFA-UK

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