Excel MCP Server & CLI - 23 tools, 214 operations for AI-powered Excel automation via COM API

OLAP PivotTable Extensions is an Excel add-in which extends the functionality of PivotTables on Analysis Services cubes, the Excel Data Model (Power Pivot), and Power BI

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

A complete project that combines working using SQL, Excel and Power Pivot to create an interactive customized energy consumption dashboard. This is real word data for energy sources consumption recorded from 11 buildings in the US.

Designed an end-to-end Excel BI system using Power Query, Power Pivot, and DAX to evaluate multi-year profitability. Delivered four dashboards analyzing markets, customers, and fiscal trends for data-driven strategy formulation.

🌸 Excel-based Sales Analysis project using Power Query, Power Pivot, and interactive dashboards — analyzing Ferns & Petals' product, order, and customer data.

The folder of my work with Excel, VBA, and PowerBI for Data Analysis & Visualization.

End-to-end e-commerce analytics: Python data cleaning → Excel executive dashboards with slicers, CUBEVALUE, and dark-themed visualisations.

Collection of interesting VBA Scripts for Excel

Content: Import & Direct query, Data Modelling (Power Pivot), Star & Snowflake Schema, Normalisation & Cardinalities, Cross-filter direction and Sync Slicers

Excel P&L report suite — GM% by market, fiscal year, month & quarter

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

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.

Repositório com arquivos da Formação Excel da Alura. Reúne conteúdos sobre fundamentos do Excel, manipulação e análise de dados, gráficos avançados, funções essenciais, tabelas e modelagem de dados, além de automação e macros.

An engineering-first data pipeline for pulp mill effluent compliance using Power Query, DAX, and industrial root cause analysis.

This project demonstrates my end-to-end BI skills using Power Query, Power Pivot (DAX), and Excel Dashboarding. I built a dynamic and interactive sales performance dashboard for a multi-store coffee chain using raw data extracted from an ERP system.

📊 Excel Projects Portfolio – A collection of 5 projects showcasing skills from basic formulas to advanced dashboards using Excel, Pivot Tables, Power Query and Power Pivot. Includes Payroll System, Advanced Charts, Student Marksheet, and Interactive Sales Dashboards.

Excel (Power Pivot) retail dashboard + QA report (UCI Online Retail).

Data credibility and attendance analysis of CBSE Class 12 (2022) examination data. Focuses on denominator stability, integrity checks, anomaly detection, coverage-weighted insights, and reproducible Excel-based analytics workflows.

Analyzes patient admission and discharge data to identify peak hours, waiting times, and resource utilization using Power BI.