Teknologisk Institut

Managing SQL Business Intelligence Operations [10988]
0%
Managing SQL Business Intelligence Operations [10988]

Managing SQL Business Intelligence Operations [10988]

Beskrivelse


Dette kursus fokuserer på integrationen og tuning af de produkter som indgår i en Self-Service BI-løsning som fx SharePoint, Analysis Services, Reporting Services, PowerPivot og PowerQuery. Desuden lærer du at vedligeholde og håndtere Microsoft SQL Server Business Intelligence Operations herunder rapportering og analyse af data, og hvordan disse informationer kan deles med andre gennem de forskellige teknologier.

Deltagerprofil
Kurset er for dig, der til daglig arbejder med Business Intelligence.
Du forventes at have grundlæggende kendskab til SQL Server og Data Warehouse begreber samt være bekendt med grundlæggende programmeríngsbegreber. Derudover forventes du at have praktisk kendskab til SharePoint Server og Mircosoft Office (Excel).

Indhold

Module 1: Introduction to Microsoft SQL Server BI Solution


Overview of self-service BI



Considerations of self-service BI



Microsoft tools for self-service BI




Module 2: SQL Server BI Features with Microsoft SharePoint


Capabilities of Power BI with SharePoint



SharePoint with analysis services



SharePoint with reporting services



Deploying SQL server BI in a SharePoint environment




Module 3: Operating Analysis Services
...%%%

...

Configuring an analysis services server



Tuning an analysis services server



Analysis services security



Analysis services high availability and disaster recovery




Module 4: Supporting Analysis Services


Testing analysis services cubes



Tuning analysis services



Maintaining analysis services




Module 5: Operate and Support Reporting services


Installing a native mode report server



Installing reporting services with SharePoint



Reporting services with Microsoft Azure virtual machines



Reporting services errors




Module 6: Share PowerPivot Workbooks in SharePoint Server


PowerPivot for SharePoint



Install and configure PowerPivot for SharePoint




Module 7: Operate and Support Power BI


Power BI desktop



PowerBI.Com



Mobile Power BI




Microsoft Software Assurance Vouchere
Kurset kan betales med 3 SA vouchere.

Underviser
Undervisningen varetages af en erfaren underviser fra Teknologisk Instituts netværk bestående af branchens dygtigste undervisere.



Managing SQL Business Intelligence Operations [10988]

11.499,00 kr

+45 23 33 30 30

npk@kursuszonen.dk