MIS 325 Lecture Notes - Lecture 28: Data Warehouse, Customer Relationship Management, Enterprise Software
MIS 325 - Data warehousing and business intelligence – 3.5
• Data Sources
o TPS
▪ Based on purchase platform, there are varying amounts of data to
be collected
• i.e. Amazon vs. Costco
▪ data provides valuable info about customers
▪ tracked transactions → increased insights → increased sales
• can better make pricing decisions, stocking decisions,
decide product mix, webpage layout, make
recommendations, etc.
o Enterprise software
▪ CRM – customer relationship management
▪ SCM – supply chain management
▪ ERP – enterprise resource planning
▪ Software (the three listed above)
• Constantly creating new databases
• Some data might come from orgs itself or outside orgs
o Survey
▪ Zara – fast fashion company
▪ Learn about customers/predict fashion trends
▪ Traditional fashion stores – decide fashion 9 months ahead of time
to get it manufactured
▪ Zara
• Collect data from customers via surveys
• Make what customers want
• Don’t repeat production of a certain product
o External sources
▪ Partners
• Manufacturer → retailer → customer
▪ Data aggregators
• Firms that collect and sell data
• i.e. Facebook
o collects lots of data
o makes money via ads
o ads are based on your interests – target
marketing/personalization
• LexisNexis
• Acxiom
• Facts
o 90% of the world’s data generated in the last two years
o Data = collection of raw facts
o Information = processed data with context
o Knowledgeable = actionable insights
• Data rich, information poor
find more resources at oneclass.com
find more resources at oneclass.com