Embedded Files
PROJECTS
Sales Performance Analysis
Sales Performance Analysis
In this project, I analyzed restaurant order and menu item data to uncover key insights that drive smarter business decisions. The goal was to understand sales trends, identify top-performing menu items, and detect under performing products through data analytics. Using tools like Power BI, and SQL, I cleaned, transformed, and visualized order-level data to highlight patterns such as: Peak sales periods and order volume trends; Customer purchasing behavior across menu categories; High and low performing menu items based on revenue and frequency. helping stakeholders to track metrics.
In this project, I analyzed restaurant order and menu item data to uncover key insights that drive smarter business decisions. The goal was to understand sales trends, identify top-performing menu items, and detect under performing products through data analytics. Using tools like Power BI, and SQL, I cleaned, transformed, and visualized order-level data to highlight patterns such as: Peak sales periods and order volume trends; Customer purchasing behavior across menu categories; High and low performing menu items based on revenue and frequency. helping stakeholders to track metrics.
Coca-cola US Sales Dashboard
Coca-cola US Sales Dashboard
This interactive Excel dashboard was designed to provide Coca-Cola USA with a comprehensive overview of retail sales performance across regions, beverage brands, and major retailers. The project aimed to transform raw sales data into actionable insights that drive better decision-making and performance tracking. This dashboard streamlined Coca-Cola’s performance reporting process, reduced manual data analysis time, and enabled management to quickly identify growth drivers across different regions and retailers
Product Performance and Profitability Analysis
Product Performance and Profitability Analysis
Product performance and profitability was analyzed in this report in order to determine performing and underperforming products and the categories such products are classified into. Management wanted to determine which products/categories have been driving revenue and sales since the last ten months in order to determine products that would be maintained and the ones to be discontinued. Power bi was utilized for data transformation and visualization.
Adventure Works Sales Performance Analysis
Adventure Works Sales Performance Analysis
This interractive dashboard was desiged to provide Adventure works with a comprehensive analysis on sales data, products, revenue and profit margins. Management at Adventure works a medium scale global manufacturing company wanted to identify growth patterns, top revenue generators and top performing territories for their online and retail sales on products. Power bi was used for data transformation and visualization and SQL was used for writing structured queries and for data extraction.
This interactive Excel Dashboard was designed to provide MACVITTIES a bicycle and accessories company with a broad sales data covering year 2011-2014 across several countries. The dashboard captures detailed KPIs ranging from Total orders, Revenue, Avg. order value, Profit margin etc. It also reflects distinct charts that captures yearly, monthly and quarterly sales, salespersons performance and revenue by territory. Overall, Macvitties as a bicycle and accessories company can track its revenue and sales performance as depicted from the dashboard based on the years covered. The company can also use this dashboard to project its future revenue and sales status by drawing insights based on key perfomance indicators revealed in the charts.
Expense Tracker & Financial Analysis using Python
Built an end-to-end Python solution to clean, analyze, and visualize expense data, generating insights on spending patterns, category distribution, and payment behavior.
Monthly Spending Trend
Monthly Spending Trend
Insight:
This visualization shows how expenses fluctuate over time, helping identify high-spending periods and trends.
What it reveals:
Spending is not consistent across months
Certain months show noticeable peaks, indicating irregular or seasonal expenses
Business Value:
Helps businesses plan budgets better and anticipate periods of high expenditure.
Spending by Category
Spending by Category
Insight:
This chart highlights which expense categories consume the largest share of total spending.
What it reveals:
A few categories dominate overall expenses
Essential costs (e.g., rent, food, transport) typically take the largest share
Business Value:
Enables decision-makers to focus on cost optimization in high-impact areas.
Expense Distribution (Pie Chart)
Expense Distribution (Pie Chart)
Insight:
Provides a proportional breakdown of total spending across categories.
What it reveals:
Clear visibility into how money is allocated
Easy identification of overspending areas
Business Value:
Useful for non-technical stakeholders to quickly understand spending structure and make budgeting decisions.
Payment Method Analysis
Payment Method Analysis
Insight:
Shows how expenses are distributed across different payment methods.
What it reveals:
Preference for certain payment channels (e.g., card vs cash)
Potential reliance on digital payments
Business Value:
Helps businesses track financial behavior, improve cash flow management, and monitor transaction methods.
Page updated
Google Sites
Report abuse