This project is an interactive dashboard that tracks the sales data for 6 beverages sold in the US using Power BI. The US beverage market is highly competitive and dynamic, and tracking sales data is essential to stay ahead of the competition. To create this dashboard, I followed a step-by-step process that involved importing datasets into Power BI, cleaning them using Power Query Editor, and creating the dashboard with multiple functionalities.
Overall, this project demonstrates the power of Power BI in visualizing and analyzing complex data. By following a step-by-step process, I was able to create an interactive dashboard that provides valuable insights into the US beverage market.
To import a dataset into Power BI, you'll first need to open Power BI Desktop and select "Get Data" from the Home tab on the ribbon. From there, you can choose the data source you want to import from, such as Excel or SQL Server, and select the tables or views you want to bring into Power BI. For our purpose today, we will be choosing Excel since our dataset is in xlsx format.
To better analyze sales data, one useful technique is to use the custom column function to calculate revenue. This function involves multiplying the unit price by the unit sold, which results in the total revenue. By adding an additional column for revenue, users can easily see how much money the business is generating from each product or service. This information can then be used to identify top-selling items, optimize pricing strategies, and make informed business decisions. Furthermore, by regularly tracking revenue, businesses can monitor their financial performance and make necessary adjustments to ensure continued growth and success.
When creating a Power BI interactive dashboard, careful consideration should be given to the types of visualizations used to represent data. It is important to select visualizations that accurately and effectively display the relationships and patterns within the data, while also considering the target audience and their level of data literacy.
The metrics of revenue, sums of unit sold, and average of price per unit are important to include in the dashboard because they provide insights into the performance of different products in the market. Revenue gives a comprehensive view of how much money is being made, while the sums of units sold and average price per unit help to analyze which products are selling well and at what price point.
The sum of revenue by month is an important metric to include because it can help to identify trends or seasonality in the market. It may reveal that certain beverages sell better in the summer months or during the holiday season, for example.
Lastly, a graph of the sum of revenue by state can be useful to understand which regions are performing well in terms of sales, and which regions might need more attention or investment. This can help to inform business decisions such as where to focus marketing efforts or where to expand distribution.