In this dashboard I allow users to select a date using parameter functionality in tableau. Once the user selects the data, the dashboard will show him
1. Sum of sales and profit and the total number of orders for the current or selected month.
2. It will also show him the percentage difference (month over month) whether it’s increasing as compared to the previous month or decreasing compared to the previous month.
3. I have created a bubble chart that shows the total number of sales for all the regions. This visual can also be used as a filter(if you click one region the whole dashboard will be updated accordingly).
4. There is a line chart that shows 13 months trend using the parameter selected date as the starting date.
5. There is a bar chart that shows sales of the top 5 sub-categories.
6. And at the last order detail chart in which there is data on orders, sales, and profit and also there’s a color on them green for profit and red for loss.
Link to Dashboard
Tools and Techniques
1. Tableau
2. Calculated fields
3. Level of details calculations
4. PowerPoint for background graphics
5. Data Modeling
6. Data Cleaning
7. Data Visualization