Philo Janus – författare

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

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 SSASMaximize the analysis capabilities of Excel and Excel ServicesCombine data from different sources and connect data for analysis with PowerPivotMove data into the system using SSIS, InfoPath, Streamsight, and SharePoint 2010 External ListsBuild and publish reports with SSRSIntegrate data from disparate applications, using SharePoint 2010 BI featuresCreate scorecards and dashboards with PerformancePoint ServicesSummarize large volumes of data in charts and graphsUse the SSRS map feature for complex visualizations of spatial dataUncover patterns and relationships in data using the SSAS data mining engineHandle master data management with Master Data ServicesPublish the components of your BI solution and perform administrative tasks

Every business has reams of business data locked away in databases, business systems, and spreadsheets. While you may be able to build some reports by pulling a few of these repositories together, actually performing any kind of analysis on the data that runs your business can range from problematic to impossible. Pro SQL Server 2008 Analysis Services will show you how to pull that data together and present it for reporting and analysis in a way that makes the data accessible to business users, instead of needing to rely on the IT department every time someone needs a different report. Accessible—With a single author's voice, this book conducts a guided tour through the technology that makes it easy to dive into. Solution–oriented—While technically deep, the goal is to focus on practical application of the technologies instead of acting as a technical manual. Comprehensive—This book covers every aspect of analysis services and ancillary technologies to enable you to make the most of SQL Server.

Pro InfoPath 2007 is an excellent book for developers trying to learn the scope and range of application forms that can be built with Microsoft Office InfoPath 2007.