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.

Excel-based analytics project exploring salary trends, skill demand, hiring patterns, and compensation insights across 15K+ data job postings.

This interactive Excel dashboard leverages Power Query, Power Pivot, and DAX to analyse customer behaviour, and $29M in revenue. It transforms complex data into actionable insights, empowering stakeholders to optimize performance and drive strategic growth across North American markets.

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

Excel dashboard analyzing sales by category, occasion, month, and city.

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

End-to-end retail sales analysis using Power Query, Power Pivot, Pivot Tables & interactive Dashboard | Excel

Collection of interesting VBA Scripts for Excel

Excel-based data analysis using Power Query, Power Pivot (DAX), and dashboards for a multi-store coffee chain 🐙, with ERP data to track sales and trends.

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

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

Excel-based e-commerce analytics for FNP, a gift company. It covers data extraction, modeling, and visualization, providing actionable insights on revenue, customer behavior, and operations. Key skills include Excel, Power Query, Power Pivot, and DAX. The analysis culminates in data-driven business recommendations.

Interactive ER analytics dashboard — Power Query, Power Pivot, DAX KPIs

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

FNP sales analysis project with Excel dashboard, KPIs, and insights.