What is MSBI ? Introduction About MSBI? What is SSIS,SSAS and SSRS in MSBI.

What is MSBI ? Introduction About  MSBI? What is SSIS,SSAS and SSRS in MSBI.

MSBI is stands for Microsoft Business Intelligence, Business Intelligence is the is the set of techniques and tools for the transforming of raw data into meaningful and useful information for Business Analysis Process ,this can helps to make quick decisions.

MSBI Tools:

MSBI contains three tools ,they are  SSIS(ETL),SSAS(Analysis) and SSRS(Reporting).

We can use these tools with the interface of Microsoft Visual Studio.

The following figure provides a working model of a MSBI Project

SSIS,SSAS and SSRS

SQL Server Integration Services (SSIS): SSIS is the ETL tool from Microsoft, it is the platform for integration and workflow solutions, SSIS including extraction, transformation and loading (ETL) operations for data warehousing.

We can process the data from various locations and various formats (flat file, excel file ,database objects, etc ) and save the data into a centralized repository as a Data Warehouse.
SQL Server Analysis Services (SSAS):

Sql Server Analysis Services is the process of converting two dimensional (OLTP) data into multi-dimensional data model (OLTP). This will help you to analyze the large volume of data.

NOTE: in SSIS we have large amount of data then we need to change it into multidimensional data, in that case we will use this SSAS Tool.

SQL Server Reporting Services(SSRS)SQL Server Reporting Services is an enterprise reporting platform supporting traditional and interactive reports delivered over the web or through custom applications. It supports various data sources like two dimensional and multi-dimensional data .

Tags: MSBI Introduction definition, MSBI Introduction, key points while creating MSBI Introduction, What is MSBI ? Introduction About  MSBI? What is SSIS,SSAS and SSRS in MSBI, What is SQL Server Integration Services (SSIS), What SQL Server Analysis Services (SSAS), What is SQL Server Reporting Services(SSRS),real time interview questions.

[Continue reading...]

What is Primary key Definition in Sql server , and how to create Primary Key in Sql Server ?

What is Primary key Definition in Sql server ,and how to create Primary Key in Sql Server ?

Definition of Primary Key :

Primary Key is a field in Relational Database Table that can Uniquely identified every record in the table.

Key Points :

-The Primary Key act as a Unique + Not Null Keys in Relational Database.

-The Primary doesn't  allows Null values and Duplicated values(repeated values) 

- We can create only one Primary Key for a table (entire table).

-When we create Primary key then it will automatically create Clustered Index for a table.

-Tables having primary key constraint are called as master tables(or) parent tables.

-in a table, a primary key can hold maximum of 32 columns(not  rows). 

-we can create primary key for table two ways .

          1.at the time of creating table (create table statement).

          2.at the time of (Alter)modifying table(alter table statement).

how to create primary key at table level and alter level go to next page.

Tags: Primary Key definition, How to create Primary Key, key points while creating Primary Key, What is Primary key Definition in Sql server , Primary Key is a field in Relational Database Table that can Uniquely identified every record in the table ,how to create Primary Key in Sql Server, primary key , foreign key, unique key, 

[Continue reading...]