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

Class 37 – Introduction to SQL & Databases | Core Clauses (SELECT, FROM, WHERE, GROUP BY) | Aggregation Functions (SUM, COUNT, AVG, etc.) | Date Functions

Class 38 – SQL Clauses (HAVING, ORDER BY) | Order of Operations | String, Numeric & CONCAT Functions | Comparison & Conditional Operators | IS/IS NOT & ISNULL Functions | Joins Concepts

Class 39 – SQL Joins Project | Joins (INNER, OUTER, LEFT, RIGHT) | ER Diagrams | Facts vs Dimensions | Relationships | UNION

Class 40 – MySQL Introduction & Concepts | Subqueries (Scalar & Multi-Row) | Derived Tables | Window Functions (ROW_NUMBER, RANK, etc.)

Class 41 – Python Introduction | Variable Types | Numeric Functions | String Functions

Class 42 – Python Lists & Functions | Conditional Statements (IF, ELIF, ELSE) | Loops & Short Project

Class 43 – Python Modules & Libraries (Pandas, NumPy, Matplotlib) | Aggregation Functions | Data Analytics with Pandas | DataFrames Basics

Class 44 – Python Challenge Questions | Pandas Data Manipulation | NumPy Arrays & Statistics | Matplotlib & Seaborn Visualization

Class 45 – Python End-to-End Project | ETL Process | Data Exploration, Cleaning & Transformation

Class 46 – Resume Building | LinkedIn Optimization | Freelancing (Fiverr & Upwork) | Portfolio Development

Class 47 – API Concepts | Integrations & Solutions | Tableau Basics | Relationships | Calculated Fields & Measures | Dashboard Creation

Class 48 – ML & Automation Intro | Demystifying AI | Data & AI | AI for Technical Work | AI for Stakeholder Management

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 – Introduction to SQL & Databases | Core Clauses (SELECT, FROM, WHERE, GROUP BY) | Aggregation Functions (SUM, COUNT, AVG, etc.) | Date Functions

Data Analyst (Batch 09) Session 37

Class 38 – SQL Clauses (HAVING, ORDER BY) | Order of Operations | String, Numeric & CONCAT Functions | Comparison & Conditional Operators | IS/IS NOT & ISNULL Functions | Joins Concepts

Data Analyst (Batch 09) Session 38

Class 39 – SQL Joins Project | Joins (INNER, OUTER, LEFT, RIGHT) | ER Diagrams | Facts vs Dimensions | Relationships | UNION

Data Analyst (Batch 09) Session 39

Class 40 – MySQL Introduction & Concepts | Subqueries (Scalar & Multi-Row) | Derived Tables | Window Functions (ROW_NUMBER, RANK, etc.)