Process:

1. Import the data into server
2. Create database into server
3. Document SQL formulas
4. Connect MSSQL Server to Excel
5. Data cleaning -> Data processing -> Data analysis
6. Data Visualisation
7. Complete Dashboard

Purpose of Dashboard:

We need to analyze the key indicators for our pizza sales data to gain insights into our business performance.
We do this by calculating and analyzing the following key metrics and key trends:

Metrics:

- Total Revenue
- Average Order Value
- Total Pizzas Sold
- Total Orders
- Average Pizzas Per Order

Trends:

Daily Trend for Total Orders - Hourly Trend for Total Orders - Percentage of Sales by Pizza Category - Percentage of Sales by Pizza Size - Total Pizzas Sold by Pizza Category - Top 5 Best Sellers by Total Pizzas Sold - Top 5 Worst Sellers by Total Pizzas Sold

Conclusion:

By observing the Total Revenue over the 12 month period, we can conclude that business performance for 2015 was stable but with concerning trends. The business averaged a total revenue of R68 155 from January to December 2015 with the lowest total revenue amount in October (R64028) and the highest in July(R72558). This means revenue has dropped by 6% at least twice in the year and has gone up by 6.5% once; leaving business growth for 2015 stagnant overall.