The SharePoint 2013 Business Intelligence course has been published to Microsoft Learning partners! It is the refresh of the wildly popular SharePoint 2010 Business Intelligence course. Some of the highlights include:
- Complete coverage of Power* tools (PowerView, PowerMap, PowerQuery, PowerPivot)
- Labs on StreamInsight and HDInsight
- Labs on Hadoop
- Labs on Master Data Services (MDS)
Here's the course outline:
- Business Intelligence
- Answer Business Intelligence Questions
- Business Intelligence Center
- Create the Business Intelligence Center
- Explore SharePoint Business Intelligence Center
- Explore Dashboard Designer
- Data Mart & Data Warehouses and Master Data Services
- Explore Data Formats
- Create a Simple Data Warehouse
- Explore the Extract stage
- Explore Transform & Load stages
- Realize the importance of primary/unique keys
- Create Data Warehouse Granularity Levels
- Create a Data Mart
- Configure Master Data Services
- Create Data sources in Master Data Services
- Configure Master Data Services add-in
- Connect to MDS data
- Publish data changes
- Business Connectivity Services and Secure Store
- Explore External Content Types
- Create a new External Content Type
- Create an External List
- Creating an Large External List using ECTs
- Using Filters and External lists
- Creating and Configuring Entity Profile Pages
- Enable Revert To Self
- Explore Office and BCS Integration
- Explore BCS models using OData as source
- Create external list from OData
- Analysis Services, HDInsight and StreamInsight
- Create Dimension and Fact tables with SSIS
- Create a Analysis Services Database
- Create a Cube
- Create Dimensions
- Create Fact Tables
- Create a KPI
- Install Hadoop for Windows
- Configure Hadoop for Windows
- Export Hadoop data
- Render reports based on Hadoop data
- Use and configure HDInsight
- Install the Hadoop .NET SDK
- Install HDFS ODBC driver
- Build Reports using Excel and Power Query
- Install StreamInsight
- Setup demo application
- Write StreamInsight queries
- Filter Web Parts
- Use each of the Filter Web Parts
- Integrate User Profiles with Filters and Reports
- Excel, Excel Services and Excel Web App
- Create An Excel Report
- Learn to use Excel Services
- Create/Publish to Excel Services
- Configure Excel Services
- Shared Data Connections
- Excel Interactive View
- Explore Excel MDX features
- Create a Slicer
- Create an MDX Set
- Use Excel Sparklines
- Explore Filter Web Parts and Excel Services
- Explore REST features of Excel Services
- Explore the Excel Services Web Service
- PowerPivot, Tabular Data Sources
- Explore PowerPivot Functions
- Use Basic PowerPivot
- Use PowerPivot with Large DataSets
- Create PowerPivot Linked Tables
- Create Slicers
- Install PowerPivot for SharePoint Addin
- Install PowerPivot on Database Server
- Configure PowerPivot for SharePoint
- Publish to SharePoint
- Automating Data Refresh
- Analyzing Usage Data
- Create a Tabular Model Project
- Adding Data
- Creating Relationships
- Creating Calculated Columns and Measures
- Creating Key Performance Indicators
- Deploying Tabular models
- Analyzing data in Excel
- Import PowerPivot to SSAS
- Reporting Services
- Configure Reporting Services
- Create a Reporting Services Report
- Configure Reporting Services Web Part
- Create Advanced Reporting Services report
- Filter Web Parts and Reports
- Create Report Part Gallery
- Create a Report Library
- Create Report Parts
- Create a Report using Report Parts
- Automated Report Delivery
- Setup Reporting Services RSS Feed
- Create and Use Data Feed Library
- Utilize Reporting Services data in PowerPivot
- Utilize PowerPivot data in Reporting Services
- Power View, Power Query and Power BI
- Create PowerView view
- Utilize images in PowerView views
- Create Chart Visualizations
- Create Map Visualizations
- Work with slicers
- Work with multiples
- Work with sorting
- Work with Visualization Filters
- Deploy to SharePoint
- Export to PowerPoint
- Install Power Query
- Explore Power Query reports
- Create Power Query reports
- Install PowerBI Windows App
- Configure PowerBI
- Working with Power BI in O365
- Performance Point
- Explore Performance Service Application
- Explore the Dashboard Designer
- Create A Scorecard
- Create A PP KPI
- Explore Time Intelligence
- Create Performance Point Reports
- Create Filters
- Create A Dashboard
- Visio & Access Services
- Use Visio Services
- Publish a Visio to SharePoint
- Utilize data driven Visio diagrams
- Utilize Visio for site architecture diagram
- Access and SharePoint integration
- Removed features
- Publish Access Database To SharePoint
- Explore Access Services 2013
- GeoSpatial Data, GeoLocation and Power Map
- Populate a SQL Server Database using Shape2SQL
- Utilize the new Spatial Data Types in SQL Server
- Create a Reporting Services Report using Geospatial Data
- Publish Geospatial Data to SharePoint
- Utilize Bing Maps API
- Create and use GeoLocation columns
- Create a Map View
- Explore SharePoint Store Map Apps
- Install Power Map
- Explore Power Map reports
- Create Power Map reports
- Create Power Map Tour and Scenes
- Create Power Query Report
- Create Power Map from Power Query data
- Import Chart web part file
- Utilize .NET Charts in 2013