Chapter 8 - Data to create and preserve value Flashcards
1
Q
What data and feedback does sales need?
A
- Feedback on price, volume and customer feedback
- Live data on competitor pricing and trends
2
Q
What data and feedback does production need?
A
- Feedback on order levels and lead times
- Data to understand cost and cost drivers
3
Q
What data and feedback does HR need?
A
- Feedback on staff performance
- Data to incorporate appraisal and productivity
4
Q
What data and feedback does shareholders need?
A
- Feedback on future prospects
- Data about environmental needs
5
Q
What data and feedback does employees need?
A
- Feedback about systems and processes
- Flag data inefficiencies
6
Q
What data and feedback does directors need?
A
- Feedback on clarity of info
- Data on key metrics
7
Q
What are the 3 stages of transferring data (ETL)?
A
- Extraction
- Transformation
- Loading
8
Q
What is data profiling?
A
Prior to extraction, data needs to be analysed to understand content
9
Q
What is a data warehouse?
A
Store for data loaded in the ETL process
10
Q
What is the BI function?
A
Access and analyse data further and offers summaries
11
Q
What are the main trends of modern ETL?
A
- Unprecedented rate of growth
- New types and sources
- New tech
12
Q
What are the advantages of data modelling?
A
- Foundation for handling data
- Enforces business rules
- Consistency of naming values and conventions
- Quality of data enhanced
13
Q
What are the 3 levels of the data modelling process?
A
- Conceptual
- Logical
- Physical
14
Q
What happens in the conceptual level?
A
- Business orientated and practical
- Considers data and requirements
15
Q
What happens in the logical level?
A
- Begins to develop a technical map of rules and data structures
- Defines how data will be held and used
