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.
Dimensional Data Model:
Dimensional data model is used in data ware housing systems that means designing facts, dimensions, hierarchy.
The dimension table provides hierarchy and detailed information about the attributes.
For Example: Dim product, Dim customer and Dim time etc.
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.
Learn more about MSBI Interview Questions in this blog post.
One possible hierarchy in the time dimension is,
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:
You liked the article?
Like : 0
Vote for difficulty
Current difficulty (Avg): Medium
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.
Get stories of change makers and innovators from the startup ecosystem in your inbox