Skip to content

Dynamic coffee sales analysis using MS Excel, XLOOKUP, VLOOKUPS, Pivoting, pivot table visualizations and data analytical principles.

Notifications You must be signed in to change notification settings

YashPuri22/MSExcelPivot_Sales_Analysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 

Repository files navigation

MSExcelPivot_Sales_Analysis

This project focuses on a exploratory data analysis and visualized data-driven evaluation. Our primary goal is create dynamic coffee sales dashboard in Excel to gather and populate data. • Developed interactive pivot table visualizations with over >80% accuracy. SKILL

Data Analytical Principles and Data Visualization Tools used :

Microsoft Excel-Power Query, indexing, formula, pivoting, dashboarding.

Outcome of the analysis

Developed interactive pivot table coffee sales visualizations using Microsoft excel with over >80% accuracy.

About

Dynamic coffee sales analysis using MS Excel, XLOOKUP, VLOOKUPS, Pivoting, pivot table visualizations and data analytical principles.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published