Supply chain analysis using sales data to optimize distribution, forecast demand, and improve inventory management

Data-driven analysis of sales performance metrics from 2014-2017, identifying key trends in product sales, regional performance, and profitability. Provides actionable insights to optimize inventory, improve profit margins, and enhance customer satisfaction in a competitive market.

Analysis of consumer complaints in the financial services sector, leveraging data from 2013-2016. This project examines customer satisfaction, resolution times, and dispute rates across various companies and products. It provides actionable insights and recommendations to improve complaint handling processes, enhance customer satisfaction.

Data-driven analysis of inventory management and supply chain efficiency (2015-2018). Identifies key trends in product classes, sales performance, and shipping. Provides actionable insights to optimize inventory levels, reduce costs, and improve customer satisfaction in a complex supply chain environment.

Data-driven analysis of customer churn in telecommunications (2015-2018). Identifies key factors influencing customer retention, provides insights on demographic and behavioral patterns, and offers strategies to reduce churn and increase customer lifetime value.

The HR Insight Dashboard provides a dynamic overview of an organization's workforce. It visualizes key metrics such as department distribution, absences, and educational credentials, enabling HR professionals to make data-driven decisions and develop proactive strategies.

This project involves a comprehensive data analysis of a hotel reservation dataset using Excel. The primary focus is on examining reservation cancellations. Through detailed analysis and visual representation.

The HR Attrition Dashboard offers a detailed view of employee turnover. It visualizes key metrics like attrition by role, education, age, gender, and travel. Interactive filters for department, gender, performance, and distance help analyze specific data subsets. This tool aids HR in making data-driven decisions to improve retention.

This project showcases a comprehensive Customer Detail Dashboard built using Excel. It visualizes key metrics and insights from transactional data (2020-2022), providing an interactive interface for analyzing customer behavior, sales performance, and profitability across regions and demographics.

This DAX-based eCommerce dashboard provides a real-time snapshot of a business's financial position, aiding FP&A by highlighting key metrics for better decision-making. It handles large datasets from 2019 to 2021, visualizing KPIs like cumulative sales, profitable customers, and profit trends.

Assessed 8 years of historical shipping data to develop strategies for future shipping optimization and sales performance improvement.

A tool to monitor expenses, helping to make data-driven and intelligent financial decisions based on a comprehensive overview of my finances.

Conducted extensive analysis of WeTalk's 2020 Q1 dataset using Google Sheets. Leveraged pivot charts to extract actionable insights, meticulously crafting a comprehensive dashboard for detailed evaluation of agent performance and operational trends in the support center.

This repository serves as a showcase of the skills I've acquired through Datacamp's "Data Analysis in Excel" course.

'Vrinda Store' Data Analysis Project using Excel

Advanced MS Excel