Kwe4 Business Academy
Data Analysis Curriculum
Duration: 3 Months (2 Classes per week, 4-hour sessions)
Total Classes: 24
Structure:
● Month 1: Fundamentals of Data Analysis
● Month 2: Advanced Data Analytics & Midterm Test
● Month 3: Machine Learning, Business Intelligence & Final Exam
Month 1: Data Foundations & Exploratory Data Analysis
(EDA)
Week 1: Introduction to Data & Tools
Class 1:
● Overview of Data Analysis, Data Science, and AI
● Real-world Applications of Data Analysis (Finance, Healthcare, Marketing, Operations)
● Understanding Data: Structured vs. Unstructured, Quantitative vs. Qualitative
● The Data Analysis Process: Collection → Cleaning → Analysis → Visualization →
Decision Making
Class 2:
● Introduction to Excel/Google Sheets for Data Handling
● Essential Excel Functions (SUMIF, INDEX-MATCH, LOOKUP, PIVOT TABLES)
● Data Formatting, Conditional Formatting, Sorting & Filtering
● Hands-on Exercise: Analyzing a Raw Data File
Week 2: SQL for Data Analysis
Class 3:
● Introduction to Databases & SQL
● Relational Databases (MySQL, PostgreSQL, SQLite)
● Writing SQL Queries: SELECT, WHERE, ORDER BY, GROUP BY
● Hands-on SQL Query Writing
Class 4:
● Joins and Subqueries (INNER, LEFT, RIGHT, FULL OUTER)
● Window Functions & Aggregations (ROW_NUMBER, RANK, LEAD, LAG)
● Hands-on SQL Case Study
Week 3: Python for Data Analysis
Class 5:
● Introduction to Python & Jupyter Notebooks
● Python Basics: Variables, Data Types, Loops, Functions
● Libraries for Data Analysis: Pandas, NumPy, Matplotlib
Class 6:
● Data Cleaning with Pandas: Handling Missing Data, Outliers
● Data Wrangling: Reshaping, Merging, Aggregating Data
● Hands-on: Cleaning a Large Dataset with Pandas
Week 4: Exploratory Data Analysis (EDA) & Visualization
Class 7:
● Introduction to Descriptive Statistics
● Measures of Central Tendency (Mean, Median, Mode)
● Measures of Dispersion (Variance, Standard Deviation, IQR)
● Identifying Outliers with Boxplots
Class 8:
● Data Visualization with Matplotlib & Seaborn
● Histograms, Scatterplots, Heatmaps
● Hands-on EDA: Analyzing a Business Dataset
Month 2: Advanced Analytics, Statistical Methods &
Midterm
Week 5: Statistical Analysis & Probability
Class 9:
● Probability Distributions (Normal, Binomial, Poisson)
● Central Limit Theorem & Sampling Techniques
● Hands-on: Probability Estimation
Class 10:
● Hypothesis Testing (T-Tests, ANOVA, Chi-Square)
● Confidence Intervals & P-Values
● Hands-on: Running Hypothesis Tests on Real Data
Week 6: Midterm Test
Class 11:
● Comprehensive Review of Weeks 1-5
● Mock Midterm Test Questions & Problem-Solving Session
Class 12:
● Midterm Test
● Midterm Debrief & Discussion
Week 7: Regression Analysis & Predictive Modeling
Class 13:
● Introduction to Regression Models (Linear, Logistic)
● Building & Evaluating Regression Models in Python
● Hands-on: Predicting Sales using Regression
Class 14:
● Feature Engineering & Model Optimization
● Handling Multicollinearity & Overfitting
● Hands-on: Building a Predictive Model for Customer Churn
Week 8: Time Series Analysis & Forecasting
Class 15:
● Understanding Time Series Data
● Moving Averages & Exponential Smoothing
● Hands-on: Forecasting Stock Prices
Class 16:
● Advanced Time Series: ARIMA & Seasonal Trends
● Model Evaluation Metrics for Forecasting
● Hands-on: Building a Forecasting Model for Business Sales
Month 3: Business Intelligence, Machine Learning & Final
Exam
Week 9: Business Intelligence (BI) & Reporting
Class 17:
● Introduction to BI Tools (Power BI, Tableau)
● Creating Interactive Dashboards
● Hands-on: Designing a BI Dashboard for an E-commerce Company
Class 18:
● Automating Reports using Python & SQL
● KPI & Performance Metrics for Business Decision Making
● Hands-on: Generating Automated Reports
Week 10: Big Data & Cloud Analytics
Class 19:
● Introduction to Big Data (Hadoop, Spark, Google BigQuery)
● ETL Process & Data Pipelines
● Hands-on: Querying a Cloud-based Dataset
Class 20:
● Cloud-based Analytics with AWS & Azure
● Data Security & Compliance (GDPR, CCPA)
● Hands-on: Working with a Cloud Data Platform
Week 11: Final Exam Preparation
Class 21:
● Recap of Key Topics from the Course
● Practice Questions & Mock Exam
Class 22:
● Data Science & Analytics Career Paths
● Building a Data Portfolio (GitHub, Kaggle)
● Resume & Interview Preparation for Data Analyst Roles
Week 12: Final Examination & Wrap-Up
Class 23:
● Final Examination (Comprehensive Test)
Class 24:
● Course Review & Feedback
● Certification & Next Steps
