Font size:

In this course, you will learn about business intelligence (BI) solutions with Microsoft SQL Server 2016. You will learn about the Microsoft tools and key features of a self-service BI solution. Additionally, you will examine SQL Server BI in a SharePoint environment, which includes PowerPivot, analysis services, and reporting services (such as Power Query and Windows Azure HDInsight).�

GK Digital Learning is also available with digital Microsoft Official Courseware (dMOC).



Highlights:
  • Key features of a self-service BI solution
  • Key capabilities of SQL Server BI in a SharePoint environment
  • Common analysis services operational tasks
  • PowerPivot for SharePoint server
  • Power Query
  • Windows Azure HDInsight

Prerequisites:
  • Basic knowledge of data warehouse schema topology (including star and snowflake schemas)
  • Exposure to basic programming constructs (such as looping and branching)
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable
  • Familiarity with SharePoint Server and Microsoft Office applications (particularly Excel)
  • Basic knowledge of data warehouse schema topology (including star and snowflake schemas)
  • Exposure to basic programming constructs (such as looping and branching)
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable
  • Familiarity with SharePoint Server and Microsoft Office applications (particularly Excel)


Audience:
  • BI professionals�
  • Technically proficient business users?

1.�Introduction to Microsoft SQL Server BI Solution

  • Overview of Self-Service BI
  • Considerations of Self-Service BI
  • Microsoft Tools for Self-Service BI

2.�Configuring BI Components

  • Importance of Standardized Builds
  • Configuration Considerations for BI Technologies
  • BI Architectures
  • SharePoint BI Environments

3.�Managing Business Intelligence Security

  • Security Approach to BI Solutions
  • Security Components
  • Security Approach for BI Components
  • The Security Approach in Different BI Environments

4.�Deploying BI Solutions

  • Application Life Cycle Management for BI Solution
  • Stand-Alone Deployments
  • Team-Based Deployments

5.�Logging and Monitoring in BI Operations

  • The Need for Logging and Monitoring
  • Logging Options
  • Monitoring Options
  • Setting Up Alerts

6.�Troubleshooting BI Solutions

  • Troubleshoot Failed BI Solutions
  • Troubleshooting the Data Warehouse
  • Troubleshooting SQL Server Analysis Services
  • Troubleshooting SQL Server Reporting Services

7.�Performance Tuning BI Queries

  • The Need for Performance Tuning
  • BI Queries to Performance Tuning
  • Tools for Performance Tuning
  • Remediating Performance Issues
Find a class and register in three easy steps:
  • 1. Select Location:
  • 2. Select Date Range:
    to
  • 3. Select Class Type:
    • All Types
    • C Classroom
    • V Virtual Live
    • Cv In-Class Virtual
    • O Online
Virtual Live3/5/2018 8:30:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>3 days2195.002458250
Virtual Live4/9/2018 11:30:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>3 days2195.002458245
Virtual Live5/7/2018 8:30:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>3 days2195.002458249
seek-warrow-w
  • 1
arrow-eseek-eitems per page1 - 3 of 3 items