Synopses & Reviews
Master the Next-Generation Business Intelligence Tools in SQL Server 2008 R2
Effectively convey meaningful business insights to users across your enterprise with help from this practical guide. Written by a team of business intelligence experts, Microsoft SQL Server 2008 R2 Analytics & Data Visualization shows how to achieve greater information absorption using the latest reporting tools. Learn how to build maps and gauges, integrate OLAP data, and develop dashboards. Security, performance tuning, and cloud computing techniques are also covered in this comprehensive resource. Design and deploy chart-based reports using SSRS 2008 R2 Display geo-spatial map data with location-based indicators Visually represent metrics and KPIs on graphs and gauges Distribute reports through SharePoint and PerformancePoint Create and publish web page parts, dashboards, and mash-ups Set up and manage cloud-based services using SQL Azure Incorporate data mining and forecasting features with Visio Integrate large amounts of data using PowerPoint for Excel Derive matrix, table, and chart data from OLAP cubes
Doug Harts is a Services Executive at Microsoft currently helping U.S. Federal agencies implement Microsoft technology roadmaps. He is the author of Microsoft Office 2007 Business Intelligence, and maintains a BI community website at www.OfficeBIcentral.com.
Jim Dugan is a Solutions Architect with the Microsoft Healthcare and Benefits team in Microsoft Federal. He previously served as Technical Director of Microsoft's Technology and Innovation Center in Reston, Virginia.
Tricia Wilcox Almas is a Technical Architect for Business Intelligence Solutions for MicroLink, LLC, a Microsoft Gold Partner. She has been developing solutions and managing IT projects for more than 25 years.
A practical guide to the next-generation Business Intelligence tools available in SQL Server 2008
This book will help DBAs and business intelligence architects work with the latest 3-D visualization techniques that revolutionize data reporting, analysis, and measurement in SQL Server 2008. You will appreciate the complete end-to-end explanation of the real-time visual representation of metrics and trends.
Microsoft SQL Server 2008 Analytics and Data Visualization begins with an overview of how these new tools, acquired from Dundas, fit into the SQL Server 2008 BI stack. You will learn strategies for data mining and advanced analytics. The book explains the full range of cutting-edge data visualization tools, including several customizable charts, map solutions for geographic data, illustrative gauges, and detailed calendars. An eight-page full-color insert highlights dazzling examples of 3-D visuals that convey business metrics in innovative ways.
About the Author
is a Services Executive at Microsoft currently helping U.S. Federal agencies implement Microsoft technology roadmaps. As a former Chief Technology Officer of the Microsoft Gold development partner that published the markets first SQL Server web-based ad-hoc report tool that co-launched with Reporting Services in 2000, Doug has been involved with Business Intelligence research and design at Microsoft-Redmond and commercial and public organizations around the world. As a current member of the Microsoft Business Intelligence Field Advisory Council, Doug contributes to the design and development of Business Intelligence technology in the SharePoint Cloud environment. Doug is also the author of Microsoft Office 2007 Business Intelligence.
(McGraw-Hill, 2007), and maintains a BI Community website at www.OfficeBIcentral.com.
Jim Dugan is a Solutions Architect in Microsoft Healthcare and Benefits team in Microsoft Federal. Jim has been in the information technology field for over 25 years and with Microsoft for 14 of those years. Jim has contributed to many large scale projects for commercial, Federal and humanitarian efforts. Jim previously served as Technical Director of Microsofts Technology and Innovation Center in Reston, Virginia. Jim resides with his wife and three kids in Arlington Virginia. Jim can be found with other Business Intelligence community people at www.OfficeBIcentral.com .
Tricia Wilcox Almas is a Technical Architect for Business Intelligence Solutions for MicroLink, LLC, a Microsoft Gold Partner. Tricia has been developing solutions and managing IT projects for over 25 years, and has extensive experience helping Non-profit and government organizations get the most out of their IT investments. Tricia enjoys building data warehouses and cubes, and delivering reporting and performance management solutions for her clients. In her rare leisure time, she assists with fundraising events for Challenger Little League and Special Olympics, and enjoys time with her husband of 25 years and two teen-age sons.
Table of Contents
Chapter 1. Introduction to SQL Server 2008 BI Concepts and Features
Chapter 2. Analysis Services 2008, how it works as a foundation for BI analytics and displays
Chapter 3. Chart Analytics, interactive visualization of BI in Reporting Services 2008
Chapter 4. Chart Control, stand-alone visualization of BI
Chapter 5. Gauge Analytics, interactive visualization of BI in Reporting Services 2008
Chapter 6. Gauge Control, stand-alone visualization of BI
Chapter 7. Map Analytics, interactive visualization of BI in Reporting Services 2008
Chapter 8. Map Control, stand-alone visualization of BI