Week 3 - Information Systems Flashcards
(21 cards)
What is external structured data?
A logical extension of current analytics on internal structured data in the enterprise.
Examples include mobile phones, credit history, travel history, real estate records, and census data.
What is internal structured data?
The category best understood by the enterprise, including CRM, web profiles, sales records, HR records, financials, and inventory.
What represents the largest area of opportunity for enterprises to gather consumer insights?
External unstructured data.
Examples include Google, Twitter, Facebook, Instagram, Pinterest, blogs, and external sensor data.
What is internal unstructured data?
A prime learning ground for the enterprise to understand how to mine value from these data formats.
Examples include online forums, web feeds, SharePoint, sensor data, and text documents.
What defines structured data?
Clearly defined data fields, easily searchable, and often requires data warehousing for reporting and analysis.
What characterizes unstructured data?
Not easily searchable, hard to manage, and requires creativity to pull relevant data for analytics.
Sources include social media, mobile applications, location services, sensors, and various document types.
What is the formula to convert data into information?
Data -> Contextualise, categories, calculate, quality, condense = Information.
What does contextualising data involve?
Understanding the context and purpose for which data were collected.
What are management decision types?
- Unstructured decisions
- Semi-structured decisions
- Structured decisions
What defines unstructured decisions?
Require judgement, evaluation, and insight to solve the problem.
What is a golden record?
The most accurate and reliable data, prepared or verified to represent the objective truth as closely as possible.
What are data standards?
The rules by which data are described and recorded.
What is data quality?
The ability of a given data set to serve an intended purpose.
What is metadata?
Data about data, providing structure, context, and meaning.
What are the types of metadata?
- Structural
- Administrative
- Descriptive
What is master data?
The consistent set of identifiers and extended attributes that describe the core entities of the enterprise.
What are the characteristics of master data?
- Less volatile
- More complex
- Valuable or mission-critical
- Non-transactional
What is an inner join in data joining?
Focuses on the common items (intersection) between the two tables.
What does an outer join: left do?
Keeps all data in the left table and adds to it using matching entries from table 2.
What does an outer join: right do?
Keeps all data in the right table and adds to it using matching entries from table 1.
What is a full outer join?
Combines and returns all data from two or more tables, regardless of whether there is a match.
