A Famous pizza shop wants to analyze sales of last year and to take business informed decisions
Embedded Files
Mission of the project
How many customers do we have each day? Are there any peak hours?
How many pizzas are typically in an order? Do we have any bestsellers?
How much money did we make this year? Can we identify any seasonality in the sales?
Are there any pizzas we should take of the menu, or any promotions we could leverage?
Loading and Transforming data in required Format
After loading data which is in excel format into Power Bi tool and making necessary transformations like changing date /time formats adding additional columns as per requirement.
Modeling data with required relationships.
Modeling data with required relationships.
After the data transformation,modeling of data should be done based on requirements.
Data modeling means creating or detecting necessary relations between tables by using common columns(foreign key) between them.
Data Visulaization Dashboard
The final analysis report is here.All the necessary required insights has been derived and some visuals are derived from DAX calculations and measures.I've analyzed the busiest days and time, number of pizzas made during peak periods, best and worst selling pizzas, average order value, seating capacity, etc.All the analysis and visualization part done by using data visualization tool Microsoft Power BI.
Page updated
Google Sites
Report abuse