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
