power-pivot

Automate real Microsoft Excel with AI via MCP Server or CLI — Power Query, DAX, VBA, PivotTables, charts, and 326 operations.

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.

Build Power BI-like Excel executive dashboards with Power Query, Power Pivot, DAX, PivotTables, PivotCharts, and slicers.

Excel BI skills for AI agents / 面向 AI Agent 的 Excel BI 技能包: VBA, Power Query M, Power Pivot DAX, MDX/CUBE, ADO/SQL, QA.

Interactive Excel Sales Dashboard built using Pivot Tables, Pivot Charts, Power Query, Power Pivot, Slicers, and Timeline.

Interactive Sales Analysis Dashboard built with Advanced Excel, Power Pivot (Data Model), Pivot Tables, Dynamic KPIs, Slicers, Timeline, and Business Intelligence techniques.

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

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

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

Interactive Sales & Customer Analysis Dashboard built in Microsoft Excel using Power Query, Power Pivot, PivotTables, DAX, KPI reporting, and data visualization.

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.

Excel Data Analyst Course Project

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.

Dashboard de Ordens de Serviço desenvolvido no Excel com Power Query, Power Pivot, DAX e Data Storytelling.

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.

Dashboard Kanban Board desenvolvido no Excel para acompanhamento e análise de tarefas, com Power Query, Power Pivot, DAX e UI/UX.