Chapter 2

Question 1

it is a collaborative effort that involves multiple teams from multiple departments constantly communicating with each other.

Answer 1

Business analytics Implementation

Question 2

is the starting point of an implementation, which will dictate which data will actually be conducive for the desired analysis.

Answer 2

Determining the information

Question 3

what are the three major components of the system landscape?

Answer 3

Data sources
Enterprise data warehouse
Reporting and analysis tools

Question 4

three main categories of
data sources in an Enterprise.

Answer 4

ERP systems
Other databases
Flat files

Question 5

it is where an enterprises data is fed into and all reports are obtained directly from it

Answer 5

ERP System

Question 6

makes extensive use of Master Data to help keep track of Business Partners and Items.

Answer 6

ERP System

Question 7

Usually the maintenance of these is assigned to key people, who will be the ones to manage the creation of new Master Data or the updating of such.

Answer 7

ERP system

Question 8

due to geographical or cost constraints, a branch of the company might be physically
impossible to connect to the corporate network.

Answer 8

Other databases

Question 9

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

Answer 9

Flat files

Question 10

Delimited text files are usually either

Answer 10

Tab-delimited
Comma-separated value files (CSV)

Question 11

is needed in order to work around these limitations.

Answer 11

Enterprise Data Warehouse

Question 12

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

Answer 12

Enterprise Data Warehouse

Question 13

is concerned with
delivering “a single version of the truth”.

Answer 13

Consolidating Data

Question 14

New hardware that will become the server hosting the Data Warehouse. It must be connected to the

Answer 14

Corporate Network

Question 15

A dedicated project team from the Enterprise Side made up of

Answer 15

Business Users

Question 16

is a tool to help build Data Warehouses,

Answer 16

SAP Business warehouse

Question 17

is essentially a large Database, it is likely that technical column names are still used instead of more common, Business-friendly terms.

Answer 17

Enterprise Data Warehouse

Question 18

is set up as a sort of “translator” so that the Business User can immediately understand what the data is, by allowing them to see technical terms as business terms.

Answer 18

Semantic Layer

Question 19

what are the 3 tier architecture

Answer 19

Development (DEV)
Quality Assurance (QAS)
Production ( PRD)

Question 20

is the most critical of the three, as it contains “live data”.

Answer 20

PRD

Question 21

It is the system that is used in the day-to-day transactions of the company. A lot of redundancies might be required for this landscape, as it is needed for the proper function of the enterprise.

Answer 21

PRD

Question 22

its physical hardware tends to be the most powerful of the three. Downtime for it must be reduced as much as possible due to its operational importance.

Answer 22

PRD

Question 23

as its name states, is for development purposes.

Answer 23

DEV

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

DEV

Question 25

or the configuration does not result in catastrophic failure, they will be rolled up and applied/promoted to ?

Answer 25

QAS

Question 26

Other enterprises has a 4th, off-premises landscape known as

Answer 26

Disaster Recovery ( DR )

Question 27

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

Answer 27

Disaster Recovery

Question 28

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

Answer 28

Disaster Recovery

Question 29

examples of data reliability inconsistencies

Answer 29

Inconsistent Terminology Round Errors and Truncation Nulls and Zeroes Incorrect Inputs Outright Data Discrepancies

Question 30

department might refer to an SKU as a

Answer 30

Product or material

Question 31

Consider the number of decimal places a given piece of numeric data has.

Answer 31

Rounding errors and truncation

Question 32

This could cause final numbers to deviate from the source.

Answer 32

Rounding Errors

Question 33

have the same effect, however, instead of rounding the number, decimal places are outright omitted

Answer 33

Truncation

Question 34

Null Values represent

Answer 34

Nothing

Question 35

this is where the concept of “Garbage In, Garbage Out” is very apparent.

Answer 35

Incorrect Inputs

Question 36

A company usually has some tactical decisions where promos and bundles of their products and services will be joined together

Answer 36

Outright Data Discrepancies

Question 37

is the first data model that can be fully described mathematically. All data (fields/columns) is represented in terms of tuples (rows/record), grouped into relations.

Answer 37

Relational Model

Question 38

can be obtained from multiple tables to produce one tuple of data by JOINing tables via their keys.

Answer 38

Data

Question 39

initially pushed as the standard language for relational databases

Answer 39

SQL

Question 40

Three tables example

Answer 40

TXN CUS_MAS PROD_MAS

Question 41

initially pushed as the standard language for relational databases

Answer 41

SQL

Question 42

stores all customer information.

Answer 42

CUS_MAS

Question 43

stores all product information.

Answer 43

PROD_MAS

Question 44

is a representation of the abstract structure of domain information.

Answer 44

Schema or logical data model

Question 45

It is often expressed as a diagram, and is used as foundation to designing database structures.

Answer 45

Schema

Question 46

There are many different kinds of schemas, but the most-commonly used one in enterprise computing is the

Answer 46

Star Schema

Question 47

It is comprised of a Fact Table (usually just one) referencing any number of Dimension Tables.

Answer 47

Star Schema

Question 48

records measurements for a specific event

Answer 48

Fact Table

Question 49

by contrast will contain less records than Fact Tables.

Answer 49

Dimension Table

Question 50

The data contain in dimension table are sometimes referred to as

Answer 50

Master Data

Question 51

ensure that each row of data within the table is unique.

Answer 51

Keys

Question 52

columns that automatically increment, the more rows are populated, using some sort of algorithm

Answer 52

ID

Question 53

Types of keys

Answer 53

Primary or foreign

Question 54

Is to maintain a separate database that records all transactions for the day

Answer 54

Work around

Question 55

One of the defining features today in Business Analytics Tools is what’s called

Answer 55

Self-Service BI.

Question 56

is made available to the market to test its viability

Answer 56

trial run

Question 57

SQL Meaning

Answer 57

stuctured query Language

Question 58

It is the most common way to store and access enterprise data, as it uses some form of Structured Query Language

Answer 58

Relational Model