Analysis Of Transactions For ABC Retail Company Using SAS Enterprise Guide

Total amount of money spent per weekend on each shopping week

Business intelligence is being readily internalized by the organizations via various cutting-edge statistical softwares to unearth patterns hidden within raw data of the organizations and derive meaningful insights that act as strategic assets for decision making. Proper decision making minimizes operational cost and gives a strategic dimension to the organization. In today’s world of Big Data, business intelligence is crucial and it forays basically into the following arenas:

• Data mining & Data warehousing
• Sophisticated reporting of complex and huge datasets
• Business automation
• Predictive modeling
• Dashboard & data visualization
• Trend analysis

Among various business intelligence platforms in use by businesses, SAS (Statistical Analysis System) is a leading business intelligence platform that is the selected choice of large corporates. SAS is proficient in delivering mainly the following:

• Advanced analytics
• Multivariate analyses
• Data analysis of huge datasets
• Predictive analytics
• Data management
• Advanced reporting

Using SAS Enterprise edition, here our objective is to analyze the transactions of a retail organization i.e. ABC Retail Company based out of United States of America. We will highlight the central findings along with the SAS codes necessary to generate the findings.

1.

 Total amount of money spent per weekend on each shopping week

 The SAS System

SAS Code:

ODS HTML FILE = “C:UsersNTDesktopSAS FilesmyZip_7036713.html”;

PROC SQL;

SELECT SHOP_WEEK, SUM(SPEND) “TOTAL SPEND” FORMAT DOLLAR16.2

FROM mylib.transactions

GROUP BY SHOP_WEEK;

QUIT;

ODS HTML Close;

It can be seen that the highest spend has been for 9^th week year 2006 and the least is for 7^th week year 2006. The spend reduced from $ 14,785.95 on 9^th week to $ 14,341.26 on 12^th week 2006. Thus, a significant increase is found between 7^th and 9^th week but after that there is a little drop in 12^th week followed by increase in 19^th week.

2.

Money spent by each age group

 The SAS System

SAS Code:

ODS HTML FILE = “C:UsersNTDesktopSAS FilesmyZip_7036714.html”;

PROC SQL;

SELECT CUST_LIFESTAGE, SUM(SPEND) “TOTAL SPEND” FORMAT DOLLAR16.2

FROM mylib.transactions

GROUP BY CUST_LIFESTAGE;

ORDER BY CUST_LIFESTAGE;

QUIT;

ODS HTML Close;

The above finding is very crucial. We can see that XX i.e. unclassified has the highest spend. This is a drawback as the company has not been able to classify this segment. Then we see that the spend of OT i.e. others are second highest i.e. $ 12,821.90. This area has to be also classified properly. The young adults i.e. YA spends $ 5,987.48, OA i.e. older adults spend $5,805.45, the young families i.e. YF spend $ 9,547.96, pensioners spend $ 3,123.07 and older families i.e. OF spend $ 3,097.99.

3.

Total quantity sold and total amount of sales of each product in each state

The SAS System

SAS Code:

ODS HTML FILE = “C:UsersNTDesktopSAS FilesmyZip_7036715.html”;

PROC SQL;

SELECT SUM(QUANTITY) “Total QTY”, SUM(SPEND) “TOTAL SALE AMOUNT” FORMAT DOLLAR16.2, BASKET_DOMINANT_MISSION “PRODUCT CATEGORY”, STORE_STATE

FROM mylib.transactions

GROUP BY BASKET_DOMINANT_MISSION, STORE_STATE;

QUIT;

ODS HTML Close;

It can be seen that the highest selling product is Fresh and it is highest in the state of Victoria followed by mixed product category which is also highest in the state of Victoria i.e. VIC. The least selling states are Tasmania i.e. TAS, Australian Capital Territory and West Australia. Thus, the retailer has to vehemently focus in these areas.

4.

First 20 products that have the highest sales in value where more than 1 item was sold

SAS Code:

ODS HTML FILE = “C:UsersNTDesktopSAS FilesmyZip_7036716.html”;

PROC SQL number;

Select SPEND “TOTAL SALE AMOUNT” FORMAT DOLLAR16.2, PROD_CODE, QUANTITY

FROM mylib.transactions (firstobs = 1 obs = 20)

where QUANTITY>1

order BY SPEND desc;

quit;

ODS HTML Close;

The highest selling product is PRD0901637 and the least selling product is PRD0900684.

5.

SAS Code:

ODS HTML FILE = “C:UsersNTDesktopSAS FilesmyZip_7036717.html”;

PROC SQL number;

Select COUNT (DISTINCT CUST_CODE) ” Unique Customers”, STORE_REGION

FROM mylib.transactions

where STORE_REGION=’W01′;

quit;

ODS HTML Close;

There are 1857 unique customers in the store region W01.

The five areas where the organization has to focus:

• Classify the sales properly in the customer life stage segment as most of the sales are categorized as others or unclassified
• Target sales within 7^thand 9^th week
• Properly market and target the states of Tasmania i.e. TAS, Australian Capital Territory and West Australia
• Focus marketing strategies more on Non-food segment
• Target the young families with more innovative product basket

Conclusion

The study helped in comprehending various aspects of transactions of the retailer and simultaneously devises strategies to be more productive and earn more revenues. The study helped to focus on the areas of strength as well as the areas of weaknesses so that prescriptive measures can be taken wisely.