Data Analytics
Duration : 60 Days
The Data Analytics course equips you with the skills to transform raw data into actionable insights. You will learn how to collect, clean, and visualize data, as well as apply statistical and analytical techniques to identify patterns, trends, and business opportunities. The course covers popular tools and platforms for data analytics, enabling you to work with real datasets and create impactful reports. Whether you aim to improve business performance, enhance decision-making, or start a career in analytics, this program provides the knowledge and hands-on experience to succeed in the data-driven world.
Course Outline
Introduction to Data Analytics
Topics
Types of Analytics: Descriptive, Diagnostic, Predictive, Prescriptive
Data Life Cycle
Roles of a Data Analyst
Introduction to Excel & Google Sheets
Basic Functions: SUM, AVERAGE, IF, COUNTIF
Data Cleaning: Remove Duplicates, Find & Replace, Filtering
Task: Clean and summarize a sales dataset in Excel
Excel for Data Analysis
Topics
Pivot Tables and Pivot Charts
VLOOKUP, HLOOKUP, INDEX & MATCH
Conditional Formatting
Creating Dashboards in Excel
Data Validation & Drop-down Lists
Intro to Charts: Bar, Line, Pie, Combo
Task: Build a sales dashboard with dynamic filters
SQL for Data Analysts (Part 1)
Topics
What is SQL?
SQL Tools Setup (MySQL, SQLite, or PostgreSQL)
Basic Queries: SELECT, WHERE, ORDER BY
Working with NULLs
Sorting & Limiting Results
Filtering with AND, OR, IN, NOT
Task: Query a mock customer database using filters
SQL for Data Analysts (Part 2)
Topics
Aggregations: COUNT, SUM, AVG, MAX, MIN
GROUP BY and HAVING
JOINs (INNER, LEFT, RIGHT)
Subqueries and Aliases
Creating Views
Real-World SQL Practice Scenarios
Task: Analyze customer purchase behavior using JOINs
Data Visualization with Power BI / Tableau
Topics
What is Data Visualization?
Connecting to Excel/SQL in Power BI or Tableau
Slicers, Filters, Drilldowns
Building Interactive Dashboards
Connecting to Excel/SQL in Power BI or Tableau
Publishing Reports & Storytelling with Data
Task: Build an interactive dashboard from a sales dataset
Python for Data Analysis (Beginner Level)
Topics
Setting Up Python + Jupyter Notebook
Working with Pandas: DataFrames, Series
Python Basics (Variables, Lists, Loops, Functions)
Data Cleaning with Pandas
Reading CSV & Excel Files
Intro to Data Visualization with Matplotlib
Task: Load and clean a dataset using Pandas
Final Project Real-World Case Study
Topics
Sales Analytics
Survey Data Insights
Customer Retention Analysis
Website Traffic & Conversion Dashboard
Excel/SQL Data Cleaning
Dashboard in Power BI or Tableau
Summary Insights & Recommendations
Career Preparation & Certification
Topics
Portfolio Building (Google Drive, GitHub, Tableau Public)
Resume for Data Analyst Role
LinkedIn Optimization
Freelancing & Remote Job Platforms for Data Analysts
Course Outcomes
Topics
Resume + LinkedIn Profile Guidance
GitHub or Google Drive Portfolio Folder
Excel/Power BI/SQL/Python Practice Files
Final Project (Presentation + Dashboard + SQL Queries)
Certificate of Completion
| Introduction to Data Analytics | |
| Topics | |
|---|---|
| Types of Analytics: Descriptive, Diagnostic, Predictive, Prescriptive | |
| Data Life Cycle | |
| Roles of a Data Analyst | |
| Introduction to Excel & Google Sheets | |
| Basic Functions: SUM, AVERAGE, IF, COUNTIF | |
| Data Cleaning: Remove Duplicates, Find & Replace, Filtering | |
| Task: Clean and summarize a sales dataset in Excel | |
| Excel for Data Analysis | |
| Topics | |
|---|---|
| Pivot Tables and Pivot Charts | |
| VLOOKUP, HLOOKUP, INDEX & MATCH | |
| Conditional Formatting | |
| Creating Dashboards in Excel | |
| Data Validation & Drop-down Lists | |
| Intro to Charts: Bar, Line, Pie, Combo | |
| Task: Build a sales dashboard with dynamic filters | |
| SQL for Data Analysts (Part 1) | |
| Topics | |
|---|---|
| What is SQL? | |
| SQL Tools Setup (MySQL, SQLite, or PostgreSQL) | |
| Basic Queries: SELECT, WHERE, ORDER BY | |
| Working with NULLs | |
| Sorting & Limiting Results | |
| Filtering with AND, OR, IN, NOT | |
| Task: Query a mock customer database using filters | |
| SQL for Data Analysts (Part 2) | |
| Topics | |
|---|---|
| Aggregations: COUNT, SUM, AVG, MAX, MIN | |
| GROUP BY and HAVING | |
| JOINs (INNER, LEFT, RIGHT) | |
| Subqueries and Aliases | |
| Creating Views | |
| Real-World SQL Practice Scenarios | |
| Task: Analyze customer purchase behavior using JOINs | |
| Data Visualization with Power BI / Tableau | |
| Topics | |
|---|---|
| What is Data Visualization? | |
| Connecting to Excel/SQL in Power BI or Tableau | |
| Slicers, Filters, Drilldowns | |
| Building Interactive Dashboards | |
| Connecting to Excel/SQL in Power BI or Tableau | |
| Publishing Reports & Storytelling with Data | |
| Task: Build an interactive dashboard from a sales dataset | |
| Python for Data Analysis (Beginner Level) | |
| Topics | |
|---|---|
| Setting Up Python + Jupyter Notebook | |
| Working with Pandas: DataFrames, Series | |
| Python Basics (Variables, Lists, Loops, Functions) | |
| Data Cleaning with Pandas | |
| Reading CSV & Excel Files | |
| Intro to Data Visualization with Matplotlib | |
| Task: Load and clean a dataset using Pandas | |
| Final Project Real-World Case Study | |
| Topics | |
|---|---|
| Sales Analytics | |
| Survey Data Insights | |
| Customer Retention Analysis | |
| Website Traffic & Conversion Dashboard | |
| Excel/SQL Data Cleaning | |
| Dashboard in Power BI or Tableau | |
| Summary Insights & Recommendations | |
| Career Preparation & Certification | |
| Topics | |
|---|---|
| Portfolio Building (Google Drive, GitHub, Tableau Public) | |
| Resume for Data Analyst Role | |
| LinkedIn Optimization | |
| Freelancing & Remote Job Platforms for Data Analysts | |
| Course Outcomes | |
| Topics | |
|---|---|
| Resume + LinkedIn Profile Guidance | |
| GitHub or Google Drive Portfolio Folder | |
| Excel/Power BI/SQL/Python Practice Files | |
| Final Project (Presentation + Dashboard + SQL Queries) | |
| Certificate of Completion | |