Synopses & Reviews
Create integrated business intelligence solutions using the newest releases of the Microsoft BI stack
Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 and Office 2010 explains how to use the entire Microsoft BI stack--SQL Server 2008 R2, SharePoint 2010, and Office 2010 components, including Excel/Gemini--to create integrated, practical, business intelligence solutions. An overview of SQL Server Analysis Services sets the stage for broad coverage of Excel as a front end for "self-service analysis," using SharePoint features for collaboration and workgroup BI, and leveraging Reporting Services for enterprise dashboards and reports. This practical guide focuses on building end-to-end BI solutions that solve real business data dilemmas.
Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 and Office 2010 features:
- Authoritative content written by a senior technology specialist at Microsoft who has presented to thousands of users and developers on Microsoft's BI technologies
- A foreword by Thierry D'Hers, Business Intelligence Group Program Manager at Microsoft
- Real-world exercises that enable you to build practical solutions for your own business problems
- Detailed illustrations depicting sophisticated reporting results
- Tips on visually representing data, creating KPI's, and business metrics
Complete coverage of Microsoft business intelligence solutions:
What Is Business Intelligence?; Collaboration Meets Business Intelligence; Excel and Excel Services; Analysis Services and Cubes; Introducing PowerPivot; Getting Data In; Reporting Services; SharePoint; Charts and Graphs; Mapping; Data Mining; Scorecards and Dashboards; Master Data Services; Publishing and Administration
Master Microsoft's Business Intelligence Tools
Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 & Office 2010 explains how to take full advantage of Microsoft's collaborative business intelligence (BI) tools. A variety of powerful, flexible technologies are covered, including SQL Server Analysis Services (SSAS), Excel, Excel Services, PowerPivot, SQL Server Integration Services (SSIS), Server Reporting Services (SSRS), SharePoint Server 2010, PerformancePoint Services, and Master Data Services. This practical guide focuses on deveoloping end-to-end BI solutions that foster informed decision making.
Create a multidimensional store for aggregating business data with SSAS Maximize the analysis capabilities of Excel and Excel Services Combine data from different sources and connect data for analysis with PowerPivot Move data into the system using SSIS, InfoPath, Streamsight, and SharePoint 2010 External Lists Build and publish reports with SSRS Integrate data from disparate applications, using SharePoint 2010 BI features Create scorecards and dashboards with PerformancePoint Services Summarize large volumes of data in charts and graphs Use the SSRS map feature for complex visualizations of spatial data Uncover patterns and relationships in data using the SSAS data mining engine Handle master data management with Master Data Services Publish the components of your BI solution and perform administrative tasks
About the Author
Philo Janus, BSEE, JD, is a senior technology specialist with Microsoft. He has presented before thousands of users and developers on various topics from InfoPath to SQL Server and business intelligence. Janus has also worked with large organizations on BI implementations. He was previously in the U.S. Navy.
Table of Contents
Chapter 1 What Is Business Intelligence?
Chapter 2 Collaboration Meets Business Intelligence
Chapter 3 SQL Server Analysis Services
Chapter 4 Excel and Excel Services
Chapter 5 Introducing PowerPivot
Chapter 6 Getting Data In
Chapter 7 SQL Server Reporting Services
Chapter 8 SharePoint Server 2010
Chapter 9 Scorecards and Dashboards
Chapter 10 Data Visualization
Chapter 11 Mapping
Chapter 12 Data Mining
Chapter 13 Master Data Services
Chapter 14 Publishing and Administration