Business Intelligence in Microsoft SharePoint 2013 - Softcover

Warren, Norman P.

Softcover

ISBN 10: 0735675430 ISBN 13: 9780735675438

Publisher: Microsoft Press, 2013

Synopsis

Dive into the business intelligence features in SharePoint 2013—and use the right combination of tools to deliver compelling solutions.

Take control of business intelligence (BI) with the tools offered by SharePoint 2013 and Microsoft SQL Server® 2012. Led by a group of BI and SharePoint experts, you’ll get step-by-step instructions for understanding how to use these technologies best in specific BI scenarios—whether you’re a SharePoint administrator, SQL Server developer, or business analyst.

Discover how to:

• Manage the entire BI lifecycle, from determining key performance indicators to building dashboards


• Use web-based Microsoft Excel® services and publish workbooks on a SharePoint Server
• Mash up data from multiple sources and create Data Analysis Expressions (DAX) using PowerPivot
• Create data-driven diagrams that provide interactive processes and context with Microsoft Visio® Services


• Use dashboards, scorecards, reports, and key performance indicators to monitor and analyze your business
• Use SharePoint to view BI reports side by side, no matter which tools were used to produced them

About this title

Review:

Q&A with Norman Warren, author of "Business Intelligence in Microsoft SharePoint 2013"

Q. Why is your book timely-- what makes it important right now?

A. Our book can be considered a quick guide to getting value from Big Data. Why? Because much of the focus is on Excel and the business intelligence tools that are now baked into it. Additionally, there is content on how to connect to Hadoop data with Excel. There is no better time to embrace the fact that Excel is the preferred tool of choice for analyzing and exploring data. This book provides the keys for getting value from data and sharing discovered insights in SharePoint 2013.

The tools that Microsoft provides are less expensive, integrate more easily in the corporate datacenter, and are accessible to mainstream information workers and developers, using the skills they already have.

Q. What information do you hope that readers of your book will walk away with?

A. 1. A quick tour with exercises for using new BI features in Excel 203 and Visio 2013 and then how to get the most from SQL Server 2012 tabular and SharePoint 2013 when implementing self-service and enterprise BI solutions.

2. A clear understanding of what business intelligence is. Also, an understanding of what Big Data is, its role in surfacing insights, and how to use Microsoft BI tools to get value from it.

3. Useful instruction on which tool to use. Customers often ask which tools they should use when trying to select among a variety of Microsoft offerings. They’re often confused and need information as to why they might want to prefer SQL Server Reporting Services in SharePoint over PerformancePoint Services, or why they might use the Excel 2013 PowerPivot add-in instead of Excel or Excel Services. After all, each product connects to a database and surfaces data from an OLAP cube.

4. A better understanding on how to get to trusted data and the shortened life cycle of BI implementation while using the latest Microsoft BI tools.

Q. What's the most exciting and/or important thing happening in your space?

A. Managed and guided self-service BI works. People don't have to wait on IT to get a report. This book gives tips for successfully implementing self-service BI with tools like Excel 2013 and Visio 2013.

Big Data is here to stay and you can learn what it is and how to get value from the huge data store immediately by using tools discussed in this book.

About the Author:

Norm Warren is a SharePoint, PerformancePoint, and SQL Server expert and coauthor of Business Intelligence in Microsoft SharePoint 2010.

Mariano Teixeira Neto is a software design engineer on the SQL Server Analysis Services team who has worked on PowerPivot for SharePoint.

Stacia Misner is a Microsoft Certified IT Professional-BI and a Microsoft Certified Technology Specialist-BI and the author of multiple books on Microsoft SQL Server and BI.

Ivan Sanders is a Microsoft MVP for SharePoint and independent consultant focused on delivering Microsoft SharePoint solutions.

Scott Helmers is a Microsoft MVP for Visio and a co-inventor of a Visio add-in that allows anyone to document all of the important aspects of any business process. Scott is the author of Microsoft Visio 2010 Step by Step.

About this edition

• Publisher: Microsoft Press
• Publication date: 2013
• ISBN 10: 0735675430
• ISBN 13: 9780735675438
• Binding: Paperback
• Edition number: 1
• Number of pages: 404