文件名称：Smart Business Intelligence Solutions with Microsoft SQL Server 2008 Feb 2009
文件大小：21.82MB
文件格式：PDF
更新时间：2013-04-21 10:28:40
SQLServer2008
Smart Business Intelligence Solutions with Microsoft SQL Server 2008 Discover how to: Manage the development life cycle and build a BI team Dig into SQL Server Analysis Services, Integration Services, and Reporting Services Navigate the Business Intelligence Development Studio (BIDS) Write queries that rank, sort, and drill down on sales data Develop extract, transform, and load (ETL) solutions Add a source code control system Help secure packages for deployment via encryption and credentials Use MDX and DMX Query Designers to build reports based on OLAP cubes and data mining models Create and implement custom objects using .NET code View reports in Microsoft Office Excel® and Office SharePoint® Serverook Part I Business Intelligence for Business Decision Makers and Architects 1 Business Intelligence Basics 3 2 Visualizing Business Intelligence Results 27 3 Building Effective Business Intelligence Processes 61 4 Physical Architecture in Business Intelligence Solutions 85 5 Logical OLAP Design Concepts for Architects 115 Part II Microsoft SQL Server 2008 Analysis Services for Developers 6 Understanding SSAS in SSMS and SQL Server Profler 153 7 Designing OLAP Cubes Using BIDS 183 8 Refning Cubes and Dimensions 225 9 Processing Cubes and Dimensions 257 10 Introduction to MDX 293 11 Advanced MDX 329 12 Understanding Data Mining Structures 355 13 Implementing Data Mining Structures 399 Part III Microsoft SQL Server 2008 Integration Services for Developers 14 Architectural Components of Microsoft SQL Server 2008 Integration Services 435 15 Creating Microsoft SQL Server 2008 Integration Services Packages with Business Intelligence Development Studio 463 16 Advanced Features in Microsoft SQL Server 2008 Integration Services 497 17 Microsoft SQL Server 2008 Integration Services Packages in Business Intelligence Solutions 515 18 Deploying and Managing Solutions in Microsoft SQL Server 2008 Integration Services 539 19 Extending and Integrating SQL Server 2008 Integration Services 567 Part IV Microsoft SQL Server Reporting Services and Other Client Interfaces for Business Intelligence 20 Creating Reports in SQL Server 2008 Reporting Services 603 21 Building Reports for SQL Server 2008 Reporting Services 627 22 Advanced SQL Server 2008 Reporting Services 647 23 Using Microsoft Excel 2007 as an OLAP Cube Client 671 24 Microsoft Offce 2007 as a Data Mining Client 687 25 SQL Server Business Intelligence and Microsoft Offce SharePoint Server 2007 723