mobileNavlogo
headerlogo

MSBI (Microsoft Business Intelligence) Introduction

21 September, 2018

Ratings

Related Blogs

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.

Note:

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.

 For Example:

One possible hierarchy in the time dimension is,

1

  • 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:

About Author
Authorlogo
Name

TekSlate

Author Bio

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 .