MySQL, MS Excel, MS PowerBI, Python.
Pandas, Matplotlib, Numpy, Seaborn.
Agile Methodology, Waterfall Methodology.
Analytic mindset, Leadership, Strategic Thinking.
flute, guitar.
Summary
Designed an interactive Power BI dashboard to analyze 82,000+ pizza sales, tracking core KPIs such as total revenue, order volume, and average order value to support data-driven decision-making.. Leveraged donut charts, funnel visuals, and bar graphs to visualize order distribution, sales conversion stages, and revenue by product category and size, enabling clear performance insights. Identified top 5 best-selling pizzas, contributing 28 per cent of total revenue, and flagged bottom performers with <1 per cent sales, informing menu refinement and promotional focus.
Summary
Analyzed 55,000+ customer transactions to uncover demographic purchase trends across states, age groups, and professions, highlighting key segments driving Diwali sales. Processed and cleaned 100,000+ data rows using Python (Pandas, NumPy), addressing missing values, outliers, and inconsistent categories to ensure high-quality, reliable analysis. Designed data-driven strategies to enhance the customer experience and boost revenue, including targeted marketing campaigns and personalized product recommendations based on buyer behavior.
Summary
Developed an interactive Power BI dashboard analyzing 5,000+ trades across multiple strategies, enabling clear visualization of total PnL, win/loss distribution, and hourly trade performance. Applied advanced data transformation techniques in Power Query (data type correction, locale handling, cumulative calculations) to ensure accurate and user-friendly reporting experience. Transformed and cleansed large datasets using Power Query (including date-time formatting, cumulative PnL calculations), ensuring high data integrity and insightful reporting.