Ohne Titel

Datawarehouse, OLAP, Datamining and Balanced Scorecard

Data Warehouse

Extract data from different applications

Once debugged

Specially structured are stored in a data warehouse

Business analysis

For construction, three stages are established

Examine the Entity Relationship schema of the operational database

Of collecting user requirements through interviews

Contrast the information

OLAP

Online analytical processing allows access to organized data

Aggregates from enterprise data sources

Types of OLAP systems

ROLAP

It stores the data in a relational engine

MOLAP

Stores the data in a multidimensional database

HOLAP

Stores some data in a relational engine and others in a multidimensional database

Data mining

Process

Select

Explore

Modify

Model

Rate

Large amounts of data with the aim of discovering knowledge

Enables real-time management effectively

Automatic or semi-automatic

Balanced Scorecard

Tool that allows to align the objectives of the different areas or units

Company strategy and follow its evolution

Victoria Martinez Del Valle