MICROSOFT EXCEL
Data Cleaning
Pivot Chat
Financial Sales Dashboard
POWER BI
Superstore Analytics Dashboard
The Superstore Dashboard provides valuable insights into sales performance, profitability by product, and customer segment distribution. The analysis reveals a healthy growth in sales and profit, along with a slight improvement in return rates. By focusing on high-performing products, addressing underperforming ones, and aligning strategies with customer segment behavior, the superstore can enhance its profitability and market reach. Continuous monitoring and adapting to these insights will be key to long-term success.
The map displays the distribution of assigned personnel and strategic partners across the area called Cross River, Nigeria. Red dots are used to represent the assigned personnel, and they appear densely concentrated around the central and lower areas of the town, showing active presence in those locations. Green dots indicate strategic partners, but only a few of them are visible on the map. These green dots are scattered and far apart from one another, suggesting that strategic partnerships in this region are limited and not evenly distributed. While the personnel coverage is strong and widespread, the lack of more green dots points to a possible gap in partnership support. The map does not show any blue dots even though the legend includes SIB, which could mean that there is either no available data for this group or they were filtered out. Overall, the map helps to understand how field teams are positioned and reveals the need for expanding strategic partner involvement in more areas.
The heatmap analysis reveals strong regional variations in sales performance. Ibadan emerges as the highest-performing region with a total annual sales volume of ₦81,063,590, significantly outperforming all other regions. Kaduna, Lagos, Abuja, and Port Harcourt also show strong performance but remain lower than Ibadan. In contrast, regions such as Jos, Enugu, and Abeokuta report extremely low sales levels, indicating possible market weakness, distribution challenges, or operational issues. Monthly patterns show that Ibadan maintains consistently high sales throughout the year, reflected in its darker intensity across multiple months, suggesting strong demand and stable market engagement. Meanwhile, some regions display fluctuating performance, pointing to seasonal or regional sales dynamics. Overall, the heatmap allows for quick identification of top-performing locations, underperforming markets, and general sales trends across the year.
This Retail Sales Analytics Dashboard provides a comprehensive view of business performance across product lines, branches, customer types, and payment modes. The analysis highlights key insights such as total revenue, monthly sales trends, top-performing products, and customer purchasing behavior. Using Power BI, I transformed raw transactional data into an interactive dashboard that helps stakeholders quickly identify revenue drivers, compare branch performance, and understand customer patterns. The dashboard showcases my ability to clean and model data, create meaningful visualizations, and communicate insights clearly. It demonstrates practical skills in:
Data modeling & DAX calculations
Interactive data visualization
Trend and performance analysis
Customer segmentation
Business decision storytelling
This project reflects my ability to turn data into actionable insights that support decision-making and business growth.