02 Data Requirements for Analytics Flashcards
Tell me what the process of production and consumption of data entails?
- Business REQUIREMENTS.
- Data sources (SYSTEMS of record and others)
- Data Warehouse (data marts)
- Data models (used by analysts)
- Analytics Output
What are the types of data out there?
- Unstructured
- Transactional
- Metadata
- Hierarchical
- Master
What is UNSTRUCTURED data?
E-mails, white papers, corporate intranet portals, product specifications, marketing collateral, PDF files
What is TRANSACTIONAL data?
Monetary and non-monetary interactions (deliveries, invoices, trouble tickets, claims)
What is METADATA data?
Data about other data
What is HIERARCHY data?
Stores relationships between other data (like company organisational structures or product lines)
What are the THREE LAYERS of Data Requirements for ANalyticssss?
- Organisational
- OPerational
- Technical
What are the THREE DIMENSIONSSS of Data Requirements for ANalyticssss?
- Functional
- Corporate governance
- Measurement
Explain the oRgAniSatiOnaL level of data requirements?
1) Business capabilities: reporting, analysing, measuring, monitoring, forecasting, visualisation, search
2) Business value: strategic/operational/tactical value, cost vs. value, ROI/ROA
Explain the OPERATIONAL level of data requirements?
1) Business services: metrics, analysis, querying, reporting
2) Business applications: monitoring & management systems, information
Explain the Technical level of data requirements?
1) Service levels: performance, capacity, security, availability
2) Technology: data/metadata mgmt., data integration, warehousing, analytics
What are some aspects of the Functional Dimension????
Strategy Finance HR Marketing Sales
What are some aspects of the Governance Dimension????
Policy
Compliance
Risk
Audit
What are some aspects of the Measurement Dimension????
Measures Metrics Indicators References Trends