12-Week Program
Data Analyst Agenda
Your Pathway to Becoming a Data Analyst
A practical, hands-on journey from data fundamentals to building a professional portfolio, designed to get you job-ready in 12 weeks.
Week 1-2 – Foundations
Goal:Learn basics of Data Analytics, Business Intelligence, and set up your tools.
What You'll Learn
- Understand data types, databases, tables, rows, columns.
- Install tools: Excel / Google Sheets, SQL Workbench, Power BI / Tableau.
- Practice simple Excel data cleaning and pivot tables.
Week Deliverable
Excel-based data cleaning exercise and pivot table report.
Week 3-4 – SQL for Data Analysts
Goal:Master SQL to query databases and extract business insights.
What You'll Learn
- Learn SQL basics: SELECT, WHERE, ORDER BY, GROUP BY, JOIN.
- Practice querying sample datasets (e.g., sales, employees).
- Create simple reports directly from SQL queries.
Week Deliverable
Mini-project answering business questions with SQL.
Week 5-6 – Data Visualization & BI Tools
Goal:Build interactive dashboards with Power BI or Tableau.
What You'll Learn
- Learn to create charts, graphs, and KPI cards.
- Understand data modeling basics (relationships between tables).
- Connect SQL data to your BI tool.
Week Deliverable
A complete Sales Dashboard project.
Week 7-8 – Python for Analytics
Goal:Use Python for powerful data cleaning, transformation, and analysis.
What You'll Learn
- Basics of Python libraries: pandas, numpy, matplotlib, seaborn.
- Perform data wrangling and create visualizations with code.
- Analyze data from CSV files.
Week Deliverable
Analysis of a real-world dataset (e.g., movie ratings) in a Python notebook.
Week 9 – Statistics & Analytics Thinking
Goal:Apply statistical concepts to make data-driven decisions.
What You'll Learn
- Learn mean, median, standard deviation, and correlation.
- Understand hypothesis testing and A/B testing basics.
- Apply statistical methods to business data.
Week Deliverable
Case study analysis of customer churn or campaign performance.
Week 10 – Advanced Excel & Reporting
Goal:Master advanced Excel features for sophisticated reporting.
What You'll Learn
- Excel Power Query for data transformation.
- Advanced formulas like VLOOKUP/XLOOKUP.
- Automating reports with macros or pivot dashboards.
Week Deliverable
A reusable monthly business report template in Excel.
Week 11 – Business Problem-Solving
Goal:Translate real-world business requirements into analytical solutions.
What You'll Learn
- Work through practical case studies from various industries.
- Practice the workflow: business requirements → SQL → dashboard.
- Develop your problem-solving and critical thinking skills.
Week Deliverable
A capstone portfolio project: 'Customer Retention Analysis'.
Week 12 – Portfolio & Job Prep
Goal:Build a strong portfolio and prepare for the job market.
What You'll Learn
- Assemble your projects: SQL queries, dashboards, and Python notebooks.
- Polish your LinkedIn profile and GitHub to showcase your work.
- Practice common data analyst interview questions (technical & behavioral).
Week Deliverable
A complete professional portfolio and a job-ready profile.