Data Warehouse Administration requires SQL for implementing

In order to develop a good knowledge regarding data warehouse administration the first thing that needs to be found out is the type of work that is being handled by the person doing the job. The main features that are required to implement business intelligence are MS SSIS, the SQL server database engine, MS SSRS and MS SSAS.

A data warehouse is a complete set of data which is designed and structured for further decision making, querying, knowledge discovery and data mining. A data warehouse consists of one or more than one data marts. The data in data marts are bought from an online transaction system or from any other comma separated files or flat files. The data is initially brought from its source system to a staging environment called extraction. Here the data is completely cleansed and brought into a format which is common all over the data warehouse. This is known as transformation. The data that is transferred from the staging area towards the mart are known as the ETL stage. With the help of MS technology, this is conducted by using SSIS.

Users are able to query the data from data mart with the help of a reporting environment and then read either through MS Excel or use the MS SQL server 2008 reporting services. It would greatly help a data warehouse expert learn some more about database administration along with some basic system administration concepts. Once a data warehouse expert becomes successful, they will be able to design, develop, gather requirements and even arrange a business intelligence solution by making use of the MS BI Tool stack of SSAS, SSRS and SSIS. This is exactly what a professional data warehouse hosting do. To implement this, they will have to find a solution and a passion and also like SQL.