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

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

"Machine Downtime Dashboard" Using power BI

GEN-Z SURVEY DASHBOARD

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.

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

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.

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

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.

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

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.

This Excel dashboard analyzes CrustBite sales performance through daily sales trends, transaction-value distribution, product performance comparisons, and regional analysis. Built with PivotTables, PivotCharts, and Slicers, it transforms sales data into an interactive reporting solution for exploring sales patterns and financial insights.

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.

A collection of Excel learning resources, practice workbooks, and applied dashboard projects documenting my journey across data preparation, analysis, formulas, Power Query, PivotTables, Power Pivot, DAX, visualization, and interactive dashboard development through structured courses and practical business scenarios and projects.

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.

This Excel dashboard analyzes CrustBite order performance through daily order trends, revenue analysis, product performance, discount activity, and order-type comparisons. Built with PivotTables, PivotCharts, and Slicers, it transforms order data into an interactive reporting solution for exploring sales patterns and performance insights.