Data Analytics Mastery Programme

Duration: 8 Weeks Training + 1-Month Placement + Career Support

Week 1: Introduction to Data Analytics & Excel Mastery

• What is Data Analytics? The role of a Data Analyst

• Data types, workflows, and the data analytics lifecycle

• Excel for data analysis: formulas, pivot tables, lookups, data cleaning

• Data validation, conditional formatting, and charting essentials

• Hands-on: Clean and analyse raw datasets in Excel

Week 2: Data Exploration & Visualization with Power BI

• Introduction to data visualisation principles

• Power BI Desktop fundamentals: connecting, transforming, and modelling data

• Building dashboards: charts, slicers, maps, filters

• Creating interactive, business-ready reports

• Hands-on: Create and publish your first Power BI dashboard

Week 3: SQL for Data Analysis

• Introduction to databases and SQL syntax

• Writing basic to intermediate queries: SELECT, WHERE, JOIN, GROUP BY, ORDER BY

• Filtering, aggregating, and manipulating data

• Real-world business use cases for SQL

• Hands-on: Write SQL queries to extract insights from sample datasets

Week 4: Statistics & Data-Driven Decision Making

• Understanding descriptive and inferential statistics

• Measures of central tendency and variability

• Data distributions and correlation

• Making data-driven business decisions using statistical thinking

• Hands-on: Use statistical techniques to analyse trends and patterns

Week 5: Python for Data Analysis (Optional/Introductory)

• Introduction to Python and Jupyter Notebooks

• Data analysis with Pandas and NumPy

• Data visualisation using Matplotlib and Seaborn

• Hands-on: Load, clean, and visualise data with Python

Week 6: Real-World Data Projects & Business Scenarios

• Applying tools (Excel, SQL, Power BI, Python) to real business problems

• End-to-end project work: data collection, cleaning, analysis, and reporting

• Group collaboration and presentation of findings

• Hands-on: Deliver a project addressing a real-world business challenge

Week 7: Career Development & Portfolio Building

• Crafting a standout Data Analyst CV and LinkedIn profile

• Building a personal project portfolio

• How to talk about your work in interviews

• Mock interviews and recruiter tips

• Hands-on: Compile and polish 3+ portfolio-ready projects

Week 8: Final Assessment & Industry Preparation

• Final individual capstone project: solve a business case from start to finish

• Present your insights to a review panel

• Feedback and performance review

• Preparation for placement: expectations, etiquette, deliverables

Post-Course: One-Month Placement & Ongoing Career Support

• Real-world placement to apply your skills in a business environment

• Ongoing mentorship, check-ins, and support

• Job referrals and interview opportunities

• Lifetime access to course resources and alumni community

What You’ll Gain

• Mastery of Excel, Power BI, SQL, and Python (optional)

• A portfolio of real-world projects

• Industry placement experience

• Career tools: CV, LinkedIn, interview scripts

• Certificate of Completion and job market readiness