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.

Motor de análisis de datos y OSINT en R. Convierte datos extraídos de la web en mapas interactivos para análisis forense.

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.

GEN-Z SURVEY DASHBOARD

"Machine Downtime Dashboard" Using power BI

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.

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.

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 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 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.

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

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

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.

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

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.

Clean. Transform. Model. Visualize. Turning raw data into decisions with Excel & Power BI