excel-data-analysis

Run DuckDB inside Excel VBA: pandas-style analytics via in-process SQL + native C bridge. High-speed Range/Array ingestion, Parquet/CSV/JSON I/O.

This project analyzes the IMDB movie dataset using Excel and Tableau, exploring trends in genres, ratings, budgets, and revenues through data cleaning, statistical analysis, and visualizations.

Analyzing hiring trends, salary distribution, and rejection rates using Microsoft Excel and Tableau. Includes a Tableau KPI dashboard and Excel-based insights for data-driven hiring decisions.

Interactive Excel dashboard for US wage & employment trends across 48 states and 10 industries — built for high school career guidance

Mac Donald's Sales Analysis and Dashboard using Advanced Excel

"Machine Downtime Dashboard" Using power BI

GEN-Z SURVEY DASHBOARD

📈 Excel dashboard project analyzing e-commerce sales performance with KPIs, charts, and slicers.

Interactive Excel dashboard analysing mental health treatment patterns in the technology industry

This Excel dashboard analyzes customer service interactions through contact type analysis, agent performance comparisons, customer satisfaction tracking, and weekly trends. Built with PivotTables, PivotCharts, and Slicers, it transforms customer service data into a reporting solution for exploring operational and service-quality insights.

Created a sales dashboard in Excel using Power Query and Power Pivot is a powerful and efficient way to manage and analyze large datasets. Both tools allow users to process and visualize data more effectively than traditional Excel methods.

A Root Cause Analysis of an eCommerce company, Northwind Trading, where sales figures has shown a downward trend for the last month and the company also noticed that several customers posted negative comments on social media about the online store.

Excel dashboard portfolio showcasing data cleaning, Power Query, Pivot Tables, KPI reporting, and interactive business dashboards.

Comprehensive coffee sales analysis leveraging Excel functions, Pivot Tables & Slicers. Covers sales trends (2019-2021), top customers, country-wise revenue, and growth insights with a dynamic interactive dashboard.

This project explores the data science job market, revealing correlations between skills, job roles, regions, and salaries. Leveraging Excel’s Power Query, PivotTables, DAX, and charts, it highlights high-paying skills like Python and SQL. These insights aim to guide data professionals toward in-demand skills for competitive career growth.

The Coffee Order analysis contains customer data, order details, and product information, along with summaries that show sales trends and top-performing customers and countries. It provides a quick overview of the coffee business’s key metrics and insights.

Building data analytics projects with Python, Excel, and visualization tools.

An interactive Excel data analysis dashboard tracking $1.93M in sales and profitability across 49 states. Built using Pivot Tables, dynamic charts, formulas, and slicers to uncover key retail business insights.

Vrinda Store analysis and Dashboard using Advanced Excel

This project examines the gender wage gap across eight countries (Brazil, France, India, the Philippines, Sri Lanka, Switzerland, Thailand, and the United States), spanning six sectors and the period 2018 to 2023 using monthly earnings data drawn from the International Labour Organization (ILO).