Duration: 5 Days
In this course, you will learn how to build a BI environment from scratch to full interactive dashboards using the Microsoft BI stack. You will learn to implement BI strategies using SharePoint Business Intelligence Center, Excel Services, Reporting Services, Analysis Service, Performance Point, and PowerPivot.
This course incorporates material from the Official Microsoft Learning Product 50429: Sharepoint 2010 Business Intelligence.
Proven Impact Exclusive!
Continue developing your skills after class with 24/7 access to our live remote labs for six months, providing you with valuable extra time for hands-on practice.
What You Will Learn
- Business Intelligence Center
- Data formats, building data marts and data warehouses, and ETL process
- Business Connectivity Services (BCS)
- Microsoft SQL Server Analysis Services (SSAS) and filtering Web Parts
- Excel Services, PowerPivot, Reporting Services, Performance Point, Visio, and Access Services
Audience
Senior BI architects and consultants, senior business analysts, and those responsible for implementing BI with SharePoint
Prerequistes
- Knowledge of SharePoint 2010 user interface
- Understanding of database reporting concepts
- Familiarity with data marts and data warehouses
Course Outline
1. Business Intelligence
- What P=R-C means to BI
- Accept that empowering end users is a good thing
- BI will only be as good as your data, tools, and processes
2. Business Intelligence Center
- SharePoint Business Intelligence Center
- Dashboard Designer
3. Data Mart and Data Warehouses
- Data and data formats
- Building data marts and data warehouses
4. Business Connectivity Services
5. Analysis Services
6. Filter Web Parts
7. Excel Services
8. PowerPivot for SharePoint and Excel
9. Reporting Services and Reports
10. Performance Point
11. Visio and Access Services
12. GeoSpatial Data with SQL Server
- Charts and maps
- GeoSpatial data
Course Labs
Lab 1: Business Intelligence Worksheet
Lab 2: Business Intelligence Center
- Explore Business Intelligence Center
- Explore Dashboard Designer
Lab 3A: Data and Data Formats
Lab 3B: Build a Data Warehouse
Lab 3C: Extract and Load
Lab 3D: Transform and Load
Lab 3E: Granularity
Lab 3F: Build a Data Mart
Lab 3G: SQL Server to SharePoint Lists
Lab 4A: BCS Basics
Lab 4B: BCS with Data Warehouse
Lab 4C: Office and BCS for BI
Lab 5A: Analysis Services
Lab 5B: Build an Analysis Services Database
Lab 6A: Filter Web Parts
Lab 6B: User Profiles and Filters
Lab 7A: Create an Excel Report
Lab 7B: Excel Services
Lab 7C: MDX
Lab 7D: Sparklines
Lab 7E: Filters and Excel Services
Lab 7F: REST and Web Services
Lab 8A: Install PowerPivot
Lab 8B: Use PowerPivot
Lab 9A: Install Reporting Services
Lab 9B: Build Reports with Reporting Services
Lab 9C: Create Advanced Reporting Services Report and Filter Web Parts and Reports
Lab 9D: Reporting Services and PowerPivot
Lab 10: Performance Point
Lab 11A: Visio Services
Lab 11B: Access Services
Lab 12A: GeoSpatial Data with SQL Server
Lab 12B: Bing Maps
Lab 12C: .NET Charts
Lab 12D: Google Maps