Rittick Mishra

Tools Used: Microsoft Excel (Pivot Tables, Charts, Slicers, Data Cleaning) • Built an interactive sales dashboard in Excel to analyze ₹53M+ food delivery data. • Cleaned and organized raw data using Excel functions and structured tables. • Created KPIs such as total sales, average rating (4.34), and total orders. • Used Pivot Tables and charts to track monthly and daily sales trends. • Identified higher sales on weekends and peak-performing months. • Analyzed category-wise (veg vs non-veg) and state-wise sales performance. • Added slicers for category, month, and restaurant to make the dashboard easy to use.

Tools Used: Microsoft Excel (Pivot Tables, Charts, Slicers, Data Cleaning) • Built an Excel dashboard to analise road accident data with over 4 lakh total casualties • Cleaned and structured raw data to ensure accurate reporting and analysis • Created KPIs for fatal, serious, and slight casualties to track overall safety trends • Used Pivot Tables and charts to compare yearly accident trends (2021 vs 2022) • Analyzed accidents by vehicle type, road type, and road surface conditions • Identified that most accidents occurred on single carriageways and during daylight • Compared urban vs rural accident distribution to understand location-based risk • Added filters for date and area (urban/rural) to make the dashboard interactive

Tools used : SQL (Joins, CTEs, Window Functions, Aggregations) • Analysed sales and customer data using SQL on the Northwind dataset • Used joins across multiple tables (orders, customers, products) to extract business insights • Identified top-selling products and top 10 high-value customers based on total spending • Analyzed yearly order trends and calculated running totals using window functions • Evaluated shipping performance by identifying late deliveries and top-performing shippers

Tools Used: Power BI, DAX, Data Visualization, Data Modeling • Developed a Power BI dashboard analysing e-commerce sales and profit trends • Created KPIs and DAX measures for performance tracking • Built interactive visuals using slicers and filters