Phone:+91 484-4063599 Seaport –
[email protected] AirportRoad,
www.camerinfolks.com Kakkanad
,Kochi
CAMERINFOLKSPVTLTD
DATA ANALYTICS SYLLABUS
4-Month Data Analytics Course Syllabus (With Project Work)
Ideal For: Aspiring Data Analysts, Business Analysts, and professionals transitioning into
analytics.
Tools Covered: Excel, Python, SQL, Power BI, Tableau
📅 Month 1: Data Handling with Excel + Statistical Foundations
📘 Excel for Data Analytics (Weeks 1–2)
Basic Excel Interface, Data Types, Formatting
Functions:
o Text: CONCATENATE, LEFT, RIGHT, MID
o Logical: IF, AND, OR, NOT
o Lookup: VLOOKUP, HLOOKUP, INDEX, MATCH
Aggregate Functions:
o SUM, AVERAGE, COUNT, MAX, MIN
o COUNTA, COUNTIF, SUMIF, AVERAGEIF
Formulas:
o Conditional Formatting, Data Validation
o Named Ranges, Charts, Pivot Tables
o Excel Dashboards (Basic)
📘 Basic Statistics (Weeks 3–4)
Descriptive Stats: Mean, Median, Mode, Variance, Std. Dev
Trend Analysis: Moving Averages, Trendlines
Probability Basics:
o Classical & Empirical Probability
o Permutations & Combinations
o Distributions: Normal, Binomial
🔧 Mini Project #1: Build an Excel Dashboard to analyze monthly sales performance from a retail
dataset.
📅 Month 2: SQL for Data Management + Python Basics
📘 Advanced SQL (Weeks 5–6)
Joins: INNER, LEFT, RIGHT, FULL OUTER, SELF
Subqueries & Nested SELECT
Set Operators: UNION, INTERSECT, EXCEPT
Triggers: Concept, Creation, Use Cases
Views, Stored Procedures
Practice using MySQL/PostgreSQL with sample datasets
📘 Python Programming (Core) (Weeks 7–8)
Variables, Data Types, Operators
Control Flow: if, for, while, break, continue
Functions, Lambda Functions
Lists, Tuples, Dictionaries, Sets
File Operations
Exception Handling
Intro to OOP: Classes, Objects
🔧 Mini Project #2: Design an SQL database for a student management system and write advanced
queries to generate performance reports.
📅 Month 3: Python for Data Analysis + Intro to BI Tools
📘 Data Analysis with Python (Weeks 9–10)
NumPy:
o Arrays, Indexing, Slicing, Broadcasting
o Mathematical & Statistical Operations
Pandas:
o Series & DataFrames
o Data Cleaning: Handling Nulls, Duplicates
o Data Transformation, Merging, Grouping
o Basic Data Visualization: Matplotlib, Seaborn
📘 Power BI Essentials (Weeks 11–12)
Connecting to Excel, CSV, SQL Server
Data Modeling, Data Transformation
Visuals: Bar, Line, Pie, Matrix, Map
Filters, Slicers, Drill-throughs
DAX (Basic Functions)
Building & Publishing Dashboards
🔧 Mini Project #3: Analyze a product sales dataset using Python (pandas) and visualize insights
using Power BI.
📅 Month 4: Tableau + Advanced Analytics + Final Project
📘 Tableau Fundamentals (Weeks 13–14)
Connecting to Data (Excel, CSV, SQL)
Visuals: Bar, Line, Heatmap, Treemap, Map
Filters, Parameters, Calculated Fields
Dashboards, Story Points
Forecasting, Clustering
Exporting and Publishing to Tableau Public
📘 Advanced Analytics Overview (Weeks 15–16)
Time Series Forecasting (Moving Average, Exponential Smoothing)
Outlier Detection
Introduction to Machine Learning Concepts
o Linear Regression (scikit-learn)
o K-Means Clustering
Power BI vs Tableau: When to use what
✅Final Capstone Project (2 weeks):
"Customer Analytics Dashboard"
Data Source: E-commerce/Banking dataset
Tools: Use SQL to extract, Python (pandas) to clean, Power BI/Tableau to visualize
Objective: Analyze customer behavior, purchase trends, churn indicators, and design an
interactive dashboard
🔧 Learning Outcomes
Analyze and interpret data using Excel, SQL, and Python
Clean, manipulate, and visualize data effectively
Create business dashboards in Power BI & Tableau
Apply statistical thinking to real-world business data
Build data-driven decision-making models
