📊 In this script, I'll be walking you through the creation of an Excel dashboard for sales data analysis.

🔍 I’ll show you how to explore data, identify unique values, and filter data within Excel.

📈 The dashboard will feature key performance indicators (KPIs) like total revenue, total price, quantity sold, and total orders.

📝 I’ll highlight the importance of data transformation, including extracting dates and times from strings and converting data formats.

📋 I'll cover the use of Excel functions like TEXT, DATE, and TIME to manipulate and analyze the data effectively.

📊 The dashboard will include charts that provide insights into daily trends for total revenue and total orders, as well as sales by category and pizza size.

📈 I’ll explain how to calculate the average order value and analyze each category’s contribution to the total revenue.

🗓️ I’ll draw insights from the data, such as identifying the most popular pizza categories and sizes, and pinpointing the peak order times and days.

🛠️ The dashboard will be interactive, allowing you to filter and view different segments of data for deeper insights.

🔑 I’ll emphasize the power of Excel dashboards for data analysis, giving you a clear and actionable overview of sales performance.

📚 The final dashboard will be a comprehensive tool that combines data visualization with key insights to support business decision-making.