USA Store Sales Analysis

This project involves the creation of a sales dashboard for a store. The dashboard was created through several steps, including connecting to a database (SQL, Excel, or Web), analyzing tables and relationships, data cleaning, developing a model, and creating the dashboard itself. The data cleaning process involved identifying and addressing columns with high null values and converting column names into header names. The dataset was also transformed by adding new columns, such as delivery date and year, and applying conditional formatting to the "Returned" column. Relationships between orders, returns, and people tables were established. The final dashboard includes several charts, including a card displaying total sales, total quantity, and average delivery day, a slicer for year, a card showing total orders, a map displaying sales by region, and stack charts showing profit and loss of the top 5 products.