Data Analytics & Automation Programme
π Course Structure & Modules π
Phase 1: Data Foundations (Weeks 1β4)
β’ Excel for Data Analysis (Pivot tables, formulas, VBA basics)
β’ SQL Fundamentals (queries, joins, aggregations)
β’ Data Concepts & Data Lifecycle
β’ AI Fundamentals for Data (how AI supports analytics)
π Certifications: Excel Specialist, SQL Fundamentals π
Phase 2: Business Intelligence & Visualisation (Weeks 5β8)
β’ Microsoft Power BI Fundamentals
β’ Tableau Essentials
β’ Google Data Studio
β’ Storytelling with Data (how to present insights)
β’ Capstone Mini-Project 1: Build a BI dashboard
π Certifications: Power BI Associate, Tableau Analyst π
Phase 3: Automation & Applied AI (Weeks 9β14)
β’ Robotic Process Automation (UiPath, Automation Anywhere basics)
β’ Workflow Automation (Zapier, MS Power Automate)
β’ Python for Data Automation (scripts, APIs, cleaning)
β’ Applied AI: Using ChatGPT & ML models for analysis
β’ Capstone Mini-Project 2: Automated reporting system
π Certifications: UiPath RPA Associate, Python for Data π
Phase 4: Integration & Professional Readiness (Weeks 15β18)
β’ Data Governance & GDPR compliance
β’ Cloud Data Tools (AWS/Azure for data pipelines basics)
β’ Freelancing in Data Analytics & Automation
β’ Career Roadmap (CV, LinkedIn, Interview Prep)
β’ Final Capstone Project: End-to-end Data & Automation project with
presentation
π Certifications: GDPR Awareness, Cloud Data Foundations Certifications Available π
β’ Excel Specialist
β’ SQL Fundamentals
β’ Power BI Associate
β’ Tableau Analyst
β’ UiPath RPA Associate
β’ Python for Data
β’ GDPR Awareness
β’ Cloud Data Foundations
π° Career Pathways & Salaries (UK Market) :
Permanent Roles (Annual) π°
Β 1. Data Analyst β Β£35kβΒ£50k
2. BI Analyst β Β£38kβΒ£55k
3. RPA Analyst β Β£40kβΒ£55k
4. SQL Data Specialist β Β£38kβΒ£50k
5. Reporting Analyst β Β£32kβΒ£45k
6. Junior Data Scientist β Β£40kβΒ£55k
7. Business Intelligence Consultant β Β£45kβΒ£65k
8. Automation Engineer β Β£42kβΒ£60k
9. Cloud Data Analyst β Β£45kβΒ£65k
10. Data Governance Analyst β Β£42kβΒ£58k
π€ Contract Roles (Daily Rate) π€
1. Data Analyst β Β£280βΒ£400/day
2. BI Analyst β Β£300βΒ£450/day
3. RPA Analyst β Β£325βΒ£475/day
4. SQL Specialist β Β£280βΒ£400/day
5. Reporting Analyst β Β£220βΒ£330/day
6. Junior Data Scientist β Β£350βΒ£500/day
7. BI Consultant β Β£400βΒ£550/day
8. Automation Engineer β Β£400βΒ£600/day
9. Cloud Data Analyst β Β£400βΒ£600/day
10. Data Governance Analyst β Β£350βΒ£500/day
Instructor
