Data Analysis Course

Course Highlights

Trainer

Industry Experts in Data & Analytics with 10+ years experience

 Tools Covered
                            Excel
                            SQL
                            Python
                            Power BI
                            Tableau
                            Jupyter
                            GitHub
                            Google Sheets
                        

Internship

Internship in real time projects with AB Software or Partner Companies

Certifications

Course Completion + Internship Letter (Optional)

Career Support

Resume building, interview preparation, and job placement support

Deliverables

Projects, Dashboards, Reports, GitHub Portfolio, Capstone Project

Course Syllabus

Month 1: Introduction to Data Analysis & Excel Mastery

Introduction to Data Analysis

What is Data Analysis?
Roles of a Data Analyst
Types of Data: Structured vs Unstructured
Lifecycle of Data Analysis Projects
Tools used in the industry

Advanced Excel for Data Analytics

Excel Basics & Advanced Formulas
Data Cleaning and Validation
Pivot Tables & Pivot Charts
VLOOKUP, HLOOKUP, INDEX-MATCH, IF, SUMIFS
Conditional Formatting
Excel Dashboards (Mini Project)

Month 2: SQL for Data Analysts

SQL Basics

What is SQL and RDBMS?
SELECT, WHERE, ORDER BY, LIMIT
Filtering and Sorting Data
Working with Joins (INNER, LEFT, RIGHT, FULL)
GROUP BY, HAVING, COUNT, SUM, AVG

Advanced SQL

Subqueries & Nested Queries
CASE Statements
CTEs and Window Functions
Data Aggregation & Transformation
SQL Project: Sales/Marketing Data Analysis

Month 3: Python for Data Analysis – Level 1

Python Basics

Installing Python & Jupyter Notebook
Data Types, Variables, Functions
Loops, Conditions, Exception Handling
Working with Files and Directories

Python for Data Wrangling

Introduction to NumPy (Arrays, Math Operations)
Introduction to Pandas (Series, DataFrames)
Data Cleaning: Handling nulls, duplicates, renaming
Data Manipulation: Merge, Groupby, Filter, Apply
Real-world Dataset Hands-on (Mini Project)

Month 4: Data Visualization & EDA (Exploratory Data Analysis)

Matplotlib & Seaborn in Python

Bar Charts, Histograms, Line Graphs, Pie Charts
Heatmaps, Pairplots, Boxplots
Customizing Plots & Aesthetics
Project: Visualize E-Commerce Dataset

Power BI or Tableau (Choose One)

Data Import & Transformation
Creating Dashboards and KPIs
Filters, Slicers, Drill-downs
Publishing and Sharing Reports
Mini Project: Sales or Marketing Dashboard

Month 5: Business Use Cases & Domain Exposure

Business Domains

BFSI (Banking, Finance, Insurance)
E-Commerce
Marketing Analytics
Healthcare / HR / Retail Data Use Cases

Real-world Case Studies

Sales Forecasting
Customer Segmentation
Churn Analysis
Market Basket Analysis

Month 6: Capstone Project + Career Readiness

Capstone Project Development

Collecting and cleaning real dataset
Defining business problem
Data Analysis & Visualization
Insights & Recommendations

Resume, Interview & Job Prep

Building Resume for Data Analyst Role
Project Portfolio on GitHub
Interview Questions (SQL, Excel, Python, Scenario-Based)
Mock Interviews & HR Rounds
LinkedIn Profile Optimization

Bonus Features

Live Projects + Capstone

Work on real-world datasets and business problems

1-on-1 Mentoring

Personalized guidance from industry experts

Resume + Portfolio Review

Get expert feedback on your resume and GitHub portfolio

Lifetime Learning Resources

Access to datasets, templates, and coding resources

Get Course Details

Thank You!