Optimizing Inventory Management

Table of Contents

• Overview
• Problem Statement
• Data Sourcing
• Data Preparation
• Data Modeling
• Data Analysis & Insights
• Shareable link
• Demo

Overview

SellCheapy Retail is a chain of department stores that sells a wide range of products, including bikes and different components. Despite having a large customer base, the company has been struggling to increase sales in recent years. The management team is looking to use data analysis to understand customer spending patterns and make changes to their sales and marketing strategies to improve performance.

Problem Statement

Based on the request that was made from the management team we are following the user stories that were defined to fulfill delivery and ensure that acceptance criteria’s were maintained throughout the project.

Data Sourcing

• The data set used for this analysis was sourced from AdventureWorksDW
• The additional data set used for this analysis is available at: Sales Budget
• The query used to update the database can be found at Update Query

Data Preparation

Data cleaning and transformation was done in Microsoft SQL Server and the data sets was loaded into Microsoft Power BI Desktop for modeling.

Data Modeling

After the dataset was cleaned and transformed, it was ready to be modeled(using Power BI Desktop).

Data Visualization and Analyis

Data visualization for the datasets was done in 3 folds using Microsoft Power BI Desktop. Based on the business problem, the following report was prepared:

Figure 1 shows visualizations from Sales Overview page

Figure 2 shows visualizations from Customer Details page

Figure 3 shows visualizations from Product Details page

Shareable Link

You can interact with the report here: View Report

Demo

Optimizing.Inventory.Management.mp4