Book description
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
Table of contents
- Table of Contents
- Introduction
-
1. Business intelligence in SharePoint
- Leading up to BI
- Beware of losing sight of what matters most
- What is BI?
- Microsoft’s vision for BI and self-service BI
- What SharePoint does for BI
- The BI stack: SQL Server + SharePoint + Office
- Examples of BI in SharePoint 2013
- Creating a report by using an Odata feed from a SharePoint list
- Summary
-
2. Planning for business intelligence adoption
- Business user communities
- The progression of BI
- Tool selection
- An action plan for adoption: Build it and they might come
- Summary
-
3. The lifecycle of a business intelligence implementation
- Working together: SQL Server 2012 + SharePoint 2013 + Office 2013
- SQL Server 2012 features
-
The lifecycle of a BI implementation
- Step 1: Decide what to analyze, measure, or forecast
- Step 2: Get to trusted data
- Step 3 or 4: Load data into a SSDT (Visual Studio) project
- Step 5: Model the data
- Step 6: Deploy the model to SSAS
- Prepare to automate data processing
- Create the XMLA for a new job
- Step 7: Create a BISM file in SharePoint 2013
- Summary
- 4. Using PowerPivot in Excel 2013
- 5. Using Power View in Excel 2013
- 6. Business intelligence with Excel Services 2013
- 7. Using PowerPivot for SharePoint 2013
-
8. Using PerformancePoint Services
- A brief history of PerformancePoint Services
- An overview of PerformancePoint Services components
- What’s new in PerformancePoint Services 2013
- The PerformancePoint Services architecture
- PerformancePoint Services configuration
- Providing a performance solution
- Summary
- 9. Using Visio and Visio Services
- 10. Bringing it all together
-
A. Running scripts to set up a demonstration environment
- Hardware considerations
- Introducing the scripts
- Step 1: Install the Active Directory Demo Build 2.1
- Step 2: Install the SQL 2012 SP1 Content Pack Demo Build 2.0.0
- Step 3: Install the SharePoint 2013 Demo Build 2.0
- Step 4: Install the UserProfile Provisioning Demo 2.0
- Step 5: Install the Self-Service BI Demo 2.0 Content Pack
- Step 6: Install the Visio Services Demo Content Pack
- B. Microsoft and “Big Data”
- C. About the Authors
- Index
- About the Authors
- Copyright
Product information
- Title: Business Intelligence in Microsoft SharePoint 2013
- Author(s):
- Release date: May 2013
- Publisher(s): Microsoft Press
- ISBN: 9780735675421
You might also like
book
Power Query Cookbook
Leverage your source data from hundreds of different connections, perform millions of different transformations, and easily …
book
React Native Cookbook - Second Edition
Improve your React Native mobile development skills or transition from web development to mobile development with …
book
Microsoft SQL Server 2019: A Beginner's Guide, Seventh Edition, 7th Edition
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, …
book
React Material-UI Cookbook
Develop modern-day applications by implementing Material Design principles in React using Material-UI Key Features Use React …