Home > Store

Smart Business Intelligence Solutions with Microsoft SQL Server 2008

Register your product to gain access to bonus material or receive a coupon.

Smart Business Intelligence Solutions with Microsoft SQL Server 2008

eBook

  • Sorry, this book is no longer in print.
  • Includes EPUB and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    Adobe Reader PDF The popular standard, used most often with the free Acrobat® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

Not for Sale

Description

  • Copyright 2009
  • Dimensions: 7-3/8" x 9"
  • Edition: 1st
  • eBook
  • ISBN-10: 0-7356-3053-4
  • ISBN-13: 978-0-7356-3053-6

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
  • Sample Content

    Table of Contents

    • Foreword
    • Acknowledgments
    • Introduction
    • Part I: Business Intelligence for Business Decision Makers and Architects
      • Chapter 1: Business Intelligence Basics
      • Chapter 2: Visualizing Business Intelligence Results
      • Chapter 3: Building Effective Business Intelligence Processes
      • Chapter 4: Physical Architecture in Business Intelligence Solutions
      • Chapter 5: Logical OLAP Design Concepts for Architects
    • Part II: Microsoft SQL Server 2008 Analysis Services for Developers
      • Chapter 6: Understanding SSAS in SSMS and SQL Server Profiler
      • Chapter 7: Designing OLAP Cubes Using BIDS
      • Chapter 8: Refining Cubes and Dimensions
      • Chapter 9: Processing Cubes and Dimensions
      • Chapter 10: Introduction to MDX
      • Chapter 11: Advanced MDX
      • Chapter 12: Understanding Data Mining Structures
      • Chapter 13: Implementing Data Mining Structures
    • Part III: Microsoft SQL Server 2008 Integration Services for Developers
      • Chapter 14: Architectural Components of Microsoft SQL Server 2008 Integration Services
      • Chapter 15: Creating Microsoft SQL Server 2008 Integration Services Packages with Business Intelligence Development Studio
      • Chapter 16: Advanced Features in Microsoft SQL Server 2008 Integration Services
      • Chapter 17: Microsoft SQL Server 2008 Integration Services Packages in Business Intelligence Solutions
      • Chapter 18: Deploying and Managing Solutions in Microsoft SQL Server 2008 Integration Services
      • Chapter 19: Extending and Integrating SQL Server 2008 Integration Services
    • Part IV: Microsoft SQL Server Reporting Services and Other Client Interfaces for Business Intelligence
      • Chapter 20: Creating Reports in SQL Server 2008 Reporting Services
      • Chapter 21: Building Reports for SQL Server 2008 Reporting Services
      • Chapter 22: Advanced SQL Server 2008 Reporting Services
      • Chapter 23: Using Microsoft Excel 2007 as an OLAP Cube Client
      • Chapter 24: Microsoft Office 2007 as a Data Mining Client
      • Chapter 25: SQL Server Business Intelligence and Microsoft Office SharePoint Server 2007
    • About the Authors

    Updates

    Submit Errata

    More Information

    InformIT Promotional Mailings & Special Offers

    I would like to receive exclusive offers and hear about products from InformIT and its family of brands. I can unsubscribe at any time.