Data analytics training provides skills in examining, cleaning, transforming, and modeling data to uncover insights and inform business decisions. A typical overview includes learning fundamental tools like Excel and SQL, data visualization with tools like PowerBI, statistical analysis  other tools like Python, and professional skills like communication and problem-solving. The training process focuses on practical application, from defining questions and collecting data to analyzing results and presenting them in an understandable format.

TOPIC COVERED

WEEK 1: FOUNDATION (EXCEL FUNDAMENTALS)

TOPICS:

DAY 1

• Introduction to Spreadsheet (excel interface)
• Cell references (absolute, relative, and mixed)
• Data formatting and conditional formatting

DAY 2

• Functions and Formulas
• VLOOKUP, HLOOKUP, INDEX/MATCH, XLOOKUP

Project: Sales Data Analysis Dashboard

• Download sample dataset from Kaggle
• Create a dashboard showing total sales, top products, monthly trends
• Use conditional formatting to highlight high and low performers

WEEK 2: ADVANCE EXCEL

TOPICS:

DAY 1

• Pivot tables and pivot charts
• Basic charts and visualizations

DAY 2

• Data Management

PROJECT: HR Analytics Dashboard

• Download dataset from Kaggle
• Create pivot tables to analyze department performance, attrition rates
• Build a dashboard with slicers to filter by department, age, etc

Project presentation.

WEEK 3: SQL BASICS

TOPICS:

DAY 1

• Database fundamentals (tables, relationships)
• Basic SQL Queries (SELECT, FROM, WHERE)

DAY 2

• Sorting and Filtering (ORDER BY, GROUP BY, HAVING)
• Aggregations (COUNT, SUM,AVG, MIN, MAX)

PROJECT 1: Chinook database analysis

PROJECT 2: Accenture database analysis

WEEK 4: Intermediate SQL

DAY 1

• Dataset importation
• SQL JOINS

DAY 2

• Data Manipulation (INSERT, UPDATE, DELETE)
• Data Definition

PROJECT: Pizza Sales Analysis

Project presentation

WEEK 5: POWERBI FUNDAMENTAL

TOPICS:

DAY 1

• Power BI Interface
• Importing and transforming data
• Data cleaning with Power Query

DAY 2

• Building interactive dashboard
• DAX

PROJECT 1: KMS Superstore dashboard

PROJECT 2: Accenture dashboard

WEEK 6:

Topics: Visualization and Python

DAY 1

• Python environmental setup
• Python basics (variables, data types)
• Functions and basic error handling

DAY 2

• Control structures
• Numpy arrays and operations
• Pandas Data-frames and series

Week  7:

Topics: Python

DAY 1

• Data loading and writing
• Data manipulation with Pandas
• Basic plotting with matplotlib

DAY 2

• Statistical visualization with Seaborn
• Customizing visualizations
• Choosing the right visualization type

Week 8

• Portfolio building
• LinkedIn optimization
• Professional CV writing

Third Month

• Project
• Presentation
• Internship
• Follow-up