PRACTICAL KNOWLEDGE. REAL IMPACT.

Advanced Data Analytics and Visualization (ADAV)

Move from data handling to advanced analysis, database querying and visual storytelling using Excel, Tableau and MySQL.

Course at a Glance

Duration: 6 weeks
Status: On Demand
Delivery: Virtual / blended depending on cohort
Core Tools: Excel, Tableau & MySQL
Level: Beginner-friendly progression to advanced practical skills
Credential: Professional Development Certificate

GH₵2,000

Course Overview

This intensive programme develops advanced data-analysis and visualisation capability using three widely used tools: Microsoft Excel, Tableau and MySQL.

Participants learn to clean and model data, query relational databases, create interactive dashboards and communicate insights through effective data storytelling.

The course combines expert instruction, hands-on exercises, case studies and a capstone-style project for demanding data-driven roles.

Who Should Attend?

Business and data analysts
Marketing and commercial professionals
Project managers and researchers
Reporting and business-intelligence professionals
Professionals who need stronger data-driven decision skills
Learners moving from basic analytics into advanced tools

Learning Outcomes

Use advanced Excel functions for analysis and modelling.
Clean and transform larger datasets.
Build interactive dashboards in Excel and Tableau.
Use Tableau to explore patterns, trends and outliers.
Understand relational database concepts.

Advanced Capability

Write MySQL queries to extract and analyse data.
Apply visualisation best practices.
Create decision-focused data stories.
Work across data preparation, querying and reporting.
Complete practical end-to-end analytics projects.

Course Curriculum

Module 1 — Advanced Excel for Data Analytics

Advanced formulas, lookups, PivotTables, Power Query, Power Pivot, statistical analysis, automation and dashboard development.

Module 2 — Tableau for Data Analytics

Data connections, preparation, advanced visualisations, calculations, dashboards, parameters, forecasting and data storytelling.

Module 3 — MySQL for Data Analytics

Relational databases, SQL queries, joins, aggregation, views, performance concepts and analytical reporting.

Capstone — End-to-End Analytics Project

Combine data preparation, querying, analysis and visualisation in a practical business-focused project.

Requirements & Approach

Minimum of a Diploma in any field
A computer suitable for analytics software
Reliable internet access
Interest in business and data analysis
No advanced prior analytics experience required

Approach: Hands-on technical instruction, real datasets, dashboard exercises and project-based learning.

Frequently Asked Questions

Do I need to be an experienced analyst?

No. The course is structured to progress learners from foundations into advanced practical work.

Which tools are covered?

Microsoft Excel, Tableau and MySQL are the core tools.

Is there practical project work?

Yes. Exercises and projects are central to the programme.

When is the next intake?

Contact Admissions for the next confirmed cohort.

Go Beyond Basic Analytics.

Build the technical and visualisation skills required to analyse more complex data and communicate insights with confidence.

Tuition: GH₵2,000
Status: On Demand