BI Application

Get Started. It's Free
or sign up with your email address
Rocket clouds
BI Application by Mind Map: BI Application

1. Back End (ETL)

1.1. Data Mapping

1.1.1. Data source

1.1.1.1. Flat files

1.1.1.2. On Line Transaction Processing

1.1.1.3. Web Services

1.1.1.4. Backups

1.1.2. Staging

1.1.3. Formulas

1.1.3.1. Nulls

1.1.3.2. Zeros

1.1.3.3. Lookups

1.1.4. Data Warehouse

1.1.5. Reports

1.2. Metadata

1.2.1. Data Type

1.2.1.1. Char/String

1.2.1.1.1. Length

1.2.1.2. Number

1.2.1.2.1. Precision

1.2.1.3. Kanji

1.2.1.4. UTF-8

1.2.2. Constraint

1.3. Data Dictionary

1.3.1. Nulls/ Default Values

1.3.2. Unique Key

1.3.3. Referential Integrity (PK-FK relationship)

1.3.4. Surrogate keys

1.3.5. Natural keys

1.3.6. Tracking

1.3.6.1. Source System

1.3.6.2. Date/Time

1.3.6.3. User

1.4. Job

1.4.1. Logging

1.4.2. Parallel Execution & Precedence

1.4.3. ETL Pull Logic

1.4.3.1. Full

1.4.3.2. Incremental (Delta)

1.4.3.2.1. Insert

1.4.3.2.2. Update

1.4.3.2.3. Delete

2. Front End (Reports)

2.1. Drill Down/Drill Through

2.2. layout

2.3. prompts

2.4. sorting

2.5. export

2.6. subtotals

2.7. lowest granularity

2.8. charts

3. First thing first

3.1. Software Development Life Cycle

3.1.1. Requirement gathering and analysis

3.1.2. Design

3.1.3. Implementation or coding

3.1.4. Testing

3.1.5. Deployment

3.1.6. Maintenance