-
Managing SQL Business Intelligence Operations (M10988)
Course ID: 261319 view dates
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 Live | 5/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 days | 2195.00 | 2881498 |
Virtual Live | 7/9/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 days | 2195.00 | 2881495 |
Virtual Live | 9/10/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 days | 2195.00 | 2881494 |