Pro SQL Server 2008 Analytics: Delivering Sales and Marketing Dashboards

Front Cover
Apress, May 23, 2009 - Business & Economics - 300 pages

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
  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

What people are saying - Write a review

User Review - Flag as inappropriate

I have not got on well with this book. Working along with chapter 1 I got zero rows returned by the examples, and looking at APress’s own errata list http://apress.com/book/errata/1153, I am not alone. The basic problem is that the example database is ridiculously complex: 345 tables and 364 views. I don’t mind fixing up some SQL, but this lot defeated me (and the authors, see errata list).
The book seems more “click, click, look pretty graph”, than explaining basis concepts.
 

Other editions - View all

About the author (2009)

Brian Paulen co-founded Madrona Solutions Group in July 2005. He has overall responsibility for the firm's growing business and for managing client and partner relationships. Brian has extensive project and program management experience and is an expert in delivering strategic sales and marketing solutions on various platforms. Prior to founding Madrona, Brian directed the CRM practice at Slalom Consulting. Earlier, he was a member of the CRM team at Equarius (now EMC), working primarily with clients in the Pacific Northwest. His career began at Accenture (formerly Andersen Consulting), working out of its New York office. Brian holds bachelor of arts degrees in political science and international business from Lehigh University in Pennsylvania.

Bibliographic information