SQL SERVER 2005
SQL Server 2005 will have a significant impact on the BI landscape through innovations in scalability, data integration, development tools and rich analytics. The comprehensive integration, analysis and reporting capabilities enable companies to extend the value of their existing applications, regardless of the underlying platform.
SQL Server 2005 enables customers to get more value from their data by including embedded functionality such as reporting, analysis and data mining, with integration with familiar tools like Office.
End-to-End Integrated BI Platform
Design
BI Development Studio is the first integrated development environment designed for the BI developer. Debugging, source control and script and code development are available for all components of the BI platform
Integrate
SQL Server Integration Services (SSIS) performs complex data integration, transformation and synthesis at high speed for very large data volumes.
Analyse
New analytical capabilities have been added to Analysis Services cubes including Key Performance Indicator (KPI) Framework, MDX scripts and other built in advanced business analytics.
Report
Reports can be personalised and delivered in a variety of formats, with a range of interactivity and printing options.
Manage
SQL Server Management Studio integrates the management of all SQL Server 2005 components.