week 8 & 9 Flashcards
what are the characteristics of good quality data?
timeliness accuracy relevent sufficient in context
what are some potential costs of poor quality data?
promoting to the wrong people
inacurate invoices
losing customers
buying unpopular inventory
what is the purpose of a database?
to keep track of information that the organisation considers relevent. databases can also capare data to find trends.
what are the components of a database?
tables/fields
relationships
metadata
what is metadate?
metadata describes the structure of the database
what is a DBMS and what is it used for?
database management system.
a program that is used to create, process and administrer a database.
what is business intelligence?
the patterns, relationships, trends and predictions identified in data.
what is a business intelligence system?
an IS that processes operational, social and other data to identify patterns, relationships and trends for use by the organisation.
what is the objective of BI?
to help people undertand: the capabilities of the organisation future trends in the market the organisation's environment actions of competitors.
What is big data?
a collection of data sets so large that it becomes difficult to process using traditional applications.
what are some real world uses of BI?
identifying purchasing patterns
predictive policing
just-in-time medical reporting
what is a data warehouse?
a collection of information from many places that supports business analysis activities and decision making.
draw the 9 components of a database wharehouse and their interactions.
production data
other internal data
external data
data extraction and cleaning/preparation
data warehouse and dbms
- database
- metadata
BI tools
various users
what are some problems with operational data?
inconsistency
dirty data
insufficiency
old data
what do reporting apps do?
intergrate data from multiple systems (sort, graph and compute) to present information in a useful way.
