AI-Enabled Data Analytics and BI Career Accelerator

Module 1: Business and Data Foundations

• Business analytics and analytical thinking
• Excel and advanced spreadsheet analysis
• Power Query and data preparation
• SQL fundamentals and advanced SQL
• Statistics and analytical reasoning

Module 2: BI Modelling and Reporting

• Business requirements and KPI development
• Data modelling and star schema
• Power BI and interactive reporting
• Power Query and data transformation
• DAX measures and calculations
• Dashboard design and data storytelling
• Publishing, security and refresh basics

Module 3: Python and Analytical Methods

• Python programming and pandas
• Data cleaning and preparation
• Exploratory data analysis and visualisation
• Experimentation and hypothesis testing
• Forecasting and scenario analysis
• Model performance and governance

Module 4: Domain Delivery and Analytics Operations

• Sales, marketing, finance and operations analytics
• Customer retention and business performance metrics
• Analytics quality and data validation
• Dashboard refresh and monitoring
• Governance, documentation and incident management

Module 5: GenAI Productivity and Capstone

• Prompt engineering and responsible GenAI usage
• AI-assisted Excel, SQL, DAX and Python workflows
• AI-assisted analytics and result validation
• Integrated business analytics capstone project
• Executive presentation and project defence
• Portfolio development and career readiness