55063: Advanced SharePoint 2013 Business Intelligence Penang, Malaysia

55063: Advanced SharePoint 2013 Business Intelligence

55063: Advanced SharePoint 2013 Business Intelligence Course Description

Duration: 5.00 days (40 hours)

This 5-day Instructor Led course 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 to implement your BI Strategies and enable your decision makers to see data in new and dynamic ways! Also included are Power* features like PowerView, PowerQuery, PowerMap and PowerBI. You will also be exposed to Big Data topics such as Hadoop, HDInsight and StreamInsight. This course will take you down a path of building a BI environment from scratch to full interactive dashboards using the Microsoft BI Stack.

Intended Audience For This 55063: Advanced SharePoint 2013 Business Intelligence Course

  • » This course is intended for Sr. Business Intelligence Architects and Consultants, Sr. Business Analysts, anyone responsible for implementing BI with SharePoint.
  • 55063: Advanced SharePoint 2013 Business Intelligence Course 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.
    • 55063: Advanced SharePoint 2013 Business Intelligence Course Outline

        1. Module 1: Overview
          1. Understand your course, classroom, classmates, facility and instructor.
        2. Module 2: Business Intelligence
          1. Why Business Intelligence?
          2. Lab : Business Intelligence Worksheet
          3. Answer Business Intelligence Questions
        3. Module 3: Business Intelligence Center
          1. Business Intelligence Center
          2. Lab : Business Intelligence Center
          3. Create the Business Intelligence Center
          4. Explore SharePoint Business Intelligence Center
          5. Explore Dashboard Designer
        4. Module 4: Data Mart & Data Warehouses and Master Data Services
          1. Understanding Data and Data Formats
          2. Building Data Marts & Data Warehouses
          3. Master Data Services
          4. Lab : Data & Data Formats
          5. Explore Data Formats
          6. Lab : Build A Data Warehouse
          7. Create a Simple Data Warehouse
          8. Lab : Extract & Load
          9. Explore the Extract stage
          10. Lab : Transform & Load
          11. Explore Transform & Load stages
          12. Realize the importance of primary/unique keys
          13. Lab : Granularity
          14. Create Data Warehouse Granularity Levels
          15. Lab : Build A Data Mart
          16. Create a Data Mart
          17. Lab : Master Data Services
          18. Configure Master Data Services
          19. Create Data sources in Master Data Services
          20. Configure Master Data Services add-in
          21. Connect to MDS data
          22. Publish data changes
        5. Module 5: Business Connectivity Services and Secure Store
          1. Business Connectivity Services
          2. Secure Store
          3. Lab : BCS Basics
          4. Explore External Content Types
          5. Create a new External Content Type
          6. Create an External List
          7. Add items to External Lists
          8. Lab : BCS With Data Warehouse
          9. Creating an Large External List using ECTs
          10. Using Filters and External lists
          11. Creating and Configuring Entity Profile Pages
          12. Enable Revert To Self
          13. Lab : Office & BCS for BI
          14. Explore Office and BCS Integration
          15. Lab : BCS and OData
          16. Explore BCS models using OData as source
          17. Create external list from OData
        6. Module 6: Analysis Services, HDInsight and StreamInsight
          1. Analysis Services
          2. HDInsight & Hadoop
          3. StreamInsight
          4. Lab : Analysis Services
          5. Create Dimension and Fact tables with SSIS
          6. Lab : Building An Analysis Services Database
          7. Create a Analysis Services Database
          8. Create a Cube
          9. Create Dimensions
          10. Create Fact Tables
          11. Create a KPI
          12. Lab : Key Performance Indicators
          13. Create Status Indicator list in 2013
          14. Lab : Hadoop and Azure HDInsight
          15. Install Hadoop for Windows
          16. Configure Hadoop for Windows
          17. Export Hadoop data
          18. Render reports based on Hadoop data
          19. Use and configure HDInsight
          20. Install the Hadoop .NET SDK
          21. Install HDFS ODBC driver
          22. Build Reports using Excel and Power Query
          23. Lab : StreamInsight
          24. Install StreamInsight
          25. Setup demo application
          26. Write StreamInsight queries
        7. Module 7: Filter Web Parts
          1. Filter Web Parts
          2. Lab : Filter Web Parts
          3. Use each of the Filter Web Parts
        8. Module 8: Excel, Excel Services and Excel Web App
          1. Excel Services
          2. Lab : Create An Excel Report
          3. Create An Excel Report
          4. Lab : Excel Services
          5. Learn to use Excel Services
          6. Create/Publish to Excel Services
          7. Configure Excel Services
          8. Shared Data Connections
          9. Excel Interactive View
          10. Lab : MDX
          11. Explore Excel MDX features
          12. Create a Slicer
          13. Create an MDX Set
          14. Lab : Sparklines
          15. Use Excel Sparklines
          16. Lab : Filters & Excel Services
          17. Explore Filter Web Parts and Excel Services
          18. Lab : REST & Web Services
          19. Explore REST features of Excel Services
          20. Explore the Excel Services Web Service
        9. Module 9: PowerPivot, Tabular Data Sources
          1. PowerPivot For Excel
          2. PowerPivot For SharePoint
          3. Lab : Use PowerPivot
          4. Explore PowerPivot Functions
          5. Use Basic PowerPivot
          6. Use PowerPivot with Large DataSets
          7. Create PowerPivot Linked Tables
          8. Create Slicers
          9. Lab : Integrate Power Pivot and SharePoint
          10. Install PowerPivot for SharePoint Addin
          11. Install PowerPivot on Database Server
          12. Configure PowerPivot for SharePoint
          13. Publish to SharePoint
          14. Automating Data Refresh
          15. Analyzing Usage Data
          16. Lab : Tabular Models
          17. Create a Tabular Model Project
          18. Adding Data
          19. Creating Relationships
          20. Creating Calculated Columns and Measures
          21. Creating Key Performance Indicators
          22. Deploying Tabular models
          23. Analyzing data in Excel
          24. Lab : Import PowerPivot to SSAS
          25. Import PowerPivot to SSAS
        10. Module 10: Reporting Services
          1. In this module we will explore Reporting Services, its integration with SharePoint and how to build Reporting Services reports.
          2. Lessons
          3. Reporting Services
          4. Reports
          5. Lab : Install Reporting Services
          6. Configure Reporting Services
          7. Create a Reporting Services Report
          8. Configure Reporting Services Web Part
          9. Lab : Building Reports with Reporting Services
          10. Create Advanced Reporting Services report
          11. Filter Web Parts and Reports
          12. Lab : Automating Reports with Reporting Services
          13. Create Report Part Gallery
          14. Create a Report Library
          15. Create Report Parts
          16. Create a Report using Report Parts
          17. Automated Report Delivery
          18. Lab : Reporting Services and PowerPivot
          19. Setup Reporting Services RSS Feed
          20. Create and Use Data Feed Library
          21. Utilize Reporting Services data in PowerPivot
          22. Utilize PowerPivot data in Reporting Services
        11. Module 11: Power View, Power Query and Power BI
          1. Power View
          2. Power Query
          3. Power BI
          4. Lab : Use Power View
          5. Create PowerView view
          6. Utilize images in PowerView views
          7. Create Chart Visualizations
          8. Create Map Visualizations
          9. Work with slicers
          10. Work with multiples
          11. Work with sorting
          12. Work with Visualization Filters
          13. Deploy to SharePoint
          14. Export to PowerPoint
          15. Lab : Use Power Query
          16. Install Power Query
          17. Explore Power Query reports
          18. Create Power Query reports
          19. Lab : Use Power BI
          20. Install PowerBI Windows App
          21. Configure PowerBI
          22. Working with Power BI in O365
        12. Module 12: Performance Point
          1. Performance Point
          2. Lab : Performance Point
          3. Explore Performance Service Application
          4. Explore the Dashboard Designer
        13. Module 13: Visio & Access Services
          1. Visio Services
          2. Access Services
          3. Lab : Visio Services
          4. Use Visio Services
          5. Publish a Visio to SharePoint
          6. Utilize data driven Visio diagrams
          7. Utilize Visio for site architecture diagram
          8. Lab : Access Services
          9. Access and SharePoint integration
          10. Removed features
          11. Publish Access Database To SharePoint
          12. Explore Access Services 2013
        14. Module 14: GeoSpatial Data, GeoLocation and Power Map
          1. GeoSpatial Data
          2. GeoLocation, Bing Maps and Charts
          3. Power Map
          4. Lab : GeoSpatial Data with SQL Server
          5. Populate a SQL Server Database using Shape2SQL
          6. Utilize the new Spatial Data Types in SQL Server
          7. Create a Reporting Services Report using Geospatial Data
          8. Publish Geospatial Data to SharePoint
          9. Lab : Bing Maps and GeoLocation column
          10. Utilize Bing Maps API
          11. Create and use GeoLocation columns
          12. Create a Map View
          13. Explore SharePoint Store Map Apps
          14. Lab : Use Power Map
          15. Install Power Map
          16. Explore Power Map reports
          17. Create Power Map reports
          18. Create Power Map Tour and Scenes
          19. Lab : Use Power Map and Power Query
          20. Create Power Query Report
          21. Create Power Map from Power Query data
          22. Lab : NET Charts
          23. Import Chart web part file
          24. Utilize .NET Charts in 2013