MGS 8020 Business Intelligence

Practice Exercise

 

  1. Import the Raw Data and SIC Description from Assignment 1

  2. Answer the following questions:

    1. What is the total transaction amount in January 2009?

    2. How many customers in Raw Data who visited at least one restaurant (SIC 5812) in January 2009?

    3. How many distinct customers in Raw Data?

    4. What is the total transaction amount for drinking places (SIC 5813) in December 2008?

    5. How many customers have the transaction(s) in November 2008 but NO transaction(s) for grocery (SIC 5411)

    6. We would like to add a flag to the customers who spend between $0.01 and $50.00 as "A", between $50.01 and $100.00 as "B", between $100.01 and $500.00 as "C", between $500.01 and $1000.00 as "D", and >$1000.00 as "E"