Pro SQL Server 2008 Analytics

Delivering Sales and Marketing Dashboards

By Brian Paulen , Jeff Finken

Pro SQL Server 2008 Analytics Cover Image

Pro SQL Server 2008 Analytics provides everything you need to know to develop sophisticated and visually appealing sales and marketing dashboards using SQL Server 2008 and to integrate those dashboards with SharePoint, PerformancePoint, and other key Microsoft technologies.

Full Description

  • ISBN13: 978-1-4302-1928-6
  • User Level: Intermediate
  • Publication Date: May 24, 2009
  • Available eBook Formats: PDF
  • Print Book Price: $49.99
  • eBook Price: $34.99
Buy eBook Buy Print Book Add to Wishlist

Related Titles

Full Description

Pro SQL Server 2008 Analytics provides everything you need to know to develop sophisticated and visually appealing sales and marketing dashboards using SQL Server 2008 and to integrate those dashboards with SharePoint, PerformancePoint, and other key Microsoft technologies.

The book begins by addressing the many misconceptions that surround the use of key performance indicators (KPIs) and giving a brief overview of the business intelligence (BI) and reporting tools that can be combined on the Microsoft platform to help you generate the results that you need.

The focus of the book is to help you implement a successful business intelligence project of your own. The text discusses many of the required project planning components, provides overviews and examples associated with Microsoft’s BI tools, and gives detailed examples of successful dashboard implementations.

What you’ll learn

  • The key functional and technical components of a successful report/dashboard implementation
  • What Microsoft tools are provided both within and without SQL Server 2008 to help you achieve an integrated solution
  • How to determine whether your performance indicators are correct for your business and how to roll them out to your organization in an effective way

Who this book is for

This book is for entrepreneurs, technologists, and developers who want to bring clear–cut, reliable reporting into their organization. No prior experience of building analytics and reporting dashboards is required, but basic familiarity with SQL Server 2008 is assumed.

Table of Contents

Table of Contents

  1. An Overview of Analytics
  2. Seven Keys to Successful Reporting Projects
  3. Key Performance Indicators
  4. Microsoft Platform Components for Dashboards
  5. Core Components of SQL Server 2008
  6. SQL Server Analysis Services
  7. Performance Management
  8. Implementation and Maintenance of the Integrated System
  9. Case Studies
Source Code/Downloads

Downloads are available to accompany this book.

Your operating system can likely extract zipped downloads automatically, but you may require software such as WinZip for PC, or StuffIt on a Mac.

Errata

Please Login to submit errata.

On page 67:

Step 13
the SQL code has an error in it.

The substring code to get the Currency Symbol has a syntax error.

(same error in the Group By clause as well)

On page 69:
SQL Error

Step 15

DATEPART is missing for line 10 of the SQL code