Managing SQL Business Intelligence Operations (M10988)
COURSE OUTLINE:
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). Click here to purchase.
Audience
- BI professionals�
- Technically proficient business users?
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)
Learning Objectives
- 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
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