Diwali offer: Flat 30% off on all courses plus free career counselling. Ends 5 Nov.Claim offer

Data Analytics

Turn raw data into powerful insights. Learn Excel, SQL, Python for data analysis, and visualisation tools like Power BI and Tableau — the complete data analytics skill set employers demand.

4–6 Months Offline / Online Certificate Provided Real Dataset Projects

Course Overview

The Data Analytics course at White Fortress Academy teaches you how to collect, clean, analyse and visualise data to help businesses make smarter decisions. Data analytics is one of the fastest-growing and highest-paying fields in IT today.


You will start with Advanced Excel for data manipulation, then move to SQL for database querying, Python (Pandas, NumPy) for data analysis, and Power BI / Tableau for creating stunning interactive dashboards and reports.


Throughout the course you will work with real business datasets — sales data, marketing data, financial reports — giving you practical experience that you can directly apply in a job from day one.

Course Curriculum

29 modules · 87 topics

Excel for Data Analysis

7 modules · Month 1
01

Excel Formulas & Functions

4 topics
  • Logical Functions
  • IF & nested IF
  • AND, OR & NOT
  • IFS
  • Text Functions
  • LEFT, RIGHT & MID
  • TRIM & CLEAN
  • TEXTJOIN
  • Date & Time Functions
  • TODAY & NOW
  • DATEDIF
  • NETWORKDAYS
  • Error Handling
  • IFERROR
  • ISNA & ISBLANK
02

Lookup Functions

2 topics
  • Classic Lookups
  • VLOOKUP
  • HLOOKUP
  • Exact vs approximate match
  • Modern Lookups
  • INDEX-MATCH
  • XLOOKUP
  • Two-way lookups
03

Pivot Tables

3 topics
  • Pivot Basics
  • Create & refresh
  • Fields & layouts
  • Value settings
  • Interactivity
  • Slicers
  • Timelines
  • Pivot charts
  • Advanced Pivots
  • Grouping data
  • Calculated fields
  • Data model basics
04

Data Cleaning in Excel

3 topics
  • Cleaning Tools
  • Remove duplicates
  • Text to columns
  • Flash Fill
  • Power Query Basics
  • Import data
  • Transform steps
  • Merge queries
  • Formatting
  • Conditional formatting
  • Data validation rules
05

What-If & Validation

3 topics
  • What-If Analysis
  • Goal Seek
  • Scenario Manager
  • Data tables
  • Validation
  • Dropdown lists
  • Input messages & alerts
  • Protection
  • Lock cells
  • Protect sheets & workbooks
06

Charts & Dashboards

3 topics
  • Chart Types
  • Column, line & pie
  • Combo charts
  • Histograms & waterfall
  • Dashboard Design
  • Layout principles
  • KPI cards
  • Colour & clarity
  • Interactive Reports
  • Slicers
  • Linked charts
07

Excel Project

3 topics
  • Project Setup
  • Data preparation
  • KPI definitions
  • Build
  • Pivot summaries
  • Charts & dashboard
  • Present
  • Insights & recommendations
  • Review

SQL & Databases

7 modules · Month 2
08

SQL Basics

3 topics
  • Querying
  • SELECT & FROM
  • WHERE
  • ORDER BY & LIMIT
  • Filtering
  • AND, OR & IN
  • LIKE & wildcards
  • BETWEEN & IS NULL
  • Shaping Output
  • Aliases
  • DISTINCT
09

Joins

3 topics
  • Join Types
  • INNER JOIN
  • LEFT & RIGHT JOIN
  • FULL JOIN
  • Special Joins
  • Self joins
  • Cross joins
  • Set Operations
  • UNION & UNION ALL
  • INTERSECT & EXCEPT
10

Aggregation

3 topics
  • Aggregate Functions
  • COUNT
  • SUM & AVG
  • MIN & MAX
  • Grouping
  • GROUP BY
  • HAVING
  • Conditional Logic
  • CASE expressions
  • Date functions
11

Subqueries & CTEs

3 topics
  • Subqueries
  • Nested queries
  • Correlated subqueries
  • CTEs & Views
  • WITH clause
  • Creating views
  • Window Functions
  • ROW_NUMBER & RANK
  • Running totals
  • LAG & LEAD
12

MySQL Setup & Administration

3 topics
  • Setup
  • Install MySQL
  • Workbench basics
  • Tables
  • Create tables
  • Constraints & keys
  • Indexes
  • Data Movement
  • Import data
  • Export data
13

Data Cleaning in SQL

3 topics
  • NULL Handling
  • COALESCE
  • IFNULL & NULLIF
  • String Functions
  • SUBSTRING & CONCAT
  • TRIM & REPLACE
  • Duplicates
  • Detect duplicates
  • Remove duplicates
14

SQL Project

3 topics
  • Setup
  • Retail database
  • Business questions
  • Analysis
  • Sales reports
  • Customer analysis
  • Present
  • Findings summary
  • Review

Python for Data Analysis

7 modules · Month 3–4
15

Python Basics

3 topics
  • Setup
  • Python & Jupyter Notebook
  • Running cells
  • Core Syntax
  • Variables & data types
  • Loops & conditions
  • Functions
  • Defining functions
  • Arguments & return values
16

Python Data Structures

3 topics
  • Collections
  • Lists
  • Tuples
  • Dictionaries & sets
  • Comprehensions
  • List comprehensions
  • Dictionary comprehensions
  • Files
  • String handling
  • Reading CSV & Excel
17

NumPy

3 topics
  • Arrays
  • Creating arrays
  • Indexing & slicing
  • Operations
  • Mathematical operations
  • Broadcasting
  • Statistics
  • Mean, median & standard deviation
  • Random numbers
18

Pandas

3 topics
  • DataFrames
  • Series & DataFrames
  • Reading data
  • Inspecting data
  • Selecting Data
  • loc & iloc
  • Boolean filtering
  • Sorting
  • Transforming Data
  • Merge & join
  • GroupBy & aggregation
  • Pivot tables
19

Data Cleaning in Python

3 topics
  • Missing Data
  • Detect missing values
  • Fill & drop
  • Quality
  • Duplicates
  • Outliers
  • Type conversion
  • Feature Creation
  • New columns
  • Binning
20

Data Visualisation

3 topics
  • Matplotlib
  • Line & bar charts
  • Subplots & labels
  • Seaborn
  • Distribution plots
  • Heatmaps & pair plots
  • Practice
  • Chart styling
  • Choosing the right chart
21

Python Project

3 topics
  • EDA Workflow
  • Data loading
  • Summary statistics
  • Analysis
  • Visual exploration
  • Insights & findings
  • Delivery
  • Jupyter tips
  • Final presentation

Power BI, Tableau & AI

8 modules · Month 4–6
22

Power BI Basics

3 topics
  • Getting Started
  • Power BI Desktop
  • Importing data
  • Visuals
  • Charts & tables
  • Filters & slicers
  • Reports
  • KPI cards
  • Report layout
23

Power Query

3 topics
  • Transformations
  • Remove & split columns
  • Data types
  • Combining Data
  • Merge queries
  • Append queries
  • Reuse
  • Query steps
  • Parameters
24

Data Modelling

3 topics
  • Relationships
  • One-to-many
  • Star schema
  • Calculations
  • Calculated columns
  • Measures
  • Model Hygiene
  • Hiding fields
  • Date tables
25

DAX

3 topics
  • DAX Basics
  • Syntax
  • Calculated columns
  • Core Functions
  • CALCULATE
  • FILTER & ALL
  • Time Intelligence
  • YTD & MTD
  • Previous period comparison
26

Tableau

3 topics
  • Getting Started
  • Connecting data
  • Dimensions & measures
  • Charts
  • Bar, line & maps
  • Filters
  • Dashboards
  • Calculated fields
  • Dashboard actions
  • Story points
27

Data Sources & Publishing

3 topics
  • Connections
  • SQL & Excel sources
  • Refresh settings
  • Publishing
  • Power BI Service
  • Sharing reports
  • Design
  • Dashboard best practices
  • Accessibility
28

AI for Data Analysis

3 topics
  • AI Assistants for Analysts
  • Prompts for formulas, SQL & Python
  • Explaining & debugging code
  • Summarising datasets
  • AI in Excel & Power BI
  • Built-in AI features overview
  • Asking questions in plain language
  • Auto-generated insights
  • Using AI Responsibly
  • Checking AI answers
  • Protecting confidential data
  • Spotting bias & wrong conclusions
29

Capstone Project

3 topics
  • Planning
  • Business requirements
  • Data planning
  • Build
  • Data model
  • Dashboard pages
  • Review
  • Presentation
  • Feedback & improvements

Practice Projects

Project 1Sales dashboard in Excel
Project 2Retail database analysis with SQL
Project 3Exploratory data analysis with Python
Project 4Business intelligence dashboard in Power BI
Project 5Customer segmentation report
Project 6Monthly KPI reporting pack

Tools & Technologies

MS Excel (Advanced) MySQL Python 3 Pandas NumPy Matplotlib Seaborn Power BI Tableau Public Jupyter Notebook Google Sheets

Career Opportunities

Data Analyst

Analyse business data, build reports and help organisations make data-driven decisions.

Business Intelligence Analyst

Create interactive dashboards and reporting systems using Power BI or Tableau.

SQL / Database Analyst

Query and manage large databases for banks, e-commerce companies and enterprises.

Data Science (Junior)

Use Python and statistics to explore data and build a foundation for machine learning roles.

Course Details

Duration4–6 Months
ModeOffline (Delhi Centre) / Online Classes Available
Batch TimingMorning & Evening Batches (Mon–Sat)
EligibilityBasic computer and MS Excel knowledge preferred. No prior coding experience required.
CertificateCompletion Certificate from White Fortress Academy provided on passing
SupportReal dataset projects + Dashboard portfolio + Placement guidance

Frequently Asked Questions

How long is the Data Analytics course in Delhi?

The Data Analytics course takes 4–6 months.

Is the Data Analytics course offline or online, and what are the batch timings?

Mode: Offline (Delhi Centre) / Online Classes Available. Batch timing: Morning & Evening Batches (Mon–Sat).

Who can join the Data Analytics course? Do I need any prior knowledge?

Basic computer and MS Excel knowledge preferred. No prior coding experience required.

Will I get a certificate after the Data Analytics course?

Yes. White Fortress Academy provides a completion certificate on passing the course.

Which tools and software will I learn in the Data Analytics course?

You will work with advanced MS Excel, MySQL, Python 3, Pandas, NumPy, Matplotlib, Seaborn, Power BI, Tableau Public, Jupyter Notebook and Google Sheets.

What jobs can I aim for after the Data Analytics course?

Career paths covered on this page include Data Analyst, Business Intelligence Analyst, SQL / Database Analyst and Junior Data Scientist. Hiring depends on your skills and the market. The academy's support includes real dataset projects, dashboard portfolio and placement guidance.

What is the fee for the Data Analytics course, and can I try a demo class?

The fee is not listed on this page, so please ask the centre for the current fee and the next batch date. Call or WhatsApp +91 88104 71374, or visit 53, Maujpur Main Road, Opp. HDFC Bank, Delhi 110053 (Monday to Saturday, 9:00 AM to 8:00 PM). A free demo class is available.

Start Your Data Analytics Career!

Data is the new oil — and analysts who can interpret it are in massive demand. Join us and build skills that pay.

Enroll Now Ask on WhatsApp