Projects

This report presents a comprehensive analysis of retail sales performance using data collected from a retail store between 2022 and 2023. The dataset contains 2,000 transactional records from 155 unique customers, covering three major product categories: Clothing, Electronics, and Beauty. The analysis explores the sales distribution across time, product categories, and customers to uncover patterns, trends, and opportunities for business growth. Through data understanding, exploratory data analysis (EDA), and visualization, this report aims to identify key factors influencing retail performance, customer behavior, and sales dynamics. 

Dashboard Created with Microsoft Power BI

This is a comprehensive analysis of the Social Media Campaign Performance Dashboard.

The current social media strategy is successfully driving high visibility (213M+ Impressions) but is failing significantly in financial efficiency (-98.2% ROI). While the campaigns are getting in front of people, they are costing far more to run than the direct revenue they are generating (based on the current attribution model).

However, hidden within this aggregate failure are specific pockets of high performance specifically Campaign 916 and the 30–34 Age Group which offer a clear path to turning this performance around.

Dashboard Created with Microsoft Power BI

The Superstore dataset was analyzed to uncover sales patterns, identify best-performing products, evaluate profitability, and provide insights that can guide business strategy. The analysis combined Excel (for data cleaning) and Power BI (for further transformation and visualization) to present a comprehensive view of business performance across products, categories, and regions.

The objective of this project was to address key stakeholder questions, identify trends, and provide actionable recommendations to enhance revenue and profitability.

Dashboard Created with Microsoft Power BI