Skip to content

Anointed-DA/Sql-data-analysis-

Repository files navigation

PORA Academy Cohort 5 - Data Analytics & AI Bootcamp

A comprehensive 9-month program that takes students from Excel basics to advanced data analytics and AI specializations, with hands-on projects and industry-relevant skills development.

🎯 Program Overview

Duration: 9 months | Format: Live instruction + hands-on practice
Schedule: Wednesdays & Thursdays, 2 hours each | Start: August 13, 2025 | Completion: May 1, 2026
Holidays: Nigerian public holidays observed | Progression: Excel → SQL & Python → Visualization → Specialization

📚 Program Structure

Phase 1: Foundations (3 months - COMPLETED)

📁 curriculum/01-phase-1-foundations/

  • Excel mastery and data analysis fundamentals
  • Pivot tables, advanced functions, and interactive dashboards
  • Requirement: ≥80% on placement test to advance

Phase 2: Core Skills (6 months)

📁 curriculum/02-phase-2-core-skills/ | Timeline: Aug 2025 - Mar 2026

Phase 3: Specializations (3 months)

📁 curriculum/03-phase-3-specializations/ | Timeline: Jan - May 2026 Choose your career track:

  • 🔧 No-Code Automation - Zapier, Make.com, Airtable, Power BI
  • 🏗️ Data Engineering - Airflow, AWS/GCP, dbt, Snowflake
  • 📊 Advanced Analytics - AI-driven analytics, advanced modeling
  • 🧬 ML Drug Discovery - Pharmaceutical data analysis and prediction

🧭 Navigation Guide

👨‍🎓 FOR STUDENTS

Need Go To
This Week's Classes 📅 Week 1
Setup Your Tools 🛠️ Tools Setup
Download Datasets 📊 Datasets
Study Guides & Help 📚 Student Resources
All Course Content 📖 Full Curriculum

👨‍🏫 FOR TUTORS

Need Go To
This Week's Lesson Plans 📋 Week 1 Materials
Grading & Assessment 📊 Admin
Content Templates 📝 Templates
Complete Syllabus 📚 Detailed Curriculum
Course Schedule 📅 24-Week Breakdown

💼 Industry-Ready Projects

Phase 2 Projects (Month 7)

Choose from 5 real-world scenarios:

Phase 3 Projects (Month 9)

Track-specific capstone projects demonstrating specialization mastery

🛠️ Technical Environment

Phase Tools & Platforms
Phase 1 Microsoft Excel, CSV datasets
Phase 2 VS Code (SQL), Google Colab (Python), Looker Studio, Streamlit
Phase 3 Track-specific professional tools

📖 Documentation

Document Purpose
📚 Full Documentation Complete program information
🤖 CLAUDE.md Repository structure guide
📋 Syllabus Detailed course requirements
🎯 Assessment Guide Evaluation criteria

🔄 Learning Pathway

graph LR
    A[Excel Mastery] --> B[SQL & Python Sync]
    B --> C[Visualization Tools]
    C --> D[Phase 2 Project]
    D --> E[Specialization Track]
    E --> F[Final Capstone]
Loading

🌟 Key Program Features

  • 🔄 Synchronized Learning: SQL and Python taught in parallel with same datasets
  • 🤖 AI Integration: Structured curriculum for AI-assisted problem solving
  • 💼 Industry Focus: Real business scenarios and professional-grade projects
  • 🎯 Career Tracks: Four specialized paths for different career goals
  • 📱 Modern Tools: Current industry-standard platforms and technologies

📞 Support & Resources


Ready to transform your data analysis skills? Use the navigation guide above to get started and join the next generation of data professionals.

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Contributors 2

  •  
  •