Manage Your BI Infrastructure | MSBI Tutorial pdf

Manage Your BI Infrastructure

Microsoft SQL Server 2005 empowers your company by providing a security-enhanced, reliable, scalable, and productive platform for enterprise data management and business intelligence applications. BI enhancements within SQL Server 2005 help deliver an endto- end solution with integrated analytics including OLAP; data mining; extract, transformation, and load (ETL) tools; data warehousing; and reporting functionality.

SQL Server 2005 Integration Services
Microsoft SQL Server 2005 Integration Services (SSIS) offers a redesigned and highly scalable enterprise ETL platform for building high-performance data integration solutions for data warehousing. As a result, you get a more holistic understanding of your business.
=> Rich development environment uses Microsoft Visual Studio 2005 as a collaborative stage for dependable and relevant solutions.
=> Visual debugging tools help you set breakpoints on packages, containers, task events, and data viewers for watching data as it moves through the data flow.
=> Data quality tools such as Fuzzy Lookup and Fuzzy Grouping components provide inexact matching and de-duplication.
=> Extensible architecture includes a completely rewritten object model that makes extending and programming packages easier, more flexible, and more powerful.
=> Out-of-the-box, high-performance transformations include a great range of productive and powerful components such as data and character conversions, calculated columns, conditional operations for partitioning and filtering, lookups, sorting, aggregation, and merges.

SQL Server Business Intelligence Development Studio
Business Intelligence Development Studio offers the first integrated development environment designed specifically for the BI developer. Built on Visual Studio 2005, Business Intelligence Development Studio delivers a rich, integrated platform for developing business intelligence applications.
=> Solution Explorer helps you manage all your different projects in a solution from a single window.
=> The Properties window enables you to view and change the properties of objects, such as packages, that are open in editors and designers.
=> The Designer window helps you create or modify business intelligence objects and provides both a code view and a design view of an object.
=> Simple customization provides easy-to-use configurations that suit your working style.
=> Project templates for SQL Server Analysis Services, Integration Services, and Reporting Services provide a context for developing specific constructs.

SQL Server 2005 Analysis Services
Microsoft SQL Server 2005 Analysis Services (SSAS) data mining and OLAP capabilities help you build complex analytical models that you can integrate with your business operations. Easy to use, extensible, and flexible capabilities make data mining more accessible than ever before.
=> Unified Dimensional Model provides a central metadata repository defining business entities, business logic, calculations, and metrics.
=> Data mining algorithms help you discover patterns and uncover business data to reveal hidden trends.
=> Proactive caching delivers a highly compressed and optimized data cache that is automatically maintained as the data in the underlying source databases changes.
=> Advanced BI capabilities such as KPIs, translations, semi-additive measures, and multi-dimensional expressions (MDX) scripts help improve your decisionmaking.

SQL Server 2005 Reporting Services
SQL Server 2005 Reporting Services (SSRS) offers a complete and comprehensive reporting solution for creating, managing, and delivering traditional managed reports, interactive end-user reports, and embedded reports.
=> Report authoring uses a graphical report designer tool with easy-to-use report wizards.
=> Embedded reports use client-side reporting controls to embed real-time reports into an application at design time.
=> Report Builder provides an ad hoc reporting tool that enables business users to create their own reports and explore corporate data.
=> SharePoint integration provides out-of-the-box Web Parts to deliver reports directly in Office SharePoint Server 2007.
=> Management Studio enables administrators to organize reports and data sources, schedule report execution and delivery, and track reporting history.
=> Flexible and extensible reporting for both traditional and interactive reports offers numerous formats with extensible delivery options.
=> Scalability enables SQL Server 2005 to support high-volume environments.

Relational Data Warehouse
SQL Server 2005 offers a security-enhanced, scalable, and highly available relational database engine with improved performance and support for structured and unstructured XML data.
=> Table and index partitioning enables fast data load and simplified maintenance for large tables.
=> Online index operations help you create, rebuild, or drop an index online.
=> Enhanced Transact-SQL (T-SQL) language capabilities offer error handling, recursive queries, and XML support.
=> Database mirroring provides a quick standby system for high availability. 

=> Database snapshots create quick, read-only views of a database.
=> Snapshot isolation enables read operations to access the last-committed row even if a write operation has the row locked for an update at that time.
=> Support for 64-bit opens the door to new levels of application scalability.
=> SQL Server Management Studio helps you operate and maintain BI database objects.