From Google Sheets to Power BI: Turning Coffee Sales Data into an Interactive App! 📊
I’m excited to share my latest Coffee Sales Analysis Dashboard, built by connecting Google Sheets directly to Power BI to transform raw transaction logs into an automated, interactive visual experience.
Instead of static reports, I designed this project as a cohesive, cafe-themed application with seamless page navigation and live cloud connectivity:
🔹 Automated Google Sheets Integration: Connected Power BI directly to a Google Sheet, allowing the report to track updates seamlessly with a live Last Refresh timestamp right on the home screen.
🔹 Home Screen & Executive Summary: Features interactive month slicers alongside a dynamic chalkboard displaying key performance highlights (shown for June):
• Total Coffee Sold: 223 cups
• Total Sales Revenue: $7.62K
• Peak Sales Period: Night
• Best Performing Month Overall: March (494 cups)
• Top 3 Best-Selling Coffees: Americano with Milk (66 cups), Latte (50 cups), and Cappuccino (46 cups)
🔹 Interactive Analytics Dashboard: Users can dynamically slice data by Month, Time of Day (Morning, Afternoon, Night), and Coffee Type, complete with custom buttons to toggle between Quantity and Cost, a clear-slicers reset button, and custom visual tooltips.
🔹 Product Catalog & Dataset Views: Includes an interactive menu catalog showing drink visuals and unit pricing (such as Cappuccino at $38.70), alongside a clean table view for inspecting the full dataset totaling $112.25K in overall sales.