• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

MSBI (Microsoft Business Intelligence) Introduction

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:

Summary
Review Date
Reviewed Item
MSBI (Microsoft Business Intelligence) Introduction
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on MSBI (Microsoft Business Intelligence) Introduction"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.