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.

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.

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

Collection of interesting VBA Scripts for Excel

A collection of advanced data analysis practice tasks using Microsoft Excel — covering Power Query, Power Pivot, DAX, and many more for hands-on learning.

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.

Our sales analysis leverages data-driven insights to understand customer preferences, seasonal trends, and market dynamics. By uncovering patterns in sales data, we inform strategic decisions, optimize inventory, and boost customer satisfaction. At Adventure Works, we transform data into actionable strategies to meet the evolving needs of adventure

This DAX-based eCommerce dashboard provides a real-time snapshot of a business's financial position, aiding FP&A by highlighting key metrics for better decision-making. It handles large datasets from 2019 to 2021, visualizing KPIs like cumulative sales, profitable customers, and profit trends.

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.

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

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

Customer segmentation and sales trend analysis using Oracle SQL and Excel Power Pivot on 500K+ online retail transactions. Includes RFM profiling, top product analysis, and a slicer-driven interactive dashboard.

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

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

Interactive Excel dashboards for Head Rest Bed Company using Power Query, Power Pivot, and DAX.

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.