SharePoint 2013 End to End Business Intelligence Boot Camp

Session Detail:    Classroom 5 Day

This five-day instructor-led course is a complete high-level tour of the Microsoft Business Intelligence stack. It introduces students to the SQL 2012 Business Intelligence and SharePoint 2013 Business Intelligence services including PerformancePoint Service, Excel Services, Business Connectivity Services, Visio Services and the Business Intelligence Center focusing on their interdependency.
Each of the modules is stand-alone allowing for customization of the course for those audiences that may not have an interest in a certain service.
Each concept is demonstrated with a video before the exercise on that concept, so first you will have the short lecture then see the concept demonstrated then do it yourself. Remember if you cant do it you didnt learn it. Each of the videos, and there are approximately 13 hours of them, is intended as a take-away from the class for each student.

Prerequisites

  • An understanding of the benefits of business intelligence.

Who Can Benefit

This course is intended for Project Managers, Business Intelligence Developers, SQL Server Developers and IT Professionals that will be involved with the design, development and maintenance of SharePoint 2013 Business Intelligence solutions. The course introduces each of the services and minimizes or eliminates any coding.

Session Outline

Class Outline

Module 1: Course Overview

  • Lesson 1: Introduction
  • Lesson 2: Course Materials
  • Lesson 3: Facilities
  • Lesson 4: Prerequisites
  • Lesson 5: What We’ll Be Discussing

Module 2: The Business Intelligence Stack

  • Lesson 1: Business Intelligence in Three Ways
  • Lesson 2: SQL 2012 Business Intelligence
  • Lesson 3: SharePoint 2010 Business Intelligence
  • Lesson 4: PowerPivot

Module 3: SQL Server Integration Services (SSIS) 2012

  • Lesson 1: What’s New?
  • Lesson 2: Overview of Extract, Transform, and Load (ETL)
  • Lesson 3: SSIS Tools
  • Lesson 4: Change Data Capture
  • Lesson 5: SQL Server Integration Services Scripting
  • Lesson 6: Variables, Parameters, and Expressions
  • Lesson 7: Package Deployment

Module 4: SQL 2012 Business Intelligence Semantic Model (Multidimensional Mode)

  • Lesson 1: The Data Warehouse/Data Mart
  • Lesson 2: The Tools
  • Lesson 3: Key Concepts
  • Lesson 4: Data Sources
  • Lesson 5: Data Views
  • Lesson 6: Cubes
  • Lesson 7: Data Profiler
  • Lesson 8: Proactive Cache
  • Lesson 9: Deployment
  • Lesson 10: Wizards

Module 5: Microsoft Multidimensional Expressions

  • Lesson 1: Concepts in Multidimensional Space
  • Lesson 2: Basic MDX Statements
  • Lesson 3: SQL Server Management Studio MDX Query Editor
  • Lesson 4: Navigating Hierarchies
  • Lesson 5: Working with Time
  • Lesson 6: MDX Calculations

Module 6: SQL 2012 Business Intelligence Semantic Model (Tabular Mode)

  • Lesson 1: The Tabular Model
  • Lesson 2: Data Analytic Expressions (DAX)
  • Lesson 3: The Editor
  • Lesson 4: Data Connections
  • Lesson 5: Creating a Tabular Project
  • Lesson 6: Relationships
  • Lesson 7:Measures and Calculated Columns
  • Lesson 8: Hierarchies
  • Lesson 9: Perspectives
  • Lesson 10: KPIs
  • Lesson 11: Partitions
  • Lesson 12: Processing
  • Lesson 13: Deployment

Module 7: SQL Server 2012 Reporting Services

  • Lesson 1: Report Lifecycles
  • Lesson 2: Installation Modes
  • Lesson 3: Report Creation Tools
  • Lesson 4: Data Sources
  • Lesson 5: Datasets
  • Lesson 6: Basic Reports
  • Lesson 7: Graphics
  • Lesson 8: Maps
  • Lesson 9: Report Parts

Module 8: Master Data Services

  • Lesson 1: What is Master Data Management?
  • Lesson 2: System Roles
  • Lesson 3: Master Data vs. Transactional Data
  • Lesson 4: Master Data Services ETL
  • Lesson 5: Master Data Services Key Concepts

Module 9: Data Mining/Predictive Analytics

  • Lesson 1: Definitions for Our Purpose
  • Lesson 2: Problems Addressed
  • Lesson 3: Business Analytics
  • Lesson 4: CRISP-DM
  • Lesson 5: Key Concepts
  • Lesson 6: Microsoft Data Mining Process
  • Lesson 7: Data Mining Tasks
  • Lesson 8: Microsoft Algorithms
  • Lesson 9: Matching the Tasks to the Algorithm
  • Lesson 10: Data Mining Add-in for Excel
  • Lesson 11: PowerPivot for Excel

Module 10: SharePoint 2013 Business Intelligence Center

  • Lesson 1: User Interface
  • Lesson 2: Libraries and Lists (Apps)
  • Lesson 3: Permissions
  • Lesson 4: Quick Architecture
  • Lesson 5: Central Administration

Module 11: SharePoint 2013 Excel Services

  • Lesson 1: New 2013 Excel Services Features
  • Lesson 2:Core Components
  • Lesson 3:Excel Web Access (EWA)
  • Lesson 4: What Excel Web Access is Not
  • Lesson 5: SharePoint Libraries to Store Workbooks
  • Lesson 6: Power View Excel 2013 and SharePoint 2013
  • Lesson 7: Excel Web Access Web Part
  • Lesson 8: Excel Interactive View
  • Lesson 9: Best Practices

Module 12: SharePoint 2013 PerformancePoint 2013

  • Lesson 1: What’s New?
  • Lesson 2: PerformancePoint Object Hierarchy
  • Lesson 3: Dashboard Designer
  • Lesson 4: Dashboards (Web Part Page)
  • Lesson 5: Indicators
  • Lesson 6: Data Sources
  • Lesson 7: Key Performance Indicators as PerformancePoint Objects
  • Lesson 8: Scorecards
  • Lesson 9: Filters
  • Lesson 10: Dashboards (Web Part Page) Revisited
  • Lesson 12: Dashboard Designer Management

Module 13: SharePoint 2013 Visio Services

  • Lesson 1: What’s New in Visio Services 2013?
  • Lesson 2: Visio Graphics Service
  • Lesson 3: Visio Drawings in the Browser
  • Lesson 4: Visio Graphics Web Access Part
  • Lesson 5: Visio Drawings with Data Connections

Module 14: PowerPivot

  • Lesson 1: PowerPivot and Excel 2013
  • Lesson 2: PowerPivot and SharePoint
  • Lesson 3: Enterprise Business Intelligence and PowerPivot
  • Lesson 4: Enriching Data

Module 15: SharePoint 2013 Business Connectivity Services

  • Lesson 1: What is Business Connectivity Services?
  • Lesson 2: BCS Terminology
  • Lesson 3: Business Connectivity Services and Apps From SharePoint 2013
  • Lesson 4: Using SharePoint Designer with BCS
  • Lesson 5: Surfacing the BCS Data

Module 16: Dashboards

  • Lesson 1: Dashboard Design
  • Lesson 2: Capabilities Summarization
  • Lesson 3: Three Types of Dashboards
  • Lesson 4: Successful Dashboards
  • Lesson 5: Tables or Graphs
  • Lesson 6: Types of Graphs
  • Lesson 7: Choosing a Chart Type
  • Lesson 8: Key Performance Indicators
  • Lesson 9: Pitfalls In Dashboard Design
  • Lesson 10: Microsoft Report Builder 3.0
  • Lesson 11: Plan Your Reports
  • Lesson 12: Datasets
  • Lesson 13: SharePoint Web Parts

Need to train your team?

All of our sessions can be customized to meet your team’s specific need. Build the perfect program by picking and choosing topics from any of the courses in our catalog. A personalized private session gives you the ultimate flexibility and helps maximize your team’s valuable time!

Requesting Team Training
DateTimeTypePriceAdd To Cart

SharePoint 2013 End to End Business Intelligence Boot Camp

5 Day
Classroom

$3,095.00

Chat with a Coach

Chat with a Coach

Have a more immediate need? Why spend the next hour searching online for answers when you can spend just 15 minutes with one of our experts and get accurate and personalized answers to all of your questions. 

$9.99 | 15 Minutes

Book Now