Mayowa Agosu
Data Analytics |Excel | Turning Data into Actionable Insight
New to Contra
Mayowa is building their profile!
Transformed unorganized transactional sales data into an interactive, high-level executive dashboard to track revenue drivers, regional performance, shipping overhead, and marketing efficiency.
Key Achievements & Business Value Delivered
Centralized Core Metrics: Built interactive KPI cards tracking $2.55M total sales, 23.8k units sold, $50.1k discounts, and an average customer satisfaction rating of 4.4/5.
Regional & Channel Attribution: Identified North America and Europe as primary revenue drivers while analyzing sales across 6 marketing channels (Organic Search, Social Media, Direct, Paid Ads, Referral, Email).
Shipping & Overhead Analysis: Visualized logistics costs per product category, pinpointing higher shipping expenses in Jewelry ($53) and Home Decor ($47) to highlight cost-saving opportunities.
Dynamic Slicing: Integrated multi-parameter dynamic slicers (Year, Payment Method, Product Category, Marketing Channel) for instant data filtering and drill-down analysis.
Technical Workflow & Execution
Data Cleaning & Transformation (Excel / Spreadsheet Processing)
Analytical Modeling
Visual Dashboard Design
Tools Used: Microsoft Excel (Data Cleaning, Data Modeling, Dynamic Slicers, Dashboard Design, Pivot Table); Data Visualization (KPI Cards, Bar Charts, Line Graphs, Pie Charts).
Assets Included: Dynamic Excel Dashboard File, Cleaned Raw Data Set, Visual Project Documentation
0
3
Project Title:
Adidas Sales Performance & Profitability Analysis (Capstone Project)
Overview:
A comprehensive interactive Excel analytics dashboard developed as a Capstone Project to analyze Adidas' overall sales revenue, unit distribution, regional performance, and profit margins. This dashboard transforms raw retail data into executive-ready visuals that highlight top-performing channels, regional growth opportunities, and product category trends.
2
58
Project Title:
AA Store Retail Sales Performance Analysis Dashboard
Overview:
An interactive Excel sales performance dashboard designed to analyze revenue metrics, sales trends, and product category performance for retail operations. This dashboard transforms raw sales data into dynamic visual insights to help track business KPIs and guide revenue growth strategies.
1
66