Restaurant-Analysis

Power BI report created for Restaurant sales analysis under certain conditions and requirements.

Dashboard link : https://app.powerbi.com/view?r=eyJrIjoiNjAwNGUyYWUtMmRlMS00Y2Y1LTkwNjQtMzU5NDUzZWZmZDUxIiwidCI6IjY0ZGU2ZGRmLTA4ZTAtNGJjNy1iYTdkLWZmNTM1MmU1MGFjYyJ9

Description

1. Conducted in-depth sales analysis using Power BI, identifying key revenue drivers and seasonal trends, which enabled strategic menu adjustments and pricing optimization, resulting in a 15% increase in overall sales.

2. Developed customer segmentation models based on purchasing behavior, demographics, and dining preferences, allowing for targeted marketing campaigns that improved customer retention by 20% and increased average order value.

3. Created interactive Power BI dashboards to visualize sales performance by category, time, and location, facilitating real-time decision-making for management and enhancing operational efficiency across multiple restaurant locations.

4. Analyzed customer feedback and satisfaction ratings through Power BI, linking insights to sales data to identify areas for improvement in service quality, contributing to a 10% boost in customer satisfaction scores.

5. Leveraged data modeling techniques to integrate sales data with customer profiles, enabling personalized marketing strategies and promotions that drove repeat visits and increased customer loyalty in a competitive market.