Southern-Restaurant-Dashboard

Developed an interactive Power BI dashboard for a restaurant chain, analyzing sales, top items, and revenue trends. Used advanced DAX functions (RANKX, SUMX, TOPN) for calculations and created drill-downs, slicers, gauges, and bookmarks (e.g., COVID impact) for dynamic, actionable insights on performance.

Features

• Total Sales Analysis: Visualize sales trends by day, month, and location.
• Top 10 Menu Items: Track the highest-grossing items with percentage contributions.
• Advanced DAX Calculations: Implemented RANKX, SUMX, TOPN, and DATESINPERIOD for rolling averages, revenue, and more.
• Drill-Down Interactivity: Drill down from summary to location-specific dashboards for deeper insights.
• Slicers: Filter data dynamically by location, date, and other dimensions.
• Gauges and Cards: Display average reviews, waiting times, and other key metrics.
• COVID-19 Impact: A dedicated bookmark to assess how COVID affected restaurant sales.

Technologies Used

• Power BI: For data visualization and dashboard development.
• DAX (Data Analysis Expressions): To perform complex calculations and data manipulation.

Key DAX Functions

• RANKX: Ranking top-selling items.
• SUMX: Summing up calculated values across rows.
• TOPN: Extracting the top 10 menu items.
• DATESINPERIOD: Calculating rolling averages.

How to Use

1. Clone this repository.
2. Open the .pbix file in Power BI Desktop.
3. Explore the different tabs to view the dashboard's features.
4. Use slicers to filter data by location, date, and other dimensions.

Conclusion

This dashboard is designed to provide valuable insights into restaurant performance, helping