Next Data Analytics & Data Science batch starts 5th December — Limited seats with live classes.

Enrol Now →

CognitiaX AI · Program

Data Analytics / Data Analyst Program

Python • SQL • Excel • Power BI • Tableau • Snowflake – job-ready Data Analyst program.

Duration: 5–6 monthsOffline: ₹80,000Online: ₹60,000Next batch: 5th December
Enquire / Enroll →Chat on WhatsApp

Download full program brochure ↓

Program Highlights

  • • Live classes + LMS access + recordings
  • • 70% hands-on with real datasets
  • • Placement & interview preparation

Tools you’ll master

PythonPandasNumPySQLExcelPower BITableauSnowflakeAWS / Azure

Detailed Syllabus

Here’s how we take you from basics to a job-ready Data Analytics / Data Analyst.

Introduction to Data Analytics
  • What does a Data Analyst do?
  • Career paths, domains & salaries
  • Tools & technologies used in this course
  • Complete roadmap & how the course works
Python Setup & Fundamentals(6–8 hours)
  • Environment setup: Google Colab, Anaconda, VS Code
  • Python syntax, variables & data types
  • Lists, tuples, dictionaries & sets
  • Conditions, loops (for, while) & functions
Data Analysis with Python (NumPy + Pandas)
  • NumPy arrays & vectorised operations
  • Pandas Series & DataFrame basics
  • Importing CSV/Excel/SQL data
  • Data cleaning: missing values, duplicates, outliers
  • Merging, joining & groupby, aggregations
  • Exploratory Data Analysis (EDA)
Statistics & Probability for Analytics
  • Descriptive statistics: mean, median, mode, variance, SD
  • Distributions: normal, binomial, Poisson
  • Correlation & covariance
  • Sampling, CLT & confidence intervals
  • Hypothesis testing: t-test, chi-square (conceptual)
SQL for Data Analysts
  • SELECT, WHERE, ORDER BY, LIMIT
  • GROUP BY, HAVING & aggregate functions
  • JOINS (INNER, LEFT, RIGHT, FULL)
  • Subqueries & CTEs
  • Intro to window functions
Advanced Excel for Analysis
  • Important formulas: IF, SUMIFS, COUNTIFS, INDEX/MATCH
  • Text, date & lookup functions
  • Pivot tables & pivot charts
  • Excel dashboards & MIS-style reports
Power BI – Dashboards & Reporting
  • Connecting multiple data sources (Excel, CSV, SQL)
  • Power Query for cleaning & transformation
  • Data modelling & relationships
  • Intro to DAX: calculated columns & measures
  • Interactive dashboards, slicers & publishing to Power BI Service
Tableau for Data Visualisation
  • Connecting to data sources
  • Dimensions, measures & basic charts
  • Filters, parameters & calculated fields
  • Building dashboards & stories
Cloud & Data Warehousing (Snowflake + AWS/Azure)
  • Database vs Data Warehouse
  • Basics of Snowflake architecture
  • Loading data & querying in Snowflake (overview)
  • Connecting BI tools with Snowflake
Capstone Projects & Interview Prep
  • End-to-end Power BI sales / revenue dashboard
  • UPI / banking / insurance analytics project
  • Excel + SQL based MIS reporting project
  • Mock interviews & interview questions practice
  • Resume & LinkedIn optimisation for Data Analyst roles

Real-World Projects You’ll Build

  • • Power BI Sales / Revenue Analysis Dashboard
  • • UPI / Banking Transactions Analytics
  • • Excel + SQL MIS Reporting Dashboard
  • • Tableau Storytelling Dashboard

+ many more industry-relevant projects included in the program.

💬 WhatsApp Us