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
