Ch. 6 Enhancing Business Intelligence Using Big Data, Analytics, and AI Flashcards
Ad Hoc Query
tools created because of unplanned information, provide an easy to use interface, allowing managers to run queries and reports themselves without having to know query languages or the structure of the underlying data
online transaction processing (OLTP)
provide automated responses to the requests of users, designed to handle multiple concurrent transactions from customers, fixed number of inputs and outputs
enable users to perform ad hoc analyses of different dimensions of data beyond simple data summaries
operational and informational systems
operational: can generate wealth of data that can serve as useful inputs into business intelligence and advanced analytics that can be linked to an inventory system but also capture valuable data
informational: systems designed to support decision making based on stable point in time or historical data
data warehouse
- integrate multiple large databases and other data sources into a single repository
- contains both historic and current data for analysis and reporting
- is suitable for direct querying, analysis or processing
data cleansing
the process of detecting, correcting or removing corrupt or inaccurate data retrieved from different source systems leaded into the data warehouse and are ready for being used for complex analyses
data lakes
central repositories allowing for storings structured, semi-structured, and unstructured in a raw format
data marts
a data warehouse that is limited in scope, contains selected data from the data warehouse such that each separate data mart is customised for the decision support needs of a particular end user group
data mining
provides capabilities for discovering hidden predictive relationships in data
can analyse massive amounts of data to identify characteristics or profitable customers, purchasing patters and credit card transactions
methods of data mining
association discovery
sequence discovery
clustering and classification
association discovery
a technique used to find associations or correlations among purchased together to redesign the store’s layout and optimise the customer navigational path
sequence discovery
used to discover associations over time
clustering and classification
clustering: process of grouping related records together based on having similar values fro attributes, finding structure in data
classification: used when the groups are known beforehand and records are segmented into these classes
unstructured data analysis
text mining
web content mining
web usage mining
text mining
the use of analytical techniques for extracting information from textual documents
web content mining
extracting textual information from web documents