Gadget Store Revenue Dashboard

For this project, the interest was total sales and revenue in February.

The goal was to identify states and cities with the highest amount of orders, quantify revenue by product, and identify total of each product sold by date.

I uploaded the data into SQLite studio and aggregated it to answer questions related to number of sales and revenue, which can be viewed in GitHub here SQL GitHub.

When importing the FebSales data into Tableau, I cleaned the data by editing column names and formatting some columns into the correct datatype.

I then created a Tableau Dashboard to showcase the desired information.

Upper-Left bar graph shows the total revenue for each product sold within February.

Bottom-Left Area Graph shows the total orders for each product per day in February.

Upper Right Bubble Chart shows the total orders in February for each city.

Bottom Right Map Chart shows the total orders per state in February d/t some states having multiple sales locations.