Sales and Profit Growth Dashboard in Excel

This project showcases an interactive Excel dashboard built to analyze business performance over time. Using DAX measures & clean visualization techniques, I transformed raw data into actionable insights, tracking year-over-year sales, profit, customer growth & more. Download file as Excel& interact

Basic to Advance Excel Mentorship

I created a Google form, shared it across all platforms for individuals who seek to improve their Excel skill. 27 persons registered through the form and extra 5 joined without filling the form. I taught Excel from Basic introduction to Advanced Macros, VBA, Data Modelling with Power Pivot and more.

Bricks & Wire Report

This project equips IT professionals and tech startups with a robust approach to measure and enhance content impact, helping them make strategic, data-informed decisions in their digital outreach efforts. focused on analyzing article engagement data to determine the best-performing contents.

Inventory Tracking Model

With the rising need to solve challenges of recording and documentation for small and medium business, I built an Excel Model that can track and manage inventories, detect theft, and ensure transparency and profitability in businesses. The model contains several hidden formulas and amazing features.

Maven Cafe Customer Analysis

Maven Cafe is a coffee shop with 17000 customers that needs to improve its customers services and marketing strategies. As a Marketing Analyst at Maven Cafe, I identify key customer segments and develop a data-driven strategy for future promotional messaging & targeting.

Health Analysis Project - SQL and Power BI

This is a health analysis project OCD (obsessive-compulsion disorder). SQL and Power BI was used to clean, analyze and visualize the data. Several health related questions that was answered include: age group of patients with OCD, gender that has OCD more, compulsion and obsessive types and more.

Investigative Analytics SQL Project

This is a forensic project that brought light to a murder investigation. It showed a step by step process of how the culprits were investigated and confirmed the murderers. There are six tables were in the database and one created in the course of the investigation. Several soft skills were tested.

IT Professional Survey Project For 2022

This project survey was carried out by tech professionals to confirm various aspect of their career. I answered ten question that includes four cards and six charts. Before solving these problems, I made sure to observe the data, transformed it using power query before visualization with Power BI.

YouTube User Base

YouTube is one of the big social media where people create and showcase their content. This project has made open the best content creators in the recent times. It focuses on most subscribed category, most liked channel, viewed channel, top user by countries, and more. Power BI was used.

WalMart Store Sales

This is an analysis of a business that kicked off operation in 2011 with branches in different states. It brought to light the states with most sales, profit and their growth rate from inspection year. It looked into category of stock that sells more and profit associated to it. Power BI was used.

Rite-Choice & Co Sales Dashboard

A project done with Power BI tool, after sorting, and cleaning the data. This is a sales dashboard that was carefully created with maximum insight. It's aim was to expose the customers with highest purchasing power, the goods that sales more, the sales agent, and location that impresses the most ...

Community Healthcare Project For 2020

A healthcare project to confirm sicknesses that has befallen the young generation between ages 18 -35. It was evident that this group fall sick of hypertension than any other illness and more people take penicillin. The dataset was observed, cleaned and analytic tools were used for visualizations.

HR Analysis Dashboard

This Employees dataset was cleaned and analyzed to ascertain what relationship does educational level has with hourly rate and average year spent in the organization, which department earns more, the relationship between travelers and work satisfaction, work life balance as relate to overtime & more

World Educational Project For 2023

This project seek to unveil countries that are faced with poor educational background, to what extent has it affected the kids in their basic proficiencies, and which gender has suffered more from the world drop out crises in education. 6 major questions were answered and insights provided.

Rigonal Bike Sales Dashboard For 2021

This dataset was carefully analyzed with Excel tool. It was gotten from Kaggle.com and cleaned (trim, blanks, duplicate, IF, proper case and standard table). The IF formula was used to group the data. Valuable insights was extracted by answering 8 business questions that will aid proper decisions.

Queens Supermarket Sales Dashboard For 2023

This sales dashboard was curated to showcase my advance excel skills by simplifying rough meaningless data to a dashboard full of useful business information. The project answered 7 critical business problem and proffer useful information for greater sales and better decision making.

Population of Electric Vehicles

It is said that Electric Vehicles will take over the world in centuries to come. This project on vehicles with focus on how electric and hybrid vehicles have grown in demand over the years. The data was gotten from kaggle.com in a CSV file, then transformed, cleaned and visualized using Power BI.

Airline Travelers Review Project

This project seek to reveal the best airline according to customers review. It also unveiled the months that people travels more, reasons why people travel more, the class of travelers, frequently flied airline and more. Power Query and Power BI was used to transform and visualize the data.

Whatsapp Group Data

A Whatsapp data that was extracted, cleaned and visualized using Power BI to ascertain the number of persons who have been active and responsive in the group. This project queried thorough data cleaning technic.

Common SQL Statement -1

The WHERE statement was used to filter, TO_CHAR to change data format, ORDER BY to sort and rearrange column from ascending or descending, IN statement was used to single out 2 or more items in a column, the CASE was used to group age and can be used to categorize columns, SUM CASE was used to pivot

Sales Dashboard for Independent Restaurants in USA

The dataset was gotten from Kaggle, cleaned and placed in a standard excel table. I went ahead to answered several business questions as shown in the attached link and imagine. The project arms to ascertain what criteria has kept the best restaurants in the US going and how to improve them.

SQL Table Creation

Table was manually created and values inserted with the practice of understanding the different data types and when they should be used. The DATE, BIGINT, TEXT, INTEGER, VARCHAR, FLOAT, and many more. These separate data types come in different forms such as alphabet, alphanumeric, decimals and more

Global Superstore Mart

Global Superstore is a global online retailer based in New York, boasting a broad product catalogue and aiming to be a one-stop-shop for its customers. Below is a link containing a comprehensive report: https://drive.google.com/drive/folders/1F0uUmFPmoVr2S0jyuoeFmNcdAN6hMUq7?usp=sharing

HallMark-Green Sales Project For 2023

My first sales dashboard was successfully created with the use Excel and pivot table, and it answered the following business questions: 1. Sales trend report. 2. Who are the top 10 customers? 3. Find the sales by rep. 4. Sales by Region. 5. Transaction by Amount. 6. Sales by Product Category.