Microsoft Business Intelligence

What is Business Intelligence? The Process of converting raw data into useful information using set of tools which helps an organisati...

Linked Dimension: This dimension joins different fact tables from two or more cubes Conformed Dimension: This dimension joins multiple fac...

This occurs when a dimension references itself by a primary and a foreign-key relationship in the same dimension. Example: Dim_A -> Dim...

Sometimes we need to analyze our data based on the some specific value which are available only at fact table. In this case, the particular ...

Data modelling: Modelling data storage optimized for Transactional Processing is Data Modelling Dimensional modelling: Modelling data st...

Conformed dimension is a dimension that has a single meaning or content throught datawarehouse.we can use it accross the fact tables Exam...

Role Playing dimension is a dimension, it can play different roles in a fact table depending on the context. For example: Date dimension ...

A junk dimension is a collection of random transcational codes flags and text attributes that are unrelated to any particular dimension.The ...

Operational Data Store(ODS) Data warehouse ODS is an Online integration of data Typically it wo...

Data warehouse is repository of data, which are collected from many sources like transactional database or old backup data, etc., and then f...

Dimensions are classified as followings: 1. Slowly Changing Dimensions or SCD (Type0,Type1,Type2,Type3,Type4,Type6) 2. Slowly Growing Di...

Conceptual Data Model Identifies the highest level of relationship between important entities of Data Model. It contains only important enti...

It is a dimension which is derived from fact table. DD doesn’t have separate dimension table. It is mostly used when we planned use transact...

Preparing ER Data Model ER à split into discrete business process Model Each Process separately Select Many to many relationsh...

It is integral companion to the fact table It contain descriptive information of the business Each dimension is defined by its single prim...

Conformed dimension are the bus architecture linking different data mart It is a dimensional model with common dimension linking to differe...

It is a primary table of a dimension model It contains numerical information of the business It contains aggregate values of duplicating r...

All information about the data warehouse environment It is not actual data It is similar to databank It is similar to Encyclopedia

Storage area + ETL It is everything between Transaction and data presentation area It cannot be accessed by the users directly, merely for...

Understand your users by business area & Job responsibility Determine the decisions the business users want to make with the help of DW...