Q:

I am a data analyst in a media research company where we conduct a very large survey of sample size approx. 2,25,000 a year. My management wants to use data warehousing and or mining to extract the information on the different product categories to analyze and understand the inter-relations among different aspects like usage patterns, demographics, life styles, etc. How can I use data warehousing or data mining in order to use a variety of information on several products covered in the survey?

A:

Chuck Kelley’s Answer: This is prime data warehouse territory, having done this multiple times over the past few years. First, you need to model the data that you collect since the business requirements are somewhat clear. Second, build the extraction, transformation and load (ETL) processes and build the data warehouse. Third, define the semantic layer for the end-user tool to provide easy access to the data. You will most likely need a data mining tool to some of the interrelationships.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access