Microsoft BI Tools Snapshot

2

  •  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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s