Please enable JavaScript.
Coggle requires JavaScript to display documents.
Information Needs & Generic DWH (Information Needs Analysis…
Information Needs & Generic DWH
Information Needs Analysis
Background
analytical information systems support decision-making
History analytical Information Systems
MIS
DSS
EIS
DWH
BI
Business Intelligence
utilize data and databases to support management
Real-time BI
large data sources Big Data
Internet of Things
fast changing market with short reaction time
Model of the Information Subsets
Information Supply
as-is analysis of data
current available data
check reports
Objective Information Needs Analysis
needs of the company
goals and company objectives
Subjective Information Needs Analysis
information needs voiced by an organization
or specific person
data which is collected by person
Strategy and Objectives
Top-Level Objectives
vision, mission
corporate identity
policies and practices
Operational Objectives
general goals
organizational unit goals
business unit goals
marketing-mix goals
Need of information in the right time for the right person
Reference Objects, Ratios and Facts
Reference Objects
business objects differentiated functionally
object that get financial and quantitative values attributed
e.g. Company (World, US, State), Products (Vehicles, Cars, Electronics, TV), Time
Facts and Navigation Spaces (Cubes)
Dimension Tuple (Cube)
Fact is combination of ration (measure) and reference object (business object)
Generic DWH
practical database scheme for all companies
7 basic reference objects, never more than 10
normal schemas are star or snowflake schemas
Becker's
Generic DWH Schema
only 9 tables in every database schema
Reference Object
ID, Name, Dimension_ID
Ratio
ID, Name
Fact
ID, ReferenceObject_ID, FactValue
Dimension
ID, Name
Ratio System
CO_Ratio_ID, S_Ratio, Algorithm
Dimension combination
CO_D_ID, S_D_ID
Dimension hierarchy
Parent_ID, Child_ID
Reference object combination
Co_RO_ID, S_RO_ID
Reference object hierarchy
Parent_ID,Child_ID