portfolio

About Me

My name is Adeola Musa. I am an Excel, SQL, and PowerBI proficient Business Analyst and Strategist

Project 1- Goodride store Sales Analysis (Excel)

Goodride Sales Analysis

Introduction

This Excel projects provides a comprehensive overview of the purchase performance for an imaginary Bike store called Goodride, over a given period of time. The Bike sales dataset was organised and analyzed to answer crucial questions and gain insights to make strategc data driven decisions. This project includes organizing and analyzing purchase transactions, customer information, and product details of these datasets.

This report contains 3 pages:

You can interact with the project here

Disclaimer : All dataset or report do no represent any Company, Institution or Country but its justa dummy dataset used to demonstrate capabilities of Excel.

Problem Statement

Skills / Concept demonstrated

I used Power Query to clean and transform the data while using Power Pivot to analyse and create models. Other tools used includes; slicers, filters, DAX. Leveraging visualization tools, I created charts, graphs, and pivot tables to showcase key Performance metrics.

Filter Purchase
: _:

Analysis

:

This chart shows that the male customers who bought bikes have a higher average income ($60,124) than female customers who made similar purchases, with an average income of $55,774.

This chart shows that most bike customers (200) commute between o-1 mile daily with the lowest at more than 10miles.

This chart shows that North America has the highest no of customers (508), this implies that the highest income is enerated from this region, followed by Europe (300) and the pacific (196) respectively.

This chart shows that the Age bracket of the stores customers are middle aged (>31years), followed by the old (>55years) and the young (<31years) respectively.

Recommendation

Conclusion

For making accurate data-driven decisions, datasets from previous years should be analyzed and results compared with current data to identify trends, patterns, and changes over time.

Project 2- Choco-coffee-store-analysis (Excel)

Introduction

This Excel projects provides a comprehensive overview of the purchase performance for an imaginary Coffee store called Choco-Coffee, over a given period of time. The Coffee sales dataset was organised and analyzed to answer crucial questions and gain insights to make strategc data driven decisions. This project includes organizing and analyzing purchase transactions, customer information, and product details of these datasets.

This report contains 3 pages:

You can interact with the project here

Disclaimer : All dataset or report do no represent any Company, Institution or Country but its justa dummy dataset used to demonstrate capabilities of Excel.

Problem Statement

Skills / Concept demonstrated

I used Power Query to clean and transform the data while using Power Pivot to analyse and create models. Other tools used includes; slicers, filters, DAX. Leveraging visualization tools, I created charts, graphs, and pivot tables to showcase key Performance metrics.

Chart

filter ———————–| ————————– Chart

———-|———-

Analysis

This chart shows the revenue generated between Jan - June. The highest at $56,957 and $27,821, it also shows that there is steady rise from february until June.

This chart shows the hours of the day the store records the highest sales which is between 8hrs and 10hrs. The most sales is at the 10hrs, with 6957 transactions.

This chart shows highest selling product in the store. Coffee sells the highest (20187), followed by Tea (15277) and the Bakery (7617)

Project 3- Super Store Sales Report (PowerBI)

Introduction

This PowerBIprojects provides a comprehensive overview of the Sale performance for an imaginary departmental store called Super Store, over a given period of time. The store has 5 departments, Novelty, Supermarket, Gift, Corporate and Computer. The sales dataset was organised and analyzed to answer crucial questions and gain insights to make strategc data driven decisions to improve growth and performance. This project includes organizing and analyzing Invoice and customer information dataset.

You can interact with the project here

Disclaimer : All dataset or report do no represent any Company, Institution or Country but its justa dummy dataset used to demonstrate capabilities of PowerBI.

Problem Statement

Skills / Concept demonstrated

I used Power Query to clean and transform the data. Other tools used includes; slicers, filters, Quick measures. Leveraging visualization tools, I created charts, graphs, and pivot tables to showcase key Performance metrics.

Chart

Analysis

Sales by Departmental Category

This chart reports the total sales value for each departmental category and shows that the highest sales is generated from the Novelty shop ($38m)

Sales by month

This chart shows the sales value for each month, from January to December. I created two measures, Year to Year percentage (YtoY%) change and sales Year to Date (YtoD) calculation as shown in the table to make comparison with the previous year. The highest quantity sold is recorded in July (267k)

Sum of Sales by Province

This chart shows the stores sales performance by province. You can drill down into each state/province to identify the individual performance. from this analysis, Texas has the highest sales at #3,564,577

Recommendation