Group your data visually.

A dashboard that provides a dynamic slice-and-dice overview of an organization's workforce, including departments, absences, and educational credentials.

Excel assignment covering conditional formatting, formulas, PivotTables, and PivotCharts (Due: 03-06-2021)

Analytics in excel

HR Dashboard using Excel with power-query and powerpivot

Developed an interactive Excel dashboard to analyze global coffee shop sales across multiple regions. Leveraged Power Query for data transformation and Power Pivot for calculating key KPIs including sales, profit, and margin metrics. Designed a visually compelling dashboard with slicers, gradient formatting, and dynamic pivot charts.

Using excel to analyze crowdfunding data

Performed E-commerce Sales Analysis to identify trends, optimize sales, and improve decision-making. Analyzed customer patterns, seasonal trends, and product performance using Python, SQL, and Power BI. Delivered actionable insights to enhance revenue, streamline inventory management, and boost customer engagement.

Shopper Spectrum: Streamlit app for customer segmentation (RFM + KMeans) and product recommendations (collaborative filtering) using e-commerce data.

This project uses advanced Excel to analyze real-world global data job postings, uncovering insights on salary trends, in-demand skills, and market patterns.

This project focuses on analyzing account sales performance over a five-year period to uncover trends, identify growth opportunities, and optimize sales strategies. The study examines sales data by account type, key account performance, and marketing campaign effectiveness.

Assessed historical shipping data for a shipping company selling products and shipping them to its customers' destinations to determine future shipping strategies.

This project utilizes Excel tool like Pivot Tables to analyze sales data and generate insights. It provides actionable recommendations for optimizing sales, customer discounts, and market expansion, helping drive informed business decisions.

📦 Sales & Logistics Optimization: Analyzed sales, returns, and shipping costs to enhance profitability and operational efficiency. Identified trends, minimized losses, and optimized pricing strategies using Excel (Pivot Tables, Dashboards)

An Excel-based customer churn analysis using raw data, cleaned tables, pivot tables, and a visual dashboard.

Conducted a comprehensive sales analysis for retail store “Vrinda” using MS Excel, including revenue breakdown by product, regional performance, and customer segment trends. Developed dynamic dashboard to highlight under-performing categories, seasonal shifts, and actionable recommendations for inventory optimization and promotional planning.

FNP Excel Sales Analytics: Excel dashboard + 3 CSVs with a simple star schema to analyze orders, products, and customers; dynamic KPIs (orders, revenue, ARPO, delivery days) and slicers reveal seasonal peaks across Holi, Diwali, Raksha Bandhan, and Valentine’s Day

Sales and Finance analytics project for AtliQ Hardwares using advanced Excel. Delivers customer performance report, market vs. target analysis, and P&L statements across fiscal years 2019-2021 using Power Query, Power Pivot, DAX measures, and PivotTables.

Telecom churn analysis using Excel dashboards to identify customer retention risks and revenue exposure.