Managing SQL Business Intelligence Operations
€1640, aangeboden door Master it Training
Deze driedaagse training richt zich op database professionals die verantwoordelijk zijn voor Business Intelligence operations. De cursus kijkt naar verschillende manieren om data te analyseren en het delen van resultaten, te beginnen met managed BI data sources. Dit breidt zich uit naar externe/publieke data sources.Bij afronding van de training kun je het volgende: De belangrijkste eigenschappen van een selfservice BI solution beschrijven; De key capabilities van SQL Server BI in een SharePoint omgeving beschrijven; Operational tasks in Common Analysis Services beschrijven; PowerPivot voor Sharepoint Server uitleggen; Power Query uitleggen; Windows Azure HDinsight uitleggen.
Let op. Deze training is exclusief het examen.
Doelgroep
De belangrijkste doelgroep voor deze cursus zijn business intelligence professionals.Daarnaast is deze cursus ook geschikt voor technisch onderlegde business users.
Voorkennis voor de Managing SQL Business Intelligence Operations training
Naast praktijkkervaring moeten deelnemers aan de cursus over de volgende technische kennis beschikken: Enige basiskennis over data warehouse schema’s (inclusief het star en snowflake schema); Enige programmeerkennis (zoals bijvoorbeeld looping en branching); Basiskennis over enkele bedrijfskundige begrippen, zoals omzet, winstgevendheid en financial accounting is aan te bevelen; Ervaring met SharePoint Server en Office programma’s – met name Excel.
Onderwerpen in de Managing SQL Business Intelligence Operations training
Module 1: Introduction to Microsoft SQL Server BI SolutionThis module introduces key features of a selfservice BI solution.Lessons Overview of selfservice BI Considerations of selfservice BI Microsoft tools for selfservice BILab : Exploring an enterprise BI solutionAfter completing this module, you will be able to: Describe the concept of selfservice BI Explain when you would use selfservice BI Describe the Microsoft tools for selfservice BI Module 2: SQL Server BI Features with Microsoft SharePointThis module describes the key capabilities of SQL Server BI in a SharePoint environment.Lessons Capabilities of Power BI with SharePoint SharePoint with analysis services SharePoint with reporting services Deploying SQL server BI in a SharePoint environmentLab : Design a SQL Server BI infrastructureAfter completing this module, you will be able to: Describe the capabilities of Power BI with SharePoint Describe the use of SharePoint with analysis services Describe the use of SharePoint with reporting services Deploy SQL Server in a SharePoint environment Module 3: Operating Analysis ServicesThis module describes common analysis services operational tasks.Lessons Configuring an analysis services server Tuning an analysis services server Analysis services security Analysis services high availability and disaster recoveryLab : Configuring analysis servicesAfter completing this module, you will be able to: Configure the analysis services server Tune the analysis services server Describe the analysis services security Implement analysis services highavailability and disaster recovery Module 4: Supporting Analysis ServicesThis module introduces PowerPivot for SharePoint server.Lessons Testing analysis services cubes Tuning analysis services Maintaining analysis servicesLab : Supporting Analysis ServicesAfter completing this module, you will be able to: Test analysis services Tune analysis services Maintain analysis services Module 5: Operate and Support Reporting servicesThis module introduces users to Power Query. They will use this more in subsequent modules.Lessons Installing a native mode report server Installing reporting services with SharePoint Reporting services with Microsoft Azure virtual machines Reporting services errorsLab : Installing reporting servicesAfter completing this module, you will be able to: Install a native mode reporting server Install reporting services with SharePoint Implement reporting services with Microsoft Azure virtual machines Describe reporting services errors Module 6: Share PowerPivot Workbooks in SharePoint ServerThis module introduces PowerPivot for SharePoint.Lessons PowerPivot for SharePoint Install and configure PowerPivot for SharePointLab : Install PowerPivot for SharePointAfter completing this module, you will be able to: Describe the capabilities of PowerPivot for SharePoint Install and Configure PowerPivot for SharePoint Module 7: Operate and Support Power BIThis module introduces Windows Azure HDInsight.Lessons Power BI desktop PowerBI.Com Mobile Power BILab : Using Power BIAfter completing this module, you will be able to: Install and Configure Power BI desktop Implement Power BI dashboards Describe mobile power BI