Microsoft Business Intelligence For Dummies, 1st Edition

  • Published By:
  • ISBN-10: 0470606347
  • ISBN-13: 9780470606346
  • DDC: 658.05
  • Grade Level Range: 12th Grade +
  • 523 Pages | eBook
  • Original Copyright 2010 | Published/Released June 2014
  • This publication's content originally published in print form: 2010

  • Price:  Sign in for price



Microsoft Business Intelligence For Dummies covers the Microsoft Business Intelligence stack, discussing current technologies and showing how work together to enable an effective business problem-solving strategy. Common technologies include: SharePoint ‒ Microsoft puts SharePoint at the top of the stack with Excel Services, SQL Server Reporting Services integration, dashboards, and KPIs. It was recently announced that PerformancePoint technology will be rolled into SharePoint. The SQL Server suite of products ‒ including SQL Server Database Engine, Integration Services, Reporting Services, Analysis Services. Microsoft Office Suite ‒ especially Excel which can be used as a data mining client. Excel connects to the back end Analysis Services engine. PerformancePoint ‒ as earlier mentioned, will be rolled into SharePoint. BI development technologies ‒ including Visual Studio, Business Intelligence Development Studio (Visual Studio with BI functionality), Management Studio, Report Builder 2.0, SharePoint Designer, and Expression Web. All these BI stack elements are enabled by data warehousing, data marts online analytical processing (OLAP), data mining, and key performance indicators, as well as ERP systems. At the infrastructure level of the stack is Windows Server Operating System and its components. Many books on the market delve into the details of particular technologies; however, many managers, developers, and CIOs want more information about how these technologies work together to solve enterprise problems. This book focuses on the functional problems that BI solves and the technologies involved. It removes the guesswork from Microsoft Business Intelligence by explaining each of the technologies, their overall functions, and how they fit together and provide the most efficient BI process and strategy.

Table of Contents

Front Cover.
Half Title Page.
Title Page.
Copyright Page.
About the Author.
Author's Acknowledgments.
Contents at a Glance.
Table of Contents.
1: Embracing a Microsoft Business Intelligence Solution.
2: Surveying Microsoft Business Intelligence from 50,000 Feet.
3: Blazing a Trail through the Data Jungle.
4: Adopting Microsoft Business Intelligence.
5: Wrapping Your Head around Business Intelligence Concepts.
6: Using Data to Inform and Drive Business Activities.
7: Taking a Closer Look at Data Collection.
8: Turning Data into Information.
9: Data Mining for Information Gold.
10: Introducing the Microsoft Business Intelligence Technologies.
11: Meeting SQL Server.
12: Excel — Digital Data Power to the People.
13: SharePoint Shines.
14: Expressing Yourself with Development Tools.
15: Incorporating Microsoft Business Intelligence into Your Business Environment.
16: Setting Your BI Goals and Implementation Plan.
17: Evaluating and Choosing Technologies.
18: Testing and Rolling Out.
19: Training, Using, and Evaluating Results.
20: The Part of Tens.
21: Ten Microsoft BI Implementation Pitfalls.
22: Ten Keys to Successful Microsoft Business Intelligence.
23: Ten Ways to Boost Your Bottom Line with Microsoft Business Intelligence.