I developed a comprehensive Power BI dashboard for analyzing pizza sales data, leveraging Microsoft SQL Server and DAX queries. This project aimed to provide actionable insights for optimizing sales strategies and improving overall business performance.
- Power BI
- Microsoft SQL Server
- DAX (Data Analysis Expressions)
- Interactive Dashboards: Developed user-friendly dashboards allowing stakeholders to explore pizza sales data dynamically.
- Sales Trends Analysis: Utilized DAX queries to analyze sales trends over time, identifying peak sales periods and areas for improvement.
- Customer Segmentation: Implemented customer segmentation analysis to identify key customer groups and tailor marketing strategies accordingly.
- Demo Video Presentation: https://github.com/vbhatsaccnt/Pizza-sales-Analytics-Dashboard/assets/67544433/3116e87b-aed6-4518-ba8e-5cf35dcc0157
The project utilized transactional data from pizza sales, incorporating key metrics such as order size, delivery times, and customer details from the Microsoft SQL Server database.
Employed SQL queries for data cleaning and transformation, ensuring data accuracy and reliability. Addressed any inconsistencies in the raw data to enhance the overall quality.
Included visually appealing and informative charts and graphs in the Power BI dashboard, such as:
- Monthly Sales Trends
- Pizza Revenue and Sales Pie Charts
- KPI Analysis
The analytics dashboard provided valuable insights into customer behavior, leading to targeted marketing initiatives and improved operational efficiency. The project resulted in identifying which are the best and worst performing pizza's.
Encountered challenges with data normalization and inconsistencies. Implemented SQL queries and DAX functions to standardize data, ensuring accurate analysis and visualization.
Looking ahead, potential enhancements include integrating external data sources, implementing forecasting models, and refining customer segmentation for more targeted marketing strategies.
This project showcases my proficiency in Power BI, Microsoft SQL Server, and DAX queries. It not only provided actionable insights for pizza sales optimization but also demonstrated my ability to tackle data challenges and create impactful visualizations.