MS – BI : Microsoft Business Intelligence
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: BI applications include the activities of decision support systems, query and reporting, online analytical processing, statistical analysis, forecasting and data mining.
At TekSlate, we offer resources that help you in learning various IT courses. We avail both written material and demo video tutorials. To gain in-depth knowledge and be on par with practical experience, then explore MSBI Training Material.
Dimensional Data Model:
Dimensional data model is used in data ware housing systems that means designing facts, dimensions, hierarchy.
- Dimension table :
The dimension table provides hierarchy and detailed information about the attributes.
For Example: Dim product, Dim customer and Dim time etc.
- 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.
- Hierarchy: The specification of levels that represents relationship between different attributes with in a dimension.
Learn more about MSBI Interview Questions in this blog post.
One possible hierarchy in the time dimension is,
- 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.
For an Indepth knowledge on MSBI click on: