Published: February 2011
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
is a senior technology specialist with Microsoft. He has presented before thousands of users and developers on various topics, including SQL Server and BI, and has worked with large organizations on BI implementations.
Stacia Misner, MCITP, MCTS, is a consultant, trainer, and author specializing in Microsoft BI technologies. She has written several books and articles on SQL Server and is a frequent speaker at SQL Server conferences.
Keywords: BUSINESS, INTEGRATED, BUILDING, INTELLIGENCE, SOLUTIONS, SQL, SERVER, R2, OFFICE, BOOK, GUIDE, HOW TO, BI, BUSINESS INTELLIGENCE, ACCOMPLISH, UNDERSTANDING, PLATFORM, ANALYSIS, SERVICES, CUBES, REPORTING, SHAREPOINT, CHARTS, GRAPHS, EXCEL, MAPPING, DATA, INFOPATH, WORKFLOW, SCORECARDS, DASHBOARDS, MASTER, MANAGEMENT, PUBLISHING, MANAGING, PHILIP JANUS, MICROSOFT, GEMINI, SOFTWARE, WAVE, SPATIAL, TECHNOLOGIES, PRACTICAL, COLLABORATION, WORKGROUP, ENTERPRISE, SSRS, SSIS, SSAS, PERFORMANCEPOINT, DESIGNERS, ADMINISTRATORS, DEVELOPERS, DBAS, TOOLSET, APPLICATIONS, INSTALLING, CONFIGURING, STACK, BUSINESS INTELLIGENCE, BI, CRYSTAL REPORTS 2008 THE COMPLETE REFERENCE, BUSINESSOBJECTS XI THE COMPLETE REFERENCE, DELIVERING BUSINESS INTELLIGENCE WITH MICROSOFT SQL SERVER 2008, MICROSOFT SQL SERVER 2008 REPORTING SERVICES, MICROSOFT SQL SERVER 2008 ANALYTICS & DATA VISUALIZATION, VISUALIZING INFORMATION WITH MICROSOFT OFFICE VISIO 2007, MICROSOFT OFFICE 2007 BUSINESS INTELLIGENCE 0071494243, BUSINESS INTELLIGENCE WITH MICROSOFT OFFICE PERFORMANCEPOINT SERVER 2007, SUCCESSFUL BUSINESS INTELLIGENCE, SAP BUSINESS INFORMATION WAREHOUSE REPORTING, CRCP CRYSTAL REPORTS CERTIFIED PROFESSIONAL ALL-IN-ONE EXAM GUIDE, ORACLE CRM ON DEMAND REPORTING, ORACLE DISCOVERER 10G HANDBOOK, APPLIED SAP BI 7.0 WEB REPORTS, THE POWER TO PREDICT, RESHAPING YOUR BUSINESS WITH WEB 2.0, CRM AT THE SPEED OF LIGHT, EVENT PROCESSING, PRACTICAL MDX QUERIES, HANDS-ON MICROSOFT SQL SERVER 2008 INTEGRATION SERVICES