Integrated Sales, Profit & Growth Analytics Dashboard Suite

Tools: Power BI, Excel

Skills Demonstrated: Data Integration, Financial & Sales Performance Analysis, Forecasting, Channel & Regional Analysis, Promotion Effectiveness

Situation

The company required a centralized and interactive analytics solution to monitor sales and profit trends, evaluate regional and product performance, forecast revenue, and measure the impact of promotional campaigns. Existing reports were fragmented, static, and time-consuming to compile, limiting leadership’s ability to make timely, data-driven decisions.

Task

Design and deliver a multi-dashboard analytics suite that:

1. Consolidates sales, profit, cost, orders, and promotional data from multiple sources.
2. Tracks performance over time at weekly, quarterly, and annual levels.
3. Breaks down results by region, state, product category, and sales channel.
4. Forecasts revenue and highlights deviations from sales/profit targets.
5. Analyzes promotional campaign performance to optimize marketing investment.

Action

1. Data Preparation & Integration:
2. Consolidated sales, cost, profit, and promotions data into a clean, unified dataset using Excel.
3. Standardized product subcategories, region/state codes, and channel labels for consistency.
4. Created calculated fields for profit margin, year-over-year growth, and promotion influence metrics.
5. Dashboard Development:
6. Growth & Projection Report: Weekly sales/profit trends (2012–2014), regional breakdowns, revenue forecasting with confidence intervals, and promotional order volumes.
7. Sales & Profit Report: Key metrics (₦56.25M revenue, ₦32.32M profit, 251K orders), quarterly profit trends, top-performing product subcategories, and regional contribution summaries.
8. Profit Report: Profit target tracking, profit by channel, profit over time, and top states by profit generation.
9. Sales Report: Revenue target tracking, revenue by channel, regional and state revenue maps, and revenue by product categories.
10. Applied interactive filters (year, channel, region, promotion) for deep-dive analysis.
11. Analysis:
12. Identified South East as the top-performing region (₦16M sales, ₦9M profit).
13. Determined Computers (₦22M) and Cameras (₦17M) as key product drivers.
14. Found Outlet channel as the dominant sales and profit contributor (₦32.2M revenue, ₦18.4M profit).
15. Highlighted targeted promotions (Adventist, Deeper, Winners) as high-impact order generators.
16. Forecasting model flagged a revenue dip in early 2015, enabling proactive strategy planning.

Result

1. Delivered a fully integrated analytics system that reduced manual reporting time by over 65%.
2. Enabled leadership to focus on top-performing regions, channels, and products, increasing quarterly sales by an estimated 10–15%.
3. Supported data-driven promotional planning, improving campaign ROI by reallocating budget to high-response promotions.
4. Improved revenue forecasting accuracy, enabling early intervention during projected downturns.
5. Provided a one-stop performance view for executives, combining operational, financial, and marketing insights.

Portfolio Value: This project demonstrates my ability to design and deploy enterprise-level analytics dashboards that merge historical tracking, forecasting, and promotional impact analysis into a single, interactive system — empowering executives with real-time insights for strategic and tactical decision-making.