Data Analytics & Business Intelligence

Clean, analyse and communicate business data with spreadsheets, SQL and Power BI while preserving a traceable quality-control process.

Course structure: 16 weeks of guided teaching, supervised practice, assessment and portfolio evidence.

What you will learn

• Data questions and spreadsheet foundations
• Cleaning and data-quality checks
• Formulas, lookups and business controls
• Pivot tables and spreadsheet dashboards
• Business metrics and survey interpretation
• SQL foundations and safe querying
• SQL aggregates and grouped reports
• Joins and relational reporting
• Power Query and repeatable preparation
• Power BI models and relationships
• Measures and trustworthy comparisons
• Dashboard usability and communication
• AI-assisted analysis and verification
• Business storytelling and portfolio preparation
• Capstone build and quality assurance
• Final practical, demonstration and progression

Practical projects

• P01 - Retail data-cleaning audit
• P02 - Expense-control workbook
• P03 - Sales pivot dashboard
• P04 - Customer survey insight report
• P05 - Inventory SQL report
• P06 - Training attendance relational report
• P07 - Refreshable monthly reporting pipeline
• P08 - Business intelligence dashboard
• P09 - AI analysis verification dossier
• P10 - Retail performance capstone

Learning standard: Learners retain working files, perform quality checks, correct mistakes, disclose permitted AI assistance and demonstrate the final work independently.