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
4–6 MonthsCourse Duration
4 ModulesStructured Curriculum
Industry DatasetsReal-world Practice
CertificateOn Completion

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

01

Excel for Data Analysis

Month 1
  • Advanced Excel — Formulas & Functions
  • VLOOKUP, HLOOKUP, INDEX-MATCH
  • Pivot Tables & Pivot Charts
  • Data Cleaning & Conditional Formatting
  • What-If Analysis & Data Validation
  • Project: Sales Dashboard in Excel
02

SQL & Database Querying

Month 2
  • SQL Basics — SELECT, WHERE, ORDER BY
  • Joins — INNER, LEFT, RIGHT & FULL JOIN
  • GROUP BY, HAVING & Aggregate Functions
  • Subqueries & CTEs
  • MySQL Database Setup & Administration
  • Project: Retail Database Analysis
03

Python for Data Analysis

Month 3–4
  • Python Basics & Jupyter Notebook
  • Pandas — DataFrames, Merging & Grouping
  • NumPy — Arrays & Mathematical Operations
  • Matplotlib & Seaborn — Data Visualisation
  • Data Cleaning — Handling Missing Values
  • Project: Exploratory Data Analysis (EDA)
04

Power BI & Tableau

Month 4–6
  • Power BI Desktop — Reports & Dashboards
  • DAX Formulas & Calculated Columns
  • Power Query — Data Transformation
  • Tableau — Charts, Filters & Story Points
  • Connecting to SQL & Excel Data Sources
  • Capstone: Business Intelligence Dashboard

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

Duration: 4–6 Months


Mode: Offline (Delhi Centre) / Online Classes Available


Batch Timing: Morning & Evening Batches (Mon–Sat)


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


Certificate: Completion Certificate from White Fortress Academy provided on passing


Support: Real dataset projects + Dashboard portfolio + Placement guidance

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