O'Reilly logo

Mastering SQL Server 2014 Data Mining by Debarchan Sarkar, Amarpreet Singh Bassan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Summary

In this chapter, we looked at the tools that we used to create a data warehouse, followed by designing an SSIS Package to transfer data from the staging table to the data warehouse table. We also created a data mart and then created a report based on it, thus covering the entire spectrum of Business Intelligence from data gathering to data analysis. This process is followed when we build the enterprise reporting, and the knowledge of the tools and tricks used at various stages will be useful as we proceed further in the book.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required