February 13, 2009

Business Intelligence Quiz

Here's a problem your CMO wants you to solve.
  • Find all customers who have an e-mail address, and have purchased at least one time from one of your stores in 2007. Calculate the probability that this customer visited your website during 2008, calculate the average number of website visits, and the average number of purchases during 2008. If the probability of this customer segment visiting the website is greater than 70%, pull all e-mail addresses for an e-mail campaign.
Use the comments section to describe the software tools you would use to solve this problem, and why you would use the tools you recommend to our readers. List the pros and cons of the various tools you recommend. Here is a list of possible tools:
  • Coremetrics
  • Omniture
  • Google Analytics
  • SPSS
  • SAS
  • Microsoft BI Suite / SQL
  • Oracle or SAP or Siebel or other large enterprise tools.
  • Business Objects
  • MicroStrategy
  • Microsoft Access and Microsoft Excel
  • Tableau Software
  • R
  • Cognos
  • Unica
  • Any other tool not mentioned here.