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 Microsofts BI tools, and gives detailed examples of successful dashboard implementations.

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

Customer Reviews & Comments
I referred to this book while doing a prototype in building a Sales dashboard for a company. It gave me a jump start in using Microsoft technologies to come up with a dashboard in a short time. To be honest this is the first book I am referring to on this task. Especially I liked the case studies chapter at the end of the book to be very helpful. The chapters provide covers well on details around SQL Server analytics but I was looking for examples in each chapter to get me though. But this book solved it's purpose for me. I will recommend this book to other like me who want to start working on dashboards and analytics using SQL Server tools.

Back To Top