Implementing Business Intelligence with Microsoft SQL for Data Warehouse Prototype

Decision Support Technology

Table of Contents
1. Introduction.........................................................................................................................................3
2. Data warehouse with Microsoft SQL...................................................................................................3
3. Microsoft business intelligence............................................................................................................4
4. Data warehouse prototype...................................................................................................................5
5. Test plan of data warehouse.................................................................................................................5
6. Configure data connectivity.................................................................................................................6
7. Conclusion...........................................................................................................................................7
References...................................................................................................................................................8

1. Introduction
The main objective of this report to implement the business intelligence of data ware house
prototype by using the Microsoft SQL server. The business intelligence can be performing on
high business application tools can be used for cleansing, collecting, processing and analyzing of
the data. The evaluating and understanding the results is essential for the efficiency of decisional
system. Creating the knowledge of business intelligence and collecting form the data on internal
or external sources. Business intelligence is an entire concept can be implementing by the
decision support system. The decision support system can be used for the operation of
transactional system. The collecting the each data can used for databank and can processing of
resulting information can be stored on the data warehouse prototype. So the existing of DW was
necessary as the transactional database were unable to store the accumulated historical data. The
DW can be accessed by proper data analyzed and stored required data can preformed on the
prototype it will be investigated.
2. Data warehouse with Microsoft SQL
The SQL data warehouse is based on the cloud based enterprise data warehouse that can be
used for the leverages massively parallel processing (MPP) to can be quickly run complex
queries on the pet bytes of data. The data ware house is mainly used for the Analyzing of each
data can be stored on the database warehousing system (Berry, 2011). The source data can locate
on the Microsoft SQL server. The performing of the each data can be follows the steps includes
are,
 Pipeline data
 Export the data from SQL server
 Copy the data into blob storage
 Load data into sql data warehouse
The pipeline data that are used in the steps likewise,
 The export data on SQL server
 Copy the data files to move on Blob storage
 Loading the data on SQL data warehouse.
 Transforming data on the Datawarehourse prototype.
 Load the semantic model into analysis service (SQL server Data Tools)