Clement Boateng

Management Consultant


Well versed in Data Analytics (Modelling, Cleaning, Transformation, Vizualization) and Project Management (Scheduling, Earned Value Management).
Technical Skills - SQL, Power BI, Dataflows, Tableau, Excel, Primavera P6, Microsoft Project
Certifications - Project Management Professional (PMP), Microsoft Power BI Data Analyst, AWS Cloud Practitioner


Portfolio Website

SQL Course

This course provides an in-depth introduction to Structured Query Language (SQL), the standard programming language for managing and manipulating relational databases.
Students will learn the fundamentals of SQL, including creating and modifying database structures and tables, performing data manipulation tasks, and writing SQL queries to retrieve, filter, and sort data from databases.

FIFA World Cup Finals

(Power BI Dashboard)

This interactive Power BI dashboard analyses FIFA World Cup Finals throughout the years.
It's interesting to know that Prior to winning in 2022, Argentina had been winless in 36 years after the great Maradona led them to their famous win in 1986.
With a hatrick in the 2022 final, Kylian Mbappe became the highest final scorer in history at the age of 23.
Brazil, who is the leading winner with 5, has been winless in 20 years after winning in 2002.
Netherlands on the other hand have the lowest win-loose variance after being to the final thrice and loosing all.
Check out more facts on the second page of the dasboard.

The steps involved included Data Extraction, Data Cleaning, Transformation, Modelling, and Data Vizualization.

Population Dashboard
(Power BI)

This Power BI Dashboard analyses the population of the world accross different countries and continents with their continental and world rankings calculated using DAX and measures
The steps involved included;
Data Extraction,
Data Cleaning & Transformation,
Data Vizualization.

Airbnb in Seatle
(Tableau)

This Tableau Dashboard analyses the the Airbnb market in Seatle, Washington to provide insights such as prices of different room in different Zip Codes and their market availabilities.
The steps involved included;
Data Extraction,
Data Cleaning, Transformation, Modelling
Data Vizualization.

Earned Value Management
(Excel/Google Sheet)

This project tracks performance of a home construction over a year using standard Earned Value Management. It uses the Budget Cost of Work Scheduled (Baseline Planned Value), Budget Cost of Work Performed (Earned Value), and Actual Costs to calculate the Earned Value Parameters such as Cost Performance Index (CPI), Schedule Performance Index (SPI), Estimate to Complete, Estimate at Completion (EAC), Cost Variance, Schedule Variance, and Variance at Completion.

Budget Template
(Excel/Google Sheet)

Budgeting template for setting up planned income and expenses versus actuals. This is meant to track detailed finances throughout the year. It also tracks debt and savings throughout the year to show progress.