Pro SQL Server 2008 Analytics : Delivering Sales and Marketing Dashboards

  • ISBN13:


  • ISBN10:


  • Edition: 1st
  • Format: Paperback
  • Copyright: 2009-05-18
  • Publisher: Springer-Verlag New York Inc

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Purchase Benefits

  • Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $49.99 Save up to $31.99
  • Buy Used
    Add to Cart Free Shipping


Supplemental Materials

What is included with this book?


When implementing an analytics solution, the primary goal is to give corporate decision makers and information workers the right information, in the right format, at the right time. This enables them to take actions that will lead to the attainment of corporate objectives. Attaining this goal requires that companies meet the challenges of clearly understanding what metrics are critical to grow and manage the business, selecting and implementing appropriate technologies, and recognizing that analytics initiatives require continual improvement to keep up with changes in the business.

Table of Contents

Forewordp. ix
About the Authorsp. xi
About the Technical Reviewerp. xiii
Acknowledgmentsp. xv
An Overview of Analyticsp. 1
Understanding Analyticsp. 1
The Value of Analyticsp. 2
Why Analytics Implementations Failp. 2
Environment Preparationsp. 4
Summaryp. 22
Seven Keys to Successful Reporting Projectsp. 23
The Seven Keys Approachp. 23
Developing Executive Sponsorshipp. 23
Department Managersp. 24
Senior Executivesp. 24
Identifying Organizational Key Performance Indicatorsp. 24
Delivering Structured, Ad Hoc Reportsp. 25
Selecting Appropriate Technologiesp. 25
Reviewing the Appropriate Microsoft BI Tools for Various User Rolesp. 27
Identifying and Prioritizing Final Phase-One Solution Componentsp. 30
Ensuring Data Availabilityp. 32
Proactively Reviewing Data Qualityp. 33
Adjusting Core System Business Rulesp. 33
Delivering Organization-wide Performance Managementp. 34
Summaryp. 35
Key Performance Indicatorsp. 37
Keeping KPIs Forward Lookingp. 37
Understanding the Core Principles for KPIsp. 39
Using Specific Metricsp. 39
Ensuring Clear Metric Ownershipp. 40
Keeping Metrics Measurablep. 40
Using Timely Metricsp. 40
Limiting the Quantity of KPIs for a Given Scorecardp. 40
Assigning Targets to KPIsp. 41
Aligning the KPI with Organizational Goalsp. 41
Developing a KPI Step By Stepp. 41
Assembling a Team to Define KPIsp. 42
Categorizing Potential Metricsp. 42
Brainstorming Possible Metricsp. 43
Prioritizing Draft Metricsp. 43
Performing a Final Filter on Metricsp. 46
Setting Targets for Selected Metricsp. 49
Combining the KPIs into a Scorecardp. 51
Summaryp. 51
Microsoft Platform Components for Dashboardsp. 53
Understanding the Analytics Pyramidp. 53
Creating Basic Analyticsp. 54
Mapping KPIs to Source Systemsp. 55
Identifying Specific Analytics Stakeholdersp. 58
Prioritizing Scorecards and Reportsp. 59
Developing Initial Reports and Dashboardsp. 61
Moving into Intermediate Analyticsp. 80
Developing a Basic Analysis Services Cubep. 81
Designing an Approach to Deliver Trend Datap. 95
Developing Your Data Mart and SSAS Cubep. 95
Evaluating Limitations in Your BI Platformp. 96
Considering Advanced Analyticsp. 96
Summaryp. 97
Core Components of SQL Server 2008p. 99
Developing a Sales Manager Dashboardp. 100
Developing the Marketing Campaign Dashboardp. 121
Summaryp. 141
SQL Server Analysis Servicesp. 143
Understanding Sales Trendsp. 144
Identifying the Sales Trend Measuresp. 145
Identifying the Sales Trend Dimensionsp. 145
Tracking Search Engine Marketingp. 157
Indentifying the SEM Measuresp. 158
Identifying the SEM Dimensionsp. 158
Summaryp. 170
Performance Managementp. 171
Defining "Performance Management"p. 171
Managing Sales Performancep. 173
Creating the Dashboard Displayp. 173
Drilling into the KPI Detailsp. 179
Managing Marketing Performancep. 185
Summaryp. 193
Implementation and Maintenance of the Integrated Systemp. 195
Understanding the Project Management Phasesp. 195
Beginning with the Envisioning Phasep. 196
Identifying the Project Scopep. 197
Calculating the ROIp. 197
Selecting the Project Scopep. 198
Planning the Projectp. 199
Initiating the Design Phasep. 203
Designing the Schemap. 203
Designing the User Interfacep. 204
Developing Use Casesp. 205
Working Through the Build Phasep. 206
Moving into the Test Phasep. 206
Releasing the Solution During the Deployment Phasep. 208
Training Various Resourcesp. 209
Releasing the Solutionp. 209
Maintaining the Systemp. 212
Performing Core Maintenancep. 213
Moving Past the Initial Implementationp. 214
Performing Overall Project Management Tasksp. 217
Categorizing Project Management Tasksp. 217
Using SharePoint As a Project Management Toolp. 220
Summaryp. 221
Case Studiesp. 223
Reporting in a Hosted Business Application Environmentp. 223
Identifying the Customer's Challengesp. 223
Exploring the Solutionp. 224
Seeing the Resultsp. 234
Implementing Embedded Analyticsp. 235
Identifying the Customer's Challengesp. 236
Exploring the Solutionp. 236
Seeing the Resultsp. 243
Adding Web Analyticsp. 244
Identifying the Customer's Challengesp. 245
Exploring the Solutionp. 246
Seeing the Resultsp. 247
Summaryp. 249
Indexp. 251
Table of Contents provided by Ingram. All Rights Reserved.

Rewards Program

Write a Review