Overview

Journey through the SharePoint Business Intelligence Center, Excel Services, Reporting Services, Analysis Service, Performance Point and PowerPivot to implement your BI Strategies and enable your decision makers to see data in new and dynamic ways!

Objectives

The 2013 refresh of the popular 2010 BI course! This course explores the new design of the Business Intelligence Center, changes in Excel Services and Office Web Apps, Business Connectivity Services and OData, Visio Services, Access Services 2013, PowerPivot, PowerBI, PowerView, PowerQuery and Power Maps, PerformancePoint and Bing Maps via the GeoLocation field. A coverage of Big Data topics like Hadoop, HDInsight and StreamInsight are also included.

Audience

Sr. Business Intelligence Architects and Consultants, Sr. Business Analysts, anyone responsible for implementing BI with SharePoint.

Syllabus

Business Intelligence

  • Why Business Intelligence?
  • Lab 1 : Business Intelligence Worksheet

Business Intelligence Center

  • Business Intelligence Center
  • Lab 1 : Business Intelligence Center

Data Mart & Data Warehouses and Master Data Services

  • Understanding Data and Data Formats
  • Building Data Marts & Data Warehouses
  • Master Data Services
  • Lab 1: Data & Data Formats
  • Lab 2: Build A Data Warehouse
  • Lab 3: Extract & Load
  • Lab 4: Transform & Load
  • Lab 5: Granularity
  • Lab 6: Build A Data Mart
  • Lab 7: Master Data Services

Business Connectivity Services and Secure Store

  • Business Connectivity Services
  • Secure Store
  • Lab 1: BCS Basics
  • Lab 2: BCS With Data Warehouse
  • Lab 3: Office & BCS for BI
  • Lab 4: BCS and OData

Analysis Services, HDInsight and StreamInsight

  • Analysis Services
  • HDInsight & Hadoop
  • StreamInsight
  • Lab 1: Analysis Services
  • Lab 2: Building An Analysis Services Database
  • Lab 3: Key Performance Indicators
  • Lab 4: Hadoop and Azure HDInsight
  • Lab 5: StreamInsight

Filter Web Parts

  • Filter Web Parts
  • Lab 1: Filter Web Parts

Excel, Excel Services and Excel Web App

  • Excel Services
  • Lab 1: Create An Excel Report
  • Lab 2: Excel Services
  • Lab 3: MDX
  • Lab 4: Sparklines
  • Lab 5: Filters & Excel Services
  • Lab 6: REST & Web Services

PowerPivot, Tabular Data Sources

  • PowerPivot For Excel
  • PowerPivot For SharePoint
  • Lab 1: Use PowerPivot
  • Lab 2: Integrate Power Pivot and SharePoint
  • Lab 3: Tabular Models
  • Lab 4: Import PowerPivot to SSAS

Reporting Services

  • Reporting Services
  • Reports
  • Lab 1: Install Reporting Services
  • Lab 2: Building Reports with Reporting Services
  • Lab 3: Automating Reports with Reporting Services
  • Lab 4: Reporting Services and PowerPivot

Power View, Power Query and Power BI

  • Power View
  • Power Query
  • Power BI
  • Lab 1: Use Power View
  • Lab 2: Use Power Query
  • Lab 3: Use Power BI

Performance Point

  • Performance Point
  • Lab 1: Performance Point

Visio & Access Services

  • Visio Services
  • Access Services
  • Lab 1: Visio Services
  • Lab 2: Access Services

GeoSpatial Data, GeoLocation and Power Map

  • GeoSpatial Data
  • GeoLocation, Bing Maps and Charts
  • Power Map
  • Lab 1: GeoSpatial Data with SQL Server
  • Lab 2: Bing Maps and GeoLocation column
  • Lab 3: Use Power Map
  • Lab 4: Use Power Map and Power Query
  • Lab 5: NET Charts

Training provider

Teaching mode:
Classroom - Instructor Led
Online - Instructor Led
Duration: 5 days
Gooroo has partnered with the global leaders in IT training to give you access to quality training, personalised to you, targeted at increasing your job opportunities and salary.

Our pricing

We do not display pricing as Gooroo members qualify for special discounts not available elsewhere. You must enquire through Gooroo to get this benefit.

New courses are happening all the time

Our partner's expert training consultant will provide you with the times and all the details you need. Enquire today.

Top skills covered in this course

SharePoint
Worldwide
This skill has an average salary of
US$74,289
and is mentioned in
1.70%
of job ads.
Apache Hadoop
Worldwide
This skill has an average salary of
US$100,857
and is mentioned in
0.76%
of job ads.
Microsoft SQL Server
Worldwide
This skill has an average salary of
US$75,457
and is mentioned in
3.44%
of job ads.
Web services
Worldwide
This skill has an average salary of
US$87,747
and is mentioned in
2.18%
of job ads.