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
Microsoft SharePoint 2013 Inside Out
Conquer SharePoint 2013—from the inside out! You’re beyond the basics, so dive right into SharePoint 2013—and …
book
Professional SharePoint 2013 Administration
SharePoint admin author gurus return to prepare you for working with the new features of SharePoint …
book
Microsoft Sharepoint 2013 Step by Step
The smart way to learn Microsoft SharePoint 2013—one step at a time! Experience learning made easy—and …
book
Using Microsoft InfoPath 2010 with Microsoft SharePoint 2010 Step by Step
The smart way to learn how to build InfoPath forms for SharePoint—one step at a time! …