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...

1. Named Query is a SQL Statements and it act as a another table 2. It is formed by selecting rows and columns from single tables or relat...