GitHub - albainfantes-data/Advanced-Analysis-Power-Query: Comprehensive Microsoft Excel business analytics project using Power Query, Pivot Tables, advanced formulas, data validation, and KPI analysis. Includes data cleaning, business reporting, customer segmentation, revenue analysis, operational performance evaluation, dashboard preparation, and documentation based on a realistic e-commerce dataset.

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 1 Commit
Screenshots		Screenshots
Advanced Analysis - Cleaned Data.xlsx		Advanced Analysis - Cleaned Data.xlsx
Advanced Analysis - Raw Data.xlsx		Advanced Analysis - Raw Data.xlsx
Dashboard.xlsx		Dashboard.xlsx
README.steps.md		README.steps.md
README.steps.pdf		README.steps.pdf

About

Comprehensive Microsoft Excel business analytics project using Power Query, Pivot Tables, advanced formulas, data validation, and KPI analysis. Includes data cleaning, business reporting, customer segmentation, revenue analysis, operational performance evaluation, dashboard preparation, and documentation based on a realistic e-commerce dataset.

data-cleaning data-visualization excel excel-dashboard power-query