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.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