us-store-sales-analysis

US Stores Sales Analysis Between 2010 and 2011. in USD. Data preparation using MySQL, visualization in Power BI.

Data source https://www.kaggle.com/datasets/dsfelix/us-stores-sales Main database sales_database.csv

SQL

us_store_sales_data_manipulation.sql

1. Create new database
2. Create Master Data table (master_table_us_sales)
3. Load data from main csv file into newly created master_table_us_sales table
4. Create 3 new tables for filtered data (store_data, product_data, sales_data) in order to use later in Power BI
5. Select data from master_table_us_sales and load into newly created tables
6. Export data into separate csv files (store_data.csv, sales_data.csv, product_data.csv)

Power BI

Show profit in time, by locations, and by products.