Attend Our Classes From Home - No Software Needed - Learn More...
Business Intelligence in Microsoft SharePoint 2013
by Certstaffix® Training
Length: 5 day(s) Public Class Price: $2925/person (USD) Group Class Price: Request Quote Course Category: Microsoft SharePoint | 208208 SharePoint_2013_BI
Dive into the business intelligence features in SharePoint 2013—and use the right combination of tools to deliver compelling solutions.
In this course you will learn how to take control of business intelligence (BI) with the tools offered by SharePoint 2013 and Microsoft SQL Server 2012. 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.
This course will show you 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 and Use SharePoint to view BI reports side by side, no matter which tools were used to produced them.
Public Classes - Live Online at Your Location or OursHow It Works
Certstaffix® Training public classes are instructor-led, live online training you attend from your home or work or in one of our local computer labs. Our live online instructors teach you from a remote location while being able to interact with students as in a traditional classroom setting.
- A real, live instructor teaching you from another location
- Hands-on learning with the software/skills you are being taught
- Interaction with all students in the class at other locations
- Any needed software for class provided in online lab environment
- Easy assistance from the instructor
Click a class date below to register & view location/attendance options.
Group Classes for Organizations - Onsite or Online How It Works
Have a group of employees needing the same training? Onsite training at your office or group live online classes are great solutions.
- An expert Instructor will either come to your office or deliver a private live online class to your students
- Course can be customized to your training needs
- Course is scheduled based on dates you provide (Subject to instructor availability)
- We usually require about 4 weeks lead time to arrange a training session
Detailed Course Topics
|Chapter 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
Chapter 2 Planning for business intelligence adoption
Business user communities
The progression of BI
An action plan for adoption: Build it and they might come
Chapter 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
Chapter 4 Using PowerPivot in Excel 2013
The Data Model
Calculations with DAX
Importing data from Windows Azure Marketplace
Paving the ground
Chapter 5 Using Power View in Excel 2013
Introducing Power View
What’s new in Power View
Using Power View
Saving a Power View workbook
Chapter 6 Business intelligence with Excel Services 2013
A brief history of Excel Services
When to use Excel Services
The Data Model in Excel Services
Configuring the server
Opening an Excel workbook in the browser
Extending Excel Services
Chapter 7 Using PowerPivot for SharePoint 2013
A brief history
When do I use PowerPivot for SharePoint?
Publishing to SharePoint
Scheduling data refreshes
Workbooks as a data source
Monitoring with PowerPivot for SharePoint
Chapter 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
Chapter 9 Using Visio and Visio Services
What’s new in Visio 2013
Six reasons to include Visio 2013 in your BI suite
When do I use Visio and Visio Services?
Incorporating Visio into a BI solution
Visio Services: Example 1
Visio Services: Example 2
Chapter 10 Bringing it all together
Tools in SharePoint for authoring dashboards
Which dashboard tool should I use?
Dashboard (Web Part) pages in SharePoint
Using Excel Services in the dashboard (Web Part page)
Preparing the workbook for the dashboard: adding parameters
Adding to the dashboard (Web Part page)