General Enterprise Data Flow

Question 1

How does data get transformed into information in an enterprise

Answer 1

It is data sources to enterprise data warehouse then reporting and analysis tools

Question 2

The three system landscape

Answer 2

Data sources
enterprise data warehouse
reporting and analysis tools

Question 3

Three data sources

Answer 3

Erp systems
other databases
flat files

Question 4

All of an enterprise data is fed into this and all reports are obtained directly from it

Answer 4

Erp systems

Question 5

They are still machines with their limited capacity and purchasing power

Answer 5

Erp systems

Question 6

They might also not be able to address and enterprise needs and the company grows larger

Answer 6

Erp systems

Question 7

It makes extensive use of master data to help keep track of business partners and items

Answer 7

Erp systems

Question 8

When they can’t use erp system this will serve at the database that records all transactions for the day

Answer 8

Other databases

Question 9

If a branch of the company might be physically impossible to connect to the corporate network so they will use this

Answer 9

Other databases

Question 10

There are some instances where a branch is in such a remote location that an internet connection is not available transactions will be recorded in this

Answer 10

Flat files

Question 11

These are usually excel or delimited text files that business users create in order to make their own reports when needed

Answer 11

Flat files

Question 12

Delimited text files are usually either

Answer 12

Tab-delimited
comma separated value

Question 13

Delimited text files can still be opened in excel but this file might need a few extra steps before it can be read

Answer 13

Tab-delimited files

Question 14

This is built in order to consolidate the disparate data sources so that only the data necessary for reporting will actually be used

Answer 14

Enterprise data warehouse

Question 15

This is a tool to help build data warehouses

Answer 15

SAP business warehouse

Question 16

This is essentially a large database it is likely that technical column names are still use instead of more common

Answer 16

Enterprise data warehouse

Question 17

It is set up as a sort of translator so that business user can immediately understand what the data is

Answer 17

Semantic layer

Question 18

This is one of the defining features today in business analytics

Answer 18

Self-service BI

Question 19

These are created with an easy-to-understand interface so that the business user will be empowered to create their own reports

Answer 19

Reporting tools

Question 20

The three-tier architectures

Answer 20

Development DEV
quality assurance QAS
production PRD

Question 21

This is the most critical of the tree as it contains live data

Answer 21

Production

Question 22

It is the system that is used in the day-to-day transactions of the company

Answer 22

Production

Question 23

A lot of redundancies might be required for this landscape as it is needed for the proper function of the enterprise

Answer 23

Production

Question 24

When a new report needs to be created or a change in configuration needs to be made it should be done here first

Answer 24

Development

Question 25

This is essentially a copy of production that is placed separate from the other three landscapes

Answer 25

Disaster recovery

Question 26

It will act as a contingency when production becomes subject to catastrophic failure

Answer 26

Disaster recovery

Question 27

The five data reliability issues

Answer 27

Inconsistent terminology
rounding errors and truncation
nulls and zeros
incorrect inputs
outright data discrepancies

Question 28

A department might refer to an sku as a product and another might refer to it as material

Answer 28

Inconsistent terminology

Question 29

It consider the number of decimal places a given piece of numeric data has

Answer 29

Rounding errors

Question 30

It will have the same effect in rounding errors but instead of rounding the number decimal places are outright omitted

Answer 30

Truncation

Question 31

This is where the concept of garbage in garbage out is very apparent

Answer 31

Incorrect input

Question 32

It is the first data model that can be fully described mathematically

Answer 32

relational model

Question 33

It is the most common way to store and access enterprise data as it uses some form of structured query language

Answer 33

Relational model

Question 34

It records all transactions that is included into the system

Answer 34

TXN

Question 35

It stores all customer information

Answer 35

CUS_MAS

Question 36

it stores all product information

Answer 36

PROD_MAS

Question 37

It is a representation of the abstract structure of domain information

Answer 37

Schema or logical data model

Question 38

It is often expressed as a diagram and its use as foundation to designing database structures

Answer 38

Schema or logical data model

Question 39

It is the simplest approach used in designing enterprise data warehouse

Answer 39

Star schema

Question 40

It is comprised of fact table referencing any number of dimension tables

Answer 40

Star schema

Question 41

It records measurements for a specific event

Answer 41

Fact table

Question 42

These are typically referred to as transaction tables that contain very granular numeric data

Answer 42

Fact table

Question 43

Fact table is also referred to as

Answer 43

Transaction tables

Question 44

It contains less records than fact tables

Answer 44

Dimension table

Question 45

They don’t contain transactions rather they contain descriptive information like customer information addresses age

Answer 45

Dimension table

Question 46

The data contained in the dimension table are sometimes referred as

Answer 46

Master data

Question 47

This ensured that each row of data within the table is unique

Answer 47

keys

Question 48

keys can be

Answer 48

primary or foreign