Microsoft Office 2007 Business Intelligence: Reporting, Analysis, and Measurement from the Desktop (Google eBook)

Doug Harts

McGraw Hill Professional, 2008 - Computers - 444 pages

Extract and analyze mission-critical enterprise data using Microsoft Office 2007

This authoritative volume is a practical guide to the powerful new collaborative Business Intelligence tools available in Office 2007. Using real-world examples and clear explanations, Microsoft Office 2007 Business Intelligence: Reporting, Analysis, and Measurement from the Desktop shows you how to use Excel, Excel Services, SharePoint, and PerformancePoint with a wide range of stand-alone and external data in today's networked office. You will learn how to analyze data and generate reports, scorecards, and dashboards with the Office tools you're already using to help you in your everyday work.Create Excel PivotTables and PivotCharts and apply Conditional FormattingConvert Excel spreadsheets into Excel Tables with Conditional Formatting and ChartingConnect external data to Excel using Office Data Connections and SharePointCreate SharePoint dashboards that display data from multiple sourcesAdd Key Performance Indicators and Excel Services reports to your dashboardsHarness advanced SQL Server 2005 data analysis tools with the Excel Data Mining Add-In and Visio Cluster DiagramsGenerate integrated PerformancePoint ScorecardsCreate Visio PivotDiagrams and Windows Mobile spreadsheets

All of the examples in the book can be downloaded for free by doing the following: go to www.mhprofessional.com. Click on the Computing tab. Click on the Downloads page. Click on the book's title to download the examples.

Contents

• Chapter 1 Introduction to Microsoft Office BI Concepts: 1
• Chapter 2 PivotTables PivotCharts and Conditional Formatting: 13
• Conditional Formatting WhatIf and Statistics and Charts: 87

About the author

Doug Harts " 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 market's 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 Microsoft's 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.

Bibliographic information

• Title: Microsoft Office 2007 Business Intelligence: Reporting, Analysis, and Measurement from the Desktop; McGraw Hill professional; NetLibrary, Inc
• Author: Doug Harts
• Publisher: McGraw Hill Professional, 2008
• ISBN: 0071595295, 9780071595292
• Length: 444 pages
• Subjects: Computers / Desktop Applications / Suites; Computers / Enterprise Applications / Business Intelligence Tools