Data Analytics & Business Intelligence (DA & BI) Programme
📑 Course Structure & Modules 📑
Phase 1: Foundations of Data Analytics (Weeks 1–5)
• Excel for Analysts (formulas, pivot tables, macros, VBA)
• SQL for Data Analytics (queries, joins, aggregations, data validation)
• Introduction to Python for Data (NumPy, Pandas basics)
• Business Analysis Fundamentals (requirements gathering, reporting needs)
• AI Fundamentals for Data Analytics (AI-assisted analytics, ChatGPT for insights)
📑 Certifications: Excel Specialist, SQL Fundamentals, Python for Data 📑
Phase 2: Business Intelligence Tools (Weeks 6–10)
• Power BI Fundamentals (dashboards, data models, DAX basics)
• Tableau Essentials (visualisation, calculated fields, storytelling with data)
• Google Data Studio (free web-based BI tool for reporting)
• Data Visualisation Principles (storytelling, accessibility, UX for data dashboards)
• Capstone Mini-Project 1: Build and present a BI dashboard
📑 Certifications: Power BI Associate, Tableau Analyst 📑
Phase 3: Advanced Analytics & Governance (Weeks 11–16)
• Advanced SQL (CTEs, stored procedures, performance tuning)
• Advanced Python for Data (automation, APIs, cleaning large datasets)
• Statistical Analysis & Forecasting (regression, predictive models)
• Data Governance (GDPR, DAMA-DMBOK principles, compliance frameworks)
• Applied AI in BI (predictive dashboards, AI forecasting, anomaly detection)
• Capstone Mini-Project 2: Predictive analytics with BI tools
📑 Certifications: Advanced SQL, GDPR Awareness, DAMA-DMBOK Fundamentals 📑
Phase 4: Integration & Career Readiness (Weeks 17–22)
• Cloud Data Platforms (AWS QuickSight, Azure Synapse, Snowflake basics)
• BI in Industry Context (Healthcare, Finance, Insurance, Technology)
• Automation with BI Tools (Python + BI integrations, RPA dashboards)
• Freelancing & Consulting in BI (pricing, proposals, managing clients)
• Career Pathways: CV optimisation, LinkedIn branding, job interview prep
• Final Capstone Project: Full BI project simulating client delivery
🎓 Certifications: Cloud Data Foundations, BI Consultant Portfolio Prep Certifications Available 🎓
• Excel Specialist
• SQL Fundamentals → Advanced SQL
• Python for Data → Advanced Python for Data
• Power BI Associate
• Tableau Analyst
• Google Data Studio
• GDPR Awareness
• DAMA-DMBOK Fundamentals
• Cloud Data Foundations
💰 Career Pathways & Salaries (UK Market) :
Permanent Roles (Annual) 💰
1. Data Analyst → £35k–£50k
2. BI Analyst → £38k–£55k
3. Reporting Analyst → £32k–£45k
4. SQL Data Specialist → £38k–£52k
5. Junior Data Scientist → £40k–£55k
6. BI Consultant → £45k–£65k
7. Data Governance Analyst → £42k–£60k
8. Cloud Data Analyst → £45k–£65k
9. Forecasting Analyst → £38k–£52k
10. Financial/Healthcare BI Analyst → £40k–£58k
11. Marketing Analytics Specialist → £38k–£55k
12. Risk & Compliance Data Analyst → £42k–£60k
🤝 Contract Roles (Daily Rate) 🤝
1. Data Analyst → £280–£400/day
2. BI Analyst → £300–£450/day
3. Reporting Analyst → £220–£330/day
4. SQL Specialist → £280–£400/day
5. Junior Data Scientist → £350–£500/day
6. BI Consultant → £400–£600/day
7. Data Governance Analyst → £350–£500/day
8. Cloud Data Analyst → £400–£600/day
9. Forecasting Analyst → £300–£450/day
10. Marketing Analytics Specialist → £300–£450/day
11. Risk & Compliance Data Analyst → £350–£500/day
12. BI Project Lead → £450–£650/day
Instructor
