In order to improve business intelligence capabilities, organizations must effectively and securely manage data across a myriad of platforms. SQL Server Integration Services allows for the automation of complex migration tasks, SQL Server Reporting Services augments SQL Server and other database management systems to deliver business-critical reports to customers, and SQL Server Analysis Services provides the administrative tools to better manage and maintain data through the creation of On-Line Analytical Processing (OLAP) cubes. Skilled SQL Server developers, administrators and analysts can maximize the business intelligence value gained from incorporating these tools.
In this course you learn to leverage SQL Server 2008 Reporting Services to mine business intelligence from your data. You gain the knowledge to design reports and display your data graphically with enhanced visualization features, integrate parameters, filters and interactive components into report design, and safeguard reports with Windows authentication.
This course provides the skills to migrate and transform data with SQL Server Integration Services. You learn to solve data management problems by creating dynamic packages for migrating, processing, and reporting on data for business intelligence. Specifically, you learn to upgrade DTS packages and perform imports and exports, assemble tasks to perform complex data migrations and enhance package functionality with scripting.
In this course, you gain the skills to analyze and discover trends in your data warehouse. You learn to create OLAP cubes, build custom solutions with Multidimensional Expressions (MDX), make smarter business decisions with data mining techniques, and implement Key Performance Indicators (KPIs) to monitor business objectives.
