SharePoint 2013 Training Videos Business Intelligence


4 in 1 Pack

Learn all the topics covered in:

19 Hours of Videos Tutorials
Take advantage of 19 hours of organized SharePoint presentations and demonstrations in HD quality.
23 Hours of Hands on Labs
Practice your skills with step by step hands on labs that can be completed on a SharePoint 2013 or Office 365 Online.
Practice on Virtual Environment
We provide a complete SharePoint virtual environment, preloaded with Office, Designer, InfoPath, and Visual Studio.
No Subscription Fees
With no expirations or monthly subscription fees, you can refresh your skills any time without breaking the bank.
Focus on Topics that Matter
We create courses that integrate real world experiences from some of largest successful SharePoint implementations.
Play on Mobile Devices
Our training can deliver the same amazing experience on your laptop, tablet, and mobile phone.

Learn essential business intelligence features and tools available in SharePoint. The class starts with the basics and then thoroughly cover each major area of functionality. By the end of the course, the student should understand the advantages, capabilities, and implementation of reports in a particular tool.

Learn the following topics:

  • All the topics covered in the Fundamentals, and Administration courses
  • Understand business intelligence concepts and terminology
  • Understand different business Intelligence styles, roles, products, and tools.
  • Design reports in Excel utilizing pivot tables, slicers, spark lines, and conditional formatting
  • Publish Excel reports to SharePoint Excel Services and understand all the SharePoint options
  • Create tabular data models in Excel with PowerPivot and publish to SharePoint
  • Utilize measures, hierarchies, perspectives, KPIs, and DAX in PowerPivot
  • Use Report Builder to create and publish reports to SharePoint Reporting Services
  • Use PerformancePoint Services to create reports on Analysis cubes
  • Learn how to publish Visio Diagrams based on data sources into SharePoint

SECTION 1 - Fundamentals

Power User / Site Administrator
    Definitions, History, and Expectations 3m 59s
  • Definitions
  • History
  • Editions
  • How to Make SharePoint Successful
    Sites, Lists, Versioning 2h 34m 37s
  • Site Collection
  • Site
  • Navigation
  • Features
    • Site template comparison
  • Navigation
  • List = App
    • Columns
    • Views
    • Sharing
    • Collaborative editing and OneDrive Pro
    • Versioning
    • Alerts and popularity
  • List specific features
    • Connect to Outlook
    • Calendar aggregation
    • Task indents and timeline
    Social, User Profiles, My Site 27m 01s
  • User Profile and Personal content
    • Basic information
    • Contact and details
    • Personal site and files
  • Task aggregation on my site - synchronization all tasks from all site collections to person's my site
  • Newsfeed and Following
    • Commenting, hashtags, likes
    • Aggregation and settings
    • Follow sites, people, hashtags
  • Community site template
    • Discussions
    • Reputation and badges
    Pages, Web Parts, Apps, and Themes 27m 33s
  • Types of Pages
  • Web parts
    InfoPath in SharePoint 48m 22s
  • Form design
    • Fields/columns
    • Visual layout
      • Two column layout
      • Four column layout
    • Logic
      • Rules
      • Validation
      • Hide/show controls
    • External data
      • Get data from other SharePoint lists or databases
  • InfoPath Form Web Part
  • list forms vs. form library
    • digital signatures
    • complicated schema -not all fields stored in SharePoint list
    Workflows with SharePoint Designer 56m 46s
  • Introduction
  • Two platforms and what’s new in 2013
  • Definitions
  • Stages, steps, and loops
  • Conditions and branches
  • Actions and variables
  • Workflow types and association
  • Information Management Polices
  • Export and import workflows
    Security Authorization 30m 28s
  • Permissions and Permission Levels
  • Site Collection Administrator
  • Authentication vs. Authorization
  • What provides authentication
  • Who can assign permissions
  • SharePoint groups
  • Web Part to show users and SharePoint groups that have access to the site
    Site Administration Tools 20m 24s
  • List and Site Templates
  • List View thresholds
  • Features
  • Manage Content and Structure Tool
  • Usage Analysis
    Project: Libraries and Lists 40m 51s
  • Setup Research Papers library with folders and metadata
  • Setup Area for Industry Clinic project management

    SECTION 2 - Administration

    Enterprise Content Manager / Administrator / Project Manager
    Site Collection Management16m 22s
  • Definition
  • Why separate site collections
  • Management
    Site Columns 17m 02s
  • Site Columns definition
  • Scopes and updates
    Managed Metadata 30m 07s
  • Terms sets and term groups
  • Local vs. Global context
  • Enterprise keywords
  • Social tags
  • Search refinement based on metadata
    Content Types 57m 49s
  • Content type use cases
  • Content type hierarchies and inheritance
  • Using content types to create information architecture
  • Document templates
  • 2010 Workflows and information management policies for content types
  • Content Type Syndication Hub
    • How it works
    • Relation to managed metadata
    • View and other settings
    Document sets 17m 01s
  • Metadata and page layouts
  • Versioning and workflows
  • Document ids
    User Profiles 13m 19s
  • User profile properties
  • Audiences
  • My site settings
    Search Administration 37m 41s
  • Content Sources and Crawl Rules
  • Properties
  • Refinement in search web parts
  • Query Rules
  • Analytics
  • Entity Extraction
    Final Project 26m 16s
  • Metadata and Search
    Records Management 34m 22s
  • In place records management
  • Record center template and use of content types
  • Making documents into records using workflows
  • eDiscovery cases
    • eDiscovery sets
    • Sources
    • Custodians
    • Queries
    External Data and Business Data Services 19m 13s
  • Data Sources and Data Views
  • Secure Store Service
    • Application definitions
    • Credentials
  • Business Data Services
    • External content types and lists in SharePoint Designer
    • Editing forms using InfoPath Forms
    Publishing for Intranet Portals 1h 25m 54s
  • Publishing pages, content types, and page layouts
  • User friendly URLs based on managed metadata term sets
  • Custom master pages and layouts using SharePoint Designer and Design Manager
  • Custom display templates for search results
  • Aggregation and search of pages in a site collection or on other site collections
    • Content Query
    • Search Query

    SECTION 3 - Business Intelligence

    Business Users / Administrators / Architects / Power Users
    Introduction 13m 37s
  • Information Collection, Analysis, and Delivery
  • Business Intelligence Styles and Roles
    • Self Service and Business Reporting by Business Analysts
    • Performance Monitoring and Scorecarding by Business Analysts
    • Parameterized and Operational Monitoring by IT
  • Microsoft Products and how they interact
    • SQL
    • Client
    • SharePoint
    Terminology 11m 58s
  • Pivot table
  • BI Models
    • Tabular model
      • DAX
      • Calculated columns
      • Measures and hierarchies
      • KPIs
    • Multidimensional model
      • Cube
      • Measures and Dimensions
      • MDX
  • KPIs and Scorecards Web Applications, Content Databases, and Service
    Data Connections and Secure Store Service 22m 45s
  • Data connections formats
    • Location
      • Embedded
      • Data connections libraries
    • Authentication
      • Windows authentication
      • Secure Store
  • Data refreshes
    Excel Services 30m 21s
  • Roles
  • Designing reports in Excel
    • What's not allowed
    • Tables and pivot tables
    • Slicers
    • Conditional formatting and sparklines
      • Color scales and data bars
      • Top bottom values
      • Icons
  • Reports in SharePoint
    • Publishing options
      • Which sheets to publish
      • Permissions
      • Data refresh
    • Embedding reports
      • Excel access web part
      • REST api
    • Web parts and filters
  • Excel service application settings
    • Architecture
    • Trusted locations
    • Trusted data connection libraries
    Excel with PowerPivot 35m 19s
  • Relationships between tables
  • DAX
  • Calculated columns
  • Hierarchies
  • KPIs
  • Perspectives
  • Manage PowerPivot Data Refresh
    Reporting Services 44m 12s
  • Tools comparison
  • SharePoint Integration
  • Report Builder
    • Data sources and data connections
    • Shared data sets
    • Report templates and web parts
    • Pull or push delivery
  • PowerView
    • Consuming PowerPivot data models
    • Visualizations
  • Configure Reporting Services Application
    Performance Point Services 13m 02s
  • Purpose
  • Data sources
    • Analysis services
    • Other data sources: tables, SharePoint lists (many feature will not be available)
  • Dashboard Designer
    • KPIs and KPI Details
    • Scorecards
    • Analytical Charts
    • Decomposition tree
    • Strategy map
    Visio Graphics Service 14m 05s
  • Creating diagrams
  • Data sources
  • Publishing to SharePoint
    • Service application settings
    Business Data Connectivity 9m 52s
  • External Content Types
  • Editing the XML file directly
  • Using Business Data List and Item Web Parts

    End User | Power User (Bonus)

    End Users / Site Administrator
    Introduction 6m 24s
    Finding Content 29m 41s
  • Global navigation
    • Top link bar - global navigation
    • Sites (promoted and followed)
    • Tree view
  • Site navigation
    • Quick launch - current navigation
    • Site contents
    • Tree view and metadata
    • Breadcrumb
  • List navigation
    • View selection
    • Filters and metadata navigation
    • Ribbon and context menu
    • Focus on content
  • Search
    List 39m 00s
  • Creation
  • Columns
  • Meta data navigation
  • Views
  • Form configuration
  • Versions
  • Alerts
    Documents 45m 57s
  • Columns, views, managed metadata
  • Editing documents
    • Co-authoring and track changes
    • Using Office Web Apps
  • Syncing to local computer using OneDrive Pro
  • Versions
    • When versions are created
    • Check out and check in
    • Major, minor, and approval
  • Folders vs metadata
    Tasks 20m 01s
  • Organization for project management
    • Indents
      • Keyboard short cuts
    • Time line
      • Call outs and milestones
      • Fonts
      • Width lock
      • Project summary web part
  • Staying informed
    • Aggregation on my site
    • Assignment of ownership email notification
    • Daily alert summaries
    • Connect to Outlook
    Calendars 12m 02s
  • Views
  • Connect to Outlook
  • Overlays in SharePoint
    Basic Workflows 13m 59s
  • Definitions
  • Review and Approval
  • Create workflow association
  • Starting workflow on an item
  • Participating in a workflow
    Pages, Web Parts, and Apps 24m 59s
  • Web parts
  • Apps
  • Types of pages
    • Standard
    • Wiki
    • Publishing
    • Application
    Social, User Profiles, My Site 12m 40s
  • My site, user profile, and personal site
  • Follow site, people, hashtags, mentions
  • Site newsfeed
    • Commenting
    • Aggregation