Smart Business Intelligence Solutions with Microsoft SQL Server 2008
Get the end-to-end instruction you need to design, develop, and deploy more effective data integration, reporting, and analysis solutions using SQL Server 2008—whether you’re new to business intelligence (BI) programming or a seasoned pro. With real-world examples and insights from an expert team, you’ll master the concepts, tools, and techniques for building solutions that deliver intelligence—and business value—exactly where users want it.\ Discover how to:\ \ Manage the development life...
Search in google:
Get the end-to-end instruction you need to design, develop, and deploy more effective data integration, reporting, and analysis solutions using SQL Server 2008—whether you’re new to business intelligence (BI) programming or a seasoned pro. With real-world examples and insights from an expert team, you’ll master the concepts, tools, and techniques for building solutions that deliver intelligence—and business value—exactly where users want it.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
ForewordAcknowledgmentsIntroductionPart I: Business Intelligence for Business Decision Makers and ArchitectsChapter 1: Business Intelligence BasicsChapter 2: Visualizing Business Intelligence ResultsChapter 3: Building Effective Business Intelligence ProcessesChapter 4: Physical Architecture in Business Intelligence SolutionsChapter 5: Logical OLAP Design Concepts for ArchitectsPart II: Microsoft SQL Server 2008 Analysis Services for DevelopersChapter 6: Understanding SSAS in SSMS and SQL Server ProfilerChapter 7: Designing OLAP Cubes Using BIDSChapter 8: Refining Cubes and DimensionsChapter 9: Processing Cubes and DimensionsChapter 10: Introduction to MDXChapter 11: Advanced MDXChapter 12: Understanding Data Mining StructuresChapter 13: Implementing Data Mining StructuresPart III: Microsoft SQL Server 2008 Integration Services for DevelopersChapter 14: Architectural Components of Microsoft SQL Server 2008 Integration ServicesChapter 15: Creating Microsoft SQL Server 2008 Integration Services Packages with Business Intelligence Development StudioChapter 16: Advanced Features in Microsoft SQL Server 2008 Integration ServicesChapter 17: Microsoft SQL Server 2008 Integration Services Packages in Business Intelligence SolutionsChapter 18: Deploying and Managing Solutions in Microsoft SQL Server 2008 Integration ServicesChapter 19: Extending and Integrating SQL Server 2008 Integration ServicesPart IV: Microsoft SQL Server Reporting Services and Other Client Interfaces for Business IntelligenceChapter 20: Creating Reports in SQL Server 2008 Reporting ServicesChapter 21: Building Reports for SQL Server 2008 Reporting ServicesChapter 22: Advanced SQL Server 2008 Reporting ServicesChapter 23: Using Microsoft Excel 2007 as an OLAP Cube ClientChapter 24: Microsoft Office 2007 as a Data Mining ClientChapter 25: SQL Server Business Intelligence and Microsoft Office SharePoint Server 2007About the Authors
