If you've thought about implementing a Business Intelligence (BI) solution then you’ve likely also thought about data warehousing. In order to have an overall BI solution you need to have a place for the dispersed and varied databases to co-exist - this is your data warehouse. This is the key ingredient if you want consolidated information such as overall sales and market views.
As I mentioned in a prior post, Microsoft already provides the tools needed for a complete BI solution, tools which your company likely already owns and uses frequently. What I didn't elaborate on was the overall data warehousing capabilities that SQL Server provides.
Think about this - when you purchase a SQL Server 2012 license you get all of these:
1. SQL Server Analysis Services
2. SQL Server Reporting Services
3. SQL Server Integration Services
As well many other tools that are all part of SQL Server 2012. And of course it’s probably a tool that your organization already uses.
For BI and Data Warehousing it is clear that Microsoft is a leader and visionary, constantly expanding their offerings to help businesses turn mountains of data into valuable information. In fact, Gartner has just released their Magic Quadrant for Data Warehouse Database Management Systems and Microsoft is a Leader, gaining fast on previous market leaders.
Check out Gartner’s Magic Quadrant for Data Warehouse Database Management Systems here.