- SQL Server Management Studio (SSMS)
-Manage database schema
– Write & execute queries
– Stored Procedures
- SQL Server Integration Services (SSIS)
– Extract, Transform and Load (ETL) data
– Updating data warehouses
– Cleaning and mining data
– Creating “packages”
– A series of tasks of manipulating the input data
– Can take a variety of sources
– XML, flat files, relational data sources
- SQL Server Analysis Services (SSAS)
– Design, create and manage multidimensional structures with
data that is aggregated from multiple sources
– Data cubes
-Analysis by data mining
- SQL Server Reporting Services (SSRS)
– Server-based reporting platform
– Publish reports to a report server, or Microsoft Windows application or to a Sharepoint site.
– Can schedule reports to run
– Users can subscribe to reports
– Reports (.rdl files) can be exported to a variety of formats
– Excel, PDF, CSV, XML, Word
Business Intelligence A - Z 