Managing SQL Business Intelligence Operations

M10988

Ημερομηνία Έναρξης
Σε αναμονή
Διάρκεια
24 hours
Κόστος
Εξέταση - Πιστοποίηση

Audience profile

  • BI professionals
  • Technically proficient business users.

Prerequisites

  • 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)

Course outline

Introduction to Operational Management in BI Solutions

  • Rationale for BI Operations
  • Roles in BI Operations
  • Technologies Used in BI Operations
  • Environment and Operational Standards

Configuring BI Components

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

Managing Business Intelligence Security

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

Deploying BI Solutions

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

Logging and Monitoring in BI Operations

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

Troubleshooting BI Solutions

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

Performance Tuning BI Queries

  • The Need for Performance Tuning
  • BI Queries to Performance Tune
  • Tools for Performance Tuning
  • Remediating Performance Issues

Δήλωσε Συμμετοχή

Προέκυψε κάποιο σφάλμα

Παρακαλούμε προσπαθήστε ξανά σε λίγο

Επιτυχής Εγγραφή

Σύντομα θα επικοινωνήσουμε μαζί σας.