| Contents at a Glance | 5 |
---|
| Contents | 6 |
---|
| Foreword | 14 |
---|
| About the Author | 16 |
---|
| About the Technical Reviewers | 17 |
---|
| Acknowledgments | 18 |
---|
| Introduction | 19 |
---|
| Who This Book Is For | 19 |
| How This Book Is Structured | 19 |
| Prerequisites | 20 |
| Downloading the Code | 20 |
| Contacting the Author | 20 |
| Business Intelligence | 21 |
---|
| What Is Business Intelligence? | 21 |
| Scorecards vs. Dashboards | 22 |
| Key Performance Indicators | 25 |
| Strategy Maps | 28 |
| Data Silos | 30 |
| Data Marts | 31 |
| Why Do I Care? | 33 |
| The Microsoft Business Intelligence Stack | 33 |
| A Successful Business Intelligence Engagement | 35 |
| Conclusion | 36 |
| Overview of Microsoft s Business Intelligence Platform | 37 |
---|
| SQL Server | 37 |
| SharePoint Integration | 42 |
| Excel Services | 44 |
| SharePoint KPI Lists | 45 |
| ProClarity 6.3 | 46 |
| PerformancePoint Server 2007 | 48 |
| Conclusion | 52 |
| SQL Server | 53 |
---|
| Overview | 53 |
| SQL Server Editions | 53 |
| Tools | 58 |
| Programmability | 63 |
| Security | 65 |
| XML | 66 |
| High Availability | 67 |
| Service Pack 2 | 68 |
| SQL Server 2008 | 71 |
| Conclusion | 72 |
| SQL Server Integration Services | 73 |
---|
| Overview | 73 |
| About Data Transformation Services | 80 |
| Architecture | 82 |
| Getting Integration Services | 83 |
| Business Intelligence Development Studio | 84 |
| Flows | 87 |
| Program Flow Components | 90 |
| Data Flow Components | 92 |
| Scripting Tasks | 94 |
| Custom Tasks | 97 |
| Error Reporting | 98 |
| Scalability | 99 |
| Deploying and Executing Integration Services Packages | 100 |
| Conclusion | 102 |
| SQL Server Analysis Services | 103 |
---|
| What Is a Cube? | 104 |
| Facts and Dimensions | 109 |
| Star Schema or Snowflake Schema? | 110 |
| BIDS and Analysis Services | 111 |
| Building a Cube | 111 |
| Calculated Measures | 142 |
| Multidimensional Expressions | 142 |
| Key Performance Indicators | 142 |
| Perspectives | 143 |
| Conclusion | 143 |
| SQL Server Reporting Services | 144 |
---|
| Architecture | 147 |
| Creating Reports | 155 |
| SharePoint Integration | 182 |
| Conclusion | 183 |
| Data Mining | 184 |
---|
| SQL Server Implementation | 185 |
| Data Mining Algorithms | 187 |
| Choosing an Algorithm | 196 |
| Mining Accuracy | 197 |
| Mining Model Prediction | 197 |
| Data Mining in Integration Services | 197 |
| SQL Server 2005 SP2 Excel Add- Ins | 199 |
| Publishing to Reporting Services | 205 |
| Conclusion | 206 |
| Business Intelligence in Excel and SharePoint | 207 |
---|
| Business Intelligence in Office | 208 |
| Excel 2007 | 209 |
| Excel Services | 215 |
| MOSS Business Intelligence | 224 |
| Conclusion | 228 |
| ProClarity Analytics Server | 229 |
---|
| ProClarity Analytics Server Overview | 229 |
| Advanced Visualizations | 254 |
| ProClarity and SharePoint | 262 |
| Installing ProClarity Analytics Server | 264 |
| Conclusion | 272 |
| PerformancePoint Monitoring | 273 |
---|
| Scorecards | 273 |
| Strategy Maps | 277 |
| Installing PerformancePoint | 280 |
| Running Dashboard Designer | 287 |
| Tour of Dashboard Designer | 289 |
| Creating a Scorecard | 296 |
| Conclusion | 320 |
| Advanced Scorecarding | 321 |
---|
| Hooking KPIs to Data | 321 |
| Analysis Services | 339 |
| Reporting Services | 350 |
| Conclusion | 350 |
| Dashboards and Reports | 351 |
---|
| Overview of the Dashboard Editor | 351 |
| Reports | 354 |
| Creating Dashboards | 374 |
| Publishing Dashboards | 381 |
| Conclusion | 384 |
| Planning | 385 |
---|
| Installation | 389 |
| Working with Planning | 393 |
| Business Rules | 435 |
| Conclusion | 437 |
| Management Reporter | 438 |
---|
| Creating Management Reports | 438 |
| Connecting to PerformancePoint Server | 448 |
| Exporting to Reporting Services | 451 |
| Conclusion | 451 |
| Index | 452 |