Microsoft BI Online Training
MS-BI: Microsoft Business Intelligence (Online Training Materials is one of the best MICROSOFT BI Training institute)
Business Intelligence is a process or set of activities such as extracting the business data from various operational sources, transform and load the data into consolidated database or data ware house systems.
That consolidated data should be reported and analyzed to make better decisions in order to improve the organization.
Simply Business Intelligence is a broad category of applications and technologies for gathering, storing analyzing and providing access to data to help enterprise users make better business decisions.
BI applications include the activities of decision support systems, query and reporting. Online analytical processing, statistical analysis, forecasting and data mining.
Dimensional Data Model:
Dimensional data model is used in data ware housing systems that means designing facts, dimensions and hierarchy.
1. Dimension Table: The dimension table provides hierarchy and detailed information about the attributes.
For example: Dim product, Dim customer and Dim time etc.
2. Fact Table: A fact table is a table that contains measures.
Note: - Measure is a numerical value and it is key value to analyze your business data and it also evaluates the performance of the organization.
For example: Sales amount would be a measure. This measure stores in fact table.
The specification of levels that represents relationship between different attributes with in a dimension.
4. Dimension (Attribute):
A unique level with in a dimension is known as attribute.
For example: PID, P Name are attributes or dimensions in Dim product. (MICROSOFT BI Training is offered by Online Training Materials)