Course details
This course explores how to use SharePoint as your platform for Business Intelligence. Journey through the SharePoint Business Intelligence Center, Excel Services, Reporting Services, Analysis Service, Performance Point and PowerPivot.
Course Outline
1 - Overview
- Understand your course, classroom, classmates, facility and instructor.
2 - Business Intelligence
- Business Intelligence
- Lab : Business Intelligence Worksheet
3 - Business Intelligence Center
- Business Intelligence Center
- Lab : Business Intelligence Center
4 - Data Mart and Data Warehouses
- Understanding Data and Data Formats
- Building Data Marts and Data Warehouses
- Lab : Data and Data Formats
- Lab : Build A Data Warehouse
- Lab : Extract and Load
- Lab : Transform and Load
- Lab : Granularity
- Lab : Build A Data Mart
- Lab : SQL Server to SharePoint Lists
5 - Business Connectivity Services
- Business Connectivity Services
- Lab : BCS Basics
- Lab : BCS With Data Warehouse
- Lab : Office and BCS for BI
6 - Analysis Services
- Analysis Services
- Lab : Analysis Services
- Lab : Building An Analysis Services Database
7 - Filter Web Parts
- Filter Web Parts
- Lab : Filter Web Parts
- Lab : UserProfiles and Filters
8 - Excel Services
- Excel Services
- Lab : Create An Excel Report
- Lab : Excel Services
- Lab : MDX
- Lab : Sparklines
- Lab : Filters and Excel Services
- Lab : REST and Web Services
9 - PowerPivot
- PowerPivot For SharePoint
- PowerPivot For Excel
- Lab : Install Power Pivot
- Lab : Use PowerPivot
10 - Reporting Services
- Reporting Services
- Reports
- Lab : Install Reporting Services
- Lab : Building Reports with Reporting Services
- Lab : Create Advanced Reporting Services reportFilter Web Parts and Reports
- Lab : Reporting Services and PowerPivot
11 - Performance Point
- Performance Point
- Lab : Performance Point
12 - Visio and Access Services
- Visio Services
- Access Services
- Lab : Visio Services
- Lab : Access Services
13 - GeoSpatial Data with Charts and Maps
- Charts and Maps
- GeoSpatial Data
- Lab : GeoSpatial Data with SQL Server
- Lab : Bing Maps
- Lab : .NET Charts
- Lab : Google Maps
Target Audience: Sr Business Intelligence Architects and Consultants, Sr Business Analysts, anyone responsible for implementing BI with SharePoint.
Updated on 08 November, 2015Course Location
About New Horizons Ireland
With a very convenient location next to Jervis street in Dublin 1, we offer a wide range of IT and business skills courses and we can also send our instructors to your location.
We are 100% Irish owned, but we are also part of the largest independent IT Training Provider, New Horizons Computer Learning Centres who deliver more courses than any other IT training company.
Because we're local, we understand the needs of business and individuals in our community. Whether you choose to take classes in person or online, you're always welcome to call or stop by.
See all New Horizons Ireland courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft SharePoint 2016 For Administrators Diploma Alpha AcademyAED 92
AED 1,175Duration: Upto 13 Hours - Microsoft SharePoint 365 Beginners Alpha AcademyAED 92
AED 955Duration: Upto 11 Hours