| To become a good data warehouse expert with MS | | | | extraction) where the data is cleansed, like brought into |
| SQL server 2008, we need to first understand the | | | | a format that is standard across the DWH (this is |
| roles and responsibilities of a person in this job. That | | | | called transformation), then the data from the staging |
| too, when it comes to Microsoft SQL server suite, we | | | | area to the mart area. |
| need to first understand the various set of tools that | | | | The users can either directly query the data from the |
| come under the scope of MS BI. The basic features | | | | data mart using a suitable reporting environment or the |
| required for implementing business intelligence are the | | | | data from the data marts can be brought into online |
| SQL server database engine, MS SSIS, MS SSAS, | | | | analytical processing cubes and from there read |
| and MS SSRS. | | | | through either the Microsoft excel or using the ms |
| A data warehouse (DWH) is a collection of data, | | | | SQL server reporting services or using pro clarity |
| structured and designed for further querying, decision | | | | dashboard services. |
| making, data mining and knowledge discovery. A DWH | | | | It would be really helpful for a DWH expert to learn |
| consists of one or more data marts, the data in data | | | | more about the database administration and also |
| marts is brought from online analytical transaction | | | | some basic concepts of system administration. |
| system or any legacy based comma separated files | | | | A successful DWH professional would be able to |
| or any other flat files, the data is first brought from the | | | | gather requirements, design, develop and deploy a |
| source system to staging environment (this is called | | | | business intelligence solution. |