BUSINESS ANALYTICS

The Dude, a division of Lebowski industries, is a chain of big and tall menís apparel stores operating throughout the country. The chainrecently ran a promotion in which discount coupons were sent to customers of other Lebowski stores. Data collected for a sample of 100 Lebowski credit card transactions at The Dude during a single day while the promotion was running are contained in the file name ìDUDEî. 

The DudeCard method of payment refers to charges made using a proprietary card (like a Macyís or Nordstrom card). Customers who made a purchase using a discount coupon sent in the mail to them are referred to as ìcouponî customers. All others are called ìno couponî customers. 

Because the promotional coupons were not sent to regular Dude customers, management considers sales made to people presenting the promotional coupons as sales it would not otherwise make. Of course, The Dude also hopes that the promotional customers will continue to shop at its stores. 

In addition, the following variables might need some clarification.

ï ìItemsî refers to the total number of items purchased, i.e. the total number of SKUs scanned.

ï ìNet Salesî refers to the total dollar amount charged to the credit card.

Management at The Dude would like to use this sample data to learn about its customer base and to evaluate the promotion involving discount coupons.

They have asked you, the hotshot Business Analyst, to develop a managerial report. This report should contain the following information at a minimum.

1. An executive summary of your findings. This should be no more than 1 page double-spaced. The executive summary should answer the top three most important questions. And it is YOUR responsibility to tell management why those are the most important and why.  Hint: Two of the most important variables will be Gender and Marital Status. But they are not the ONLY ones.

2. Percent frequency distribution for the key variables. 

3. A column chart or pie chart showing the number of customer purchases attributable to each method of payment.

4. A cross-tabulation of type of customer (regular or promotional) versus net sales. Comment on any similarities or differences you see.

5. A scatter diagram to explore the relationship between net sales and customer age.

The final product will have a 1 page executive summary along with accompanying graphs/charts as appendices. Then, you can refer to the appendices when making a point about your data.

Hint: you may want to use the Pivot Table function in Excel to do this assignment. If you do, the data will fall into place for you.

TAKE ADVANTAGE OF OUR PROMOTIONAL DISCOUNT DISPLAYED ON THE WEBSITE AND GET A DISCOUNT FOR YOUR PAPER NOW!