Starbucks Revenue Distribution Analysis using Excel

ExcelDashboard.mp4

Coffee Type Robusta has 15% lower average sales than Coffee Types Arabica and Excelsa. Study and replicate formulation strategies (roast levels, flavor additives) used in Arabica and Excelsa for Robusta. Use blind tastings to reduce perception bias against Robusta.

Capitalize on Sep-Dec Tourist Spike Launch seasonal bundles: "Tourist Favorites", "Winter Warmer Packs". Collaborate with travel agencies, airports, and hotels (major sites of Tourist activities/presence) for bundle promotions.

Sales in the United States dropped sharply in August 2022, going from $860+ in July to just $196 in August. Re-engage the U.S. market in Summer Flash sales and loyalty boosts for U.S. customers, Promote feedback forms with free coupons asking about reasons for drop-off

Among the top 10 customers by revenue, 7 do not have loyalty cards, Introduce a VIP Loyalty Tier for high spenders encouraging /making it easier for customers to spend more.

Extensively cleaned data using Textsplit(), Substitute(), Iferror() and other functions.

Index matching for optimized data population, reduced the need of manually writing formulas at each column.

Enabled cross-sheet analysis through customer ID matching via XLOOKUPs (an advanced version of VLOOKUPs), resulting in a ~10% reduction in search processing time over VLOOKUP implementations.

Performed data validation by integrating conditional formatting with lookups, to effectively deal with edge cases and missing values.

Structured datasets as Excel Tables this ensured formula ranges and pivot tables auto-updated instantly, saving considerable time and reducing errors previously caused by static sheet references. | Grouped data points by specific features/columns for targeted analysis

Name		Name	Last commit message	Last commit date
Latest commit History 18 Commits
README.md		README.md
coffeeOrdersData.xlsx		coffeeOrdersData.xlsx

Provide feedback