Applied Microsoft Business Intelligence

Leverage the integration of SQL Server and Office for more effective BI

Applied Microsoft Business Intelligence shows you how to leverage the complete set of Microsoft tools—including Microsoft Office and SQL Server—to better analyze business data.

This book provides best practices for building complete BI solutions using the full Microsoft toolset. You will learn how to effectively use SQL Server Analysis and Reporting Services, along with Excel, SharePoint, and other tools to provide effective and cohesive solutions for the enterprise. Coverage includes BI architecture, data queries, semantic models, multidimensional modeling, data analysis and visualization, performance monitoring, data mining, and more, to help you learn to perform practical business analysis and reporting. Written by an author team that includes a key member of the BI product team at Microsoft, this useful reference provides expert instruction for more effective use of the Microsoft BI toolset.

• Use Microsoft BI suite cohesively for more effective enterprise solutions
• Search, analyze, and visualize data more efficiently and completely
• Develop flexible and scalable tabular and multidimensional models

Monitor performance, build a BI portal, and deploy and manage the BI Solution

Table of Contents

Part I Overview of the Microsoft Business Intelligence Toolset
Chapter 1 Which Analysis and Reporting Tools Do You Need?
Chapter 2 Designing an Effective Business Intelligence Architecture
Chapter 3 Selecting the Data Architecture that Fits Your Organization

Part II Business Intelligence for Analysis
Chapter 4 Searching and Combining Data with Power Query
Chapter 5 Choosing the Right Business Intelligence Semantic Model
Chapter 6 Discovering and Analyzing Data with Power Pivot
Chapter 7 Developing a Flexible and Scalable Tabular Model
Chapter 8 Developing a Flexible and Scalable Multidimensional Model
Chapter 9 Discovering Knowledge with Data Mining

Part III Business Intelligence for Reporting
Chapter 10 Choosing the Right Business Intelligence Visualization Tool
Chapter 11 Designing Operational Reports with Reporting Services
Chapter 12 Visualizing Your Data Interactively with Power View
Chapter 13 Exploring Geographic and Temporal Data with Power Map
Chapter 14 Monitoring Your Business with PerformancePoint Services

Part IV Deploying and Managing the Business Intelligence Solution
Chapter 15 Implementing a Self-Service Delivery Framework
Chapter 16 Designing and Implementing a Deployment Plan
Chapter 17 Managing and Maintaining the Business Intelligence Environment
Chapter 18 Scaling the Business Intelligence Environment