This project worked on datasets provided by Olist, the largest department store in Brazilian marketplaces. These datasets allow us to have a better understanding about the business, sales, market trends, and customer base of Brazilian e-commerce.
Dataset sorce: https://www.kaggle.com/olistbr/brazilian-ecommerce#olist_order_items_dataset.csv
- Wrangled and merged multiple datasets to one dataset with JMP for dimensional modeling and analytical analysis.
- Built the star schema for transforming the relational database into dimensional database.
- Utilized AWS, SQL and Python programming to analyze order data from different dimensions for discovering business insights.