10988 - Managing SQL Business Intelligence Operations
Corso
Online
Hai bisogno di un coach per la formazione?
Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.
Descrizione
-
Tipologia
Corso intensivo
-
Metodologia
Online
-
Ore di lezione
24h
-
Durata
3 Giorni
-
Inizio
Scegli data
Descrivere le caratteristiche fondamentali di una soluzione self-service di BI
Descrivere le funzionalità chiave di SQL Server BI in un ambiente SharePoint
Descrivere i comuni compiti operativi di Analysis Services
Descrivere PowerPivot per SharePoint Server
Descrivere Power Query
Descrivere Windows Azure HDInsight
Sedi e date
Luogo
Inizio del corso
Inizio del corso
Profilo del corso
Professionista IT
Una certa conoscenza di base della topologia di uno schema di data warehouse (es. schemi a stella e a fiocco di neve)Esposizione ai costrutti di base della programmazione (ad esempio, looping e branching)Auspicabile anche una consapevolezza delle priorità di business (es. entrate, redditività e contabilità finanziaria).
Opinioni
Successi del Centro
Tutti i corsi devono essere aggiornati
La media delle valutazioni dev'essere superiore a 3,7
Più di 50 opinioni degli ultimi 12 mesi
6 anni del centro in Emagister.
Materie
- E-business
- Informatica per adulti
- SQL
- Business intelligence
- Management
- Security
- Information tecnology
- Server
- Informatica per il settore informatico
- Informatica
- BI
- Life Cycle Management
Professori
Microsoft Certified Trainer
Microsoft Certified Trainer
Programma
CONTENUTI:
Module 1: Introduction to Operational Management in BI Solutions
Rationale for BI Operations
Roles in BI Operations
Technologies Used in BI Operations
Environment and Operational Standards
Lab : Introduction to Operational Management in BI Solutions
After completing this module, you will be able to:
Describe the rationale for BI operations.
Describe roles in BI operations.
Describe the technologies used in BI operations.
Describe environments and operational standards.
Module 2: Configuring BI Components
The Importance of Standardized Builds
Configuration Considerations for BI Technologies
BI Architectures
SharePoint BI Environments
Lab : Configuring BI Components
After completing this module, you will be able to:
Describe the importance of standardized builds.
Describe the configuration considerations for BI technologies.
Describe BI architectures.
Describe SharePoint BI environments
Module 3: Managing Business Intelligence Security
Security Approach to BI Solutions
Security Components
Security Approach for BI Components
The Security Approach in Different BI Environments
Lab : Managing Business Intelligence Security
After completing this module, you will be able to:
Describe the security approach to a BI solution.
Understand the security components available.
Apply the security components to BI technologies.
Manage security in different environments
Module 4: Deploying BI Solutions
Application Life Cycle Management for BI Solution
Stand-Alone Deployments
Team-Based Deployments
Lab : Deploying BI Solutions
After completing this module, you will be able to:
Understand application life-cycle management for BI solutions.
Understand stand-alone deployments.
Understand team-based deployments
Module 5: Logging and Monitoring in BI Operations
The Need for Logging and Monitoring
Logging Options
Monitoring Options
Setting Up Alerts
Lab : Monitoring BI Solutions
After completing this module, you will be able to:
Describe the need for logging and monitoring.
Use various logging options.
Use monitoring tools.
Set up notifications.
Module 6: Troubleshooting BI Solutions
Troubleshoot Failed BI Solutions
Troubleshooting the Data Warehouse
Troubleshooting SQL Server Analysis Services
Troubleshooting SQL Server Reporting Services
Lab : Troubleshooting BI Solutions
After completing this module, you will be able to:
Troubleshoot failed BI solutions
Troubleshoot data warehouses
Troubleshoot Analysis Services
Troubleshoot Reporting Services
Module 7: Performance Tuning BI Queries
The Need for Performance Tuning
BI Queries to Performance Tune
Tools for Performance Tuning
Remediating Performance Issues
Lab : Performance Tuning a BI Solution
After completing this module, you will be able to:
Understand the need for performance tuning.
Describe the BI queries required to carry out performance tuning.
Use the tools for performance tuning.
Remediate performance problems
Ulteriori informazioni
Costo materiale didattico: incluso nel prezzo del corso.
Natura del corso: Operativo (previsti lab su PC).
Hai bisogno di un coach per la formazione?
Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.
10988 - Managing SQL Business Intelligence Operations