Product Analysis

Business Scenario and Company Background

It is a case from our Business Intelligence System course. The company has asked us to help them analyze their sales history and make recommendations to improve the company sales profit. Our group did product analysis on two product categories: Children's Apparel and Men's Apparel.

Here is the list of questions we answered :

• Recommend a marketing strategy for the overall Product Categories of Women’s Apparel and Accessories, with details for Product Types.
  Which products / product types/ product category should be featured?
  What should be done in the next year to maximize the Product Category profits?
  How are they performing against target? Do you expect them to meet their 2014 target?
  
• Recommend separate 2013 and 2014 bonus amounts for the Product Categories if the total bonus pool for 2013 is $1,000,000 and the total bonus pool for 2014 is $2,000,000.
  Base your recommendation on how well the channel is meeting its target and also how well each reseller and online is meeting their individual sales targets.
• Assess product sales by day of the week for the two Product Categories.
• Analyze patterns in product sales (for products in Product Categories of Women’s Apparel and Accessories) by channel and location.

Steps to do the analysis:

1. Designed a SQL data warehouse database containing: SQL staging tables to hold source data; SQL dimensional data model(star schema); SQL views (exact copies) of each of our dimension and fact tables; SQL views needed to support the visualization
2. SSIS packages (ETL)
3. Visualized the data in Tableau

Product Sales Overview

Bonus Recommendations

Sales Patterns Over Time

Sales Patterns by Channels