Data Analyst (Batch-09) Certification Program

Class 01 – Introduction to Excel | Cell Ranges & Referencing | Numeric Functions | Text Functions

Data Analyst (Batch-09) – Session 01

02:00:30

Class 02 – Text Functions | Logical Functions

Class 03 – Mastered Sorting (Single & Multi-Column) | Advanced Filtering Techniques | Text Functions (LEFT, RIGHT, LEN) | Data Cleaning Best Practices | Hands-On Practice Session

Class 04 – Data Validation | Conditional Formatting

Class 05 – Logical & Conditional Functions | Lookup Functions | Ranking & Rounding | TEXTJOIN Function

Class 06 – Pivot Tables (Basic to Advanced Analysis)

Class 07 – Advanced Pivot Table Techniques | Complex Calculations in Pivot Tables | Maximizing Data Insights with Pivot Power Plus

Class 08 – Modern Design Interactive Excel Dashboard (Part 01)

Class 09 – Modern Design Interactive Excel Dashboard (Part 02)

Class 10 – Dashboard Blueprint | Designing Layouts | Key Calculations | Building Professional Dashboards for Effective Decision-Making

Class 11 – Finalized Dashboard | Excel Project Discussion | Power Query Basics | Building Connections | Automating Steps with Advanced Add-ins

Class 12 – Detailed Introduction of Power-BI | Introduction to Power BI |Introduction to Ribbons | Exploring Data Sources | Power Query Overview

Class 13 – ETL | Data Cleaning with Power Query: Advanced Techniques and Best Practices

Class 14 – Power Query | Conditional Columns | Columns for Examples | Data Tools | Substract Days | Group By | Advanced Filtering & Sorting

Class 15 – Power Query: Parameters | Append Queries | Folder Selection | Data Normalization Concepts | Data Modeling

Class 16 – Introduction to Data Modeling | Concepts of Facts vs Dimension Tables | Star, Snowflake & Galaxy Schemas | Data Formatting Essentials

Class 17 – Introduction to Calculated Columns | Text Functions | Date Functions | SUBSITUTE, FIND, SEARCH, Dynamic RIGHT & LEFT

Class 18 – Final Excel Project Presentation Day

Class 19 – Calculated Columns | Concept of Logical Operators | Logical Functions | IF | Nested IF, SWITCH (with TRUE), AND, OR | Dynamic Formula Concepts

Class 20 – Calculated Measures: Implicit vs Explicit | Filter Context | Aggregation Functions

Class 21 – Calculated Measures: Filter Flow Concepts: Examples of Calculated Functions and Multi-Dimensional Analysis

Class 22 – Calculated Measures: Advanced Calculated Functions: ALL Conditions, Variables, and Practical Examples

Class 23 – Calculated Measures: Filter Functions with Explicit Measures | Merging Measures into a Single Calculated Measure | Iterator Functions

Class 24 – Calculated Measures: Iterator Functions | Time Intelligence Functions

Class 25 – Calculated Measures: Handling Errors | Data Visualizations

Class 26 – Data Visualizations: Line Chart, Bar Chart, KPI Chart, Table and Metrix Visual & Formatting | Customer Tooltips Conditional Formatting

Class 27 – Data Visualizations: Filters Types | Top N Filters | KPI Chart | Gauge Charts | Area Chart

Class 28 – Data Visualizations: Custom Tooltip Option and Advanced Features | Donut & Pie Charts, Visual Pages, Card Visuals | Slicers | Area Chart | Drill-Up, Drill-Down Through | Bookmarks | Page Navigation

Class 29 – Data Visualizations: Dashboard Finalization | Dashboard Publishing Concept | Power-BI Services Introduction, Data Refreshers | RLS (Row Level Securities) | Credentials Assigned | Workspaces Assess

Class 30 – SQL Queries Concepts | Data Fetching from SQL Database Throughout in PowerBI | Power Query and ETL for Financial Dashboard Data and Data Modelling | Dashboard Designing Techniques

Class 31 – Income Statement | Income Statement Composition | Revenue by Trend | Operating Expense | Calculated Measures and Designing | Charts Designing and Finalization

Class 32 – Advanced Calculated Measures & Functions | Balance Sheet | Statement of Financial Position Page Design | Data Visualization | Advanced Dashboard Design Concepts

Class 33 – Financial Dashboard (Finalization & Publishing) | Dashboard Deployment Best Practices | Power BI Services Overview (Data Refreshers) | Row-Level Security | Credential Management | Workspace Setup

Class 34 – Core Financial Reporting with Power BI & IA | Building Accounts Receivable Dashboards from Scratch with Advanced Techniques

Class 35 – Advanced Dashboard Design Strategies | Advanced Power Query Concepts with M-Code Techniques | Building Performance Analysis Dashboards from Scratch

Class 36 – Finalizing Performance Dashboards with Advanced Methods | Solving Real Financial Reporting Problems for Global Clients

Course Content

Class 01 – Introduction to Excel | Cell Ranges & Referencing | Numeric Functions | Text Functions

Data Analyst (Batch-09) – Session 01

Class 02 – Text Functions | Logical Functions

Data Analyst (Batch-09) – Session 02

Class 03 – Mastered Sorting (Single & Multi-Column) | Advanced Filtering Techniques | Text Functions (LEFT, RIGHT, LEN) | Data Cleaning Best Practices | Hands-On Practice Session

Data Analyst (Batch-09) – Session 03

Class 04 – Data Validation | Conditional Formatting

Data Analyst (Batch-09) – Session 04

Class 05 – Logical & Conditional Functions | Lookup Functions | Ranking & Rounding | TEXTJOIN Function

Data Analyst (Batch-09) – Session 05

Class 06 – Pivot Tables (Basic to Advanced Analysis)

Data Analyst (Batch-09) – Session 06

Class 07 – Advanced Pivot Table Techniques | Complex Calculations in Pivot Tables | Maximizing Data Insights with Pivot Power Plus

Data Analyst (Batch 09) – Session 07

Class 08 – Modern Design Interactive Excel Dashboard (Part 01)

Data Analyst (Batch 09) – Session 08

Class 09 – Modern Design Interactive Excel Dashboard (Part 02)

Data Analyst (Batch 09) – Session 09

Class 10 – Dashboard Blueprint | Designing Layouts | Key Calculations | Building Professional Dashboards for Effective Decision-Making

Data Analyst (Batch 09) – Session 10

Class 11 – Finalized Dashboard | Excel Project Discussion | Power Query Basics | Building Connections | Automating Steps with Advanced Add-ins

Data Analyst (Batch 09) – Session 11

Class 12 – Detailed Introduction of Power-BI | Introduction to Power BI |Introduction to Ribbons | Exploring Data Sources | Power Query Overview

Data Analyst (Batch 09) – Session 12

Class 13 – ETL | Data Cleaning with Power Query: Advanced Techniques and Best Practices

Data Analyst (Batch 09) – Session 13

Class 14 – Power Query | Conditional Columns | Columns for Examples | Data Tools | Substract Days | Group By | Advanced Filtering & Sorting

Data Analyst (Batch 09) – Session 14

Class 15 – Power Query: Parameters | Append Queries | Folder Selection | Data Normalization Concepts | Data Modeling

Data Analyst (Batch 09) – Session 15

Class 16 – Introduction to Data Modeling | Concepts of Facts vs Dimension Tables | Star, Snowflake & Galaxy Schemas | Data Formatting Essentials

Data Analyst – (Batch 09) Session16

Class 17 – Introduction to Calculated Columns | Text Functions | Date Functions | SUBSITUTE, FIND, SEARCH, Dynamic RIGHT & LEFT

Data Analyst – (Batch 09) Session 17

Class 18 – Final Excel Project Presentation Day

Data Analyst – (Batch 09) Session 18

Class 19 – Calculated Columns | Concept of Logical Operators | Logical Functions | IF | Nested IF, SWITCH (with TRUE), AND, OR | Dynamic Formula Concepts

Data Analyst (Batch 09) Session 19

Class 20 – Calculated Measures: Implicit vs Explicit | Filter Context | Aggregation Functions

Data Analyst (Batch 09) Session 20

Class 21 – Calculated Measures: Filter Flow Concepts: Examples of Calculated Functions and Multi-Dimensional Analysis

Data Analyst (Batch 09) Session 21

Class 22 – Calculated Measures: Advanced Calculated Functions: ALL Conditions, Variables, and Practical Examples

Data Analyst (Batch 09) Session 22

Class 23 – Calculated Measures: Filter Functions with Explicit Measures | Merging Measures into a Single Calculated Measure | Iterator Functions

Data Analyst (Batch 09) Session 23

Class 24 – Calculated Measures: Iterator Functions | Time Intelligence Functions

Data Analyst (Batch 09) Session 24

Class 25 – Calculated Measures: Handling Errors | Data Visualizations

Data Analyst (Batch 09) Session 25

Class 26 – Data Visualizations: Line Chart, Bar Chart, KPI Chart, Table and Metrix Visual & Formatting | Customer Tooltips Conditional Formatting

Data Analyst (Batch 09) Session 26

Class 27 – Data Visualizations: Filters Types | Top N Filters | KPI Chart | Gauge Charts | Area Chart

Data Analyst (Batch 09) Session 27

Class 28 – Data Visualizations: Custom Tooltip Option and Advanced Features | Donut & Pie Charts, Visual Pages, Card Visuals | Slicers | Area Chart | Drill-Up, Drill-Down Through | Bookmarks | Page Navigation

Data Analyst (Batch 09) Session 28

Class 29 – Data Visualizations: Dashboard Finalization | Dashboard Publishing Concept | Power-BI Services Introduction, Data Refreshers | RLS (Row Level Securities) | Credentials Assigned | Workspaces Assess

Data Analyst (Batch 09) Session 29

Class 30 – SQL Queries Concepts | Data Fetching from SQL Database Throughout in PowerBI | Power Query and ETL for Financial Dashboard Data and Data Modelling | Dashboard Designing Techniques

Data Analyst (Batch 09) Session 30

Class 31 – Income Statement | Income Statement Composition | Revenue by Trend | Operating Expense | Calculated Measures and Designing | Charts Designing and Finalization

Data Analyst (Batch 09) Session 31

Class 32 – Advanced Calculated Measures & Functions | Balance Sheet | Statement of Financial Position Page Design | Data Visualization | Advanced Dashboard Design Concepts

Data Analyst (Batch 09) Session 32

Class 33 – Financial Dashboard (Finalization & Publishing) | Dashboard Deployment Best Practices | Power BI Services Overview (Data Refreshers) | Row-Level Security | Credential Management | Workspace Setup

Data Analyst (Batch 09) Session 33

Class 34 – Core Financial Reporting with Power BI & IA | Building Accounts Receivable Dashboards from Scratch with Advanced Techniques

Data Analyst (Batch 09) Session 34

Class 35 – Advanced Dashboard Design Strategies | Advanced Power Query Concepts with M-Code Techniques | Building Performance Analysis Dashboards from Scratch

Data Analyst (Batch 09) Session 35

Class 36 – Finalizing Performance Dashboards with Advanced Methods | Solving Real Financial Reporting Problems for Global Clients

Data Analyst (Batch 09) Session 36

Class 37 –

Data Analyst (Batch 09) Session 37

Class 38 –

Data Analyst (Batch 09) Session 38

Class 39 –

Data Analyst (Batch 09) Session 39

Class 40 –