INSY DBMS ch 13

main multiple choice on final

Analytics

multidimensional field that uses mathematics, statistics, predictive modeling and machine learning techniques to find meaningful patterns and knowledge in recorded data. 

Business Analytics

Using analytics to solve business problems and drive business decisions and actions

Business Intelligence (BI)

comprehensive, cohesive and integrated set of tools and processes used to capture, collect, integrate, store and analyze data with the purpose of generating and presenting information to support decision making

Capturing value from data requires

excellence in each element of each link of the “insights value chain”

The insights value chain in multiplicative

• Data 

• Analytics 

• IT 

• People  

• Processes 

ETL

Extraction/Transformation/Loading

Data Store

Optimized for analysis and speed

Business Intelligence Architecture 

ETL, Data Store, query and reporting, data visualization, monitoring and altering, analytics

Data Visualization

the process of abstracting data to provide a visual data representation that enhances the user's ability to comprehend the meaning of the data 

Goal of data visualization

to allow the user to quickly and efficiently see the data's big picture by identifying trends, patterns, and relationships

Advantage of data visualization tools

The ability to zoom in and out, drill up and down, filter, etc. , makes it easier to understand large amounts of data

OLAP

Online Analytical Processing

OLAP characteristics

• Multidimension data analysis techniques 

• Advanced database support 

• Easy-to-use end-user interfaces 

Operational data

has a narrow time span, low granularity, and single focus. Such data is usually represented in tabular format, in which each row represents a single transaction. This format often makes it difficult to derive useful information.

Decision support system

focuses on a broader time span, tends to have high levels of granularity, and can be examined in multiple dimensions

Attribution hierarchies 

The attribute hierarchy allows the end user to perform drill down and roll up searches 

data cube

Conceptual three-dimensional cube of sales by product, location, and time. 

where are sales facts stored in a data cube?

Sales facts are stored in the intersection of each product, time, and location dimension. 

Data Warehouse

an integrated, subject-oriented, time-variant, nonvolatile collection of data that provides support for decision making

Components of the data warehouse

• Integrated 

• Subjects-oriented 

• Time-variant 

• Nonvolatile 

data mart

small, single-subject data warehouse subset that provides decision support to a small group of people

star schema

a data-modeling technique used to map multidimensional decision support data into a relational database

Facts

numeric values that represent a specific business aspect

Dimensions

qualifying characteristics that provide additional perspectives to a fact