| Title | Description | Tools |
|---|---|---|
| Data Mart - Sales Performance of An Online Supermarket | The aim of the project is to analyze the sales performance of an online supermarket specializing in fresh produce, and using Before and After analysis method to evalaute the sales before and after the implementation of sustainable packaging methods across the entire supply chain, from the farm to the customer. | MySQL |
| ABC Analysis of Inventory | The aim of the project is to implement ABC analysis technique which enables the categorization of inventory into three distinct segments - A,B,C - based on the value or importance of each. Through this analysis, organizations can rank their inventory and manage them efficiently. | MySQL, Microsoft Excel |
| Product, Transaction & Sales Analysis of a Clothing Company | The aim of the project is to assist the merchandising team in analyzing their sales performance and generate a basic financial report to share with the wider business. The analysis is performed at the product, sales, and transactions level and a reporting solution has been developed to automate the end entire analysis and reporting process. | MySQL |
| Title | Description | Tools |
|---|---|---|
| Analysis of Delivery Service in Supply Chain | Developed an interactive report to track the delivery service level of a supply chain by analysing key metrics against the target service level for each customer. | Microsoft Power BI |
| Supply Chain Analytics | The purpose of this dashboard is to provide a comprehensive view of the entire supply chain by merging data from various sources, including Revenue, Warehousing, and Product-related information. | Microsoft Power BI |
| Providing Insights to Management in Consumer Goods Domain | The aim of the project is to answer 10 ad hoc requests for which the business needs insights. This involves building SQL queries and creating visualizations to present the insights. | MySQL, Microsoft Power BI |
| Title | Description | Domain | Tools |
|---|---|---|---|
| - | - | - | - |
| - | - | - | - |