Karlebovej 91, 3400 Hillerød | Krajbjergvej 3, 8541 Skødstrup
70 22 29 29
08:30 - 17:00

Managing SQL Business Intelligence Operations (MOC 10988)

Interesseret i dette kursus? Send os en forespørgsel.
Register your interest now

Kursusinfo

  • Dette kursus varer 3 dage
  • Der medfølger kursusmateriale til dette kursus
  • Dette kursus koster 3 klip på dit klippekort.
  • Fuld forplejning (Morgenmad, frokost, kage, kaffe og sodavand ad libitum)
  • Du har i alt adgang til din kursus-pc i 3 uger

Varighed

Dette kursus varer 3 dage

Materialer

Der medfølger kursusmateriale til dette kursus

Klip på klippekort

Dette kursus koster 3 klip på dit klippekort.

Forplejning

Fuld forplejning (Morgenmad, frokost, eftermiddagskage samt kaffe og sodavand ad libitum)

Remote adgang

Du har i alt adgang til din kursus-pc i 3 uger

Microsoft Vouchers

3 vouchers
Læs mere her

About this course
This three-day instructor-led course is aimed at database professionals who manage Business Intelligence (BI) operations. This course looks at various options that provide the ability of business users to analyze data and share their findings, starting with managed BI data sources and expanding to personal and external/public data sources.

Audience profile
The primary audience for this course are business intelligence professionals.

The secondary audiences for this course are technically proficient business users.

At course completion
After completing this course, students will be able to:
- Describe key features of a self-service BI solution
- Describe the key capabilities of SQL Server BI in a SharePoint environment
- Describe common Analysis Services operational tasks
- Describe PowerPivot for SharePoint server
- Describe Power Query
- Describe Windows Azure HDInsight

Course Outline

Module 1: Introduction to Microsoft SQL Server BI Solution
This module introduces key features of a self-service BI solution.

Lessons
Overview of self-service BI
Considerations of self-service BI
Microsoft tools for self-service BI

Lab : Exploring an enterprise BI solution
After completing this module, you will be able to:
Describe the concept of self-service BI
Explain when you would use self-service BI
Describe the Microsoft tools for self-service BI

Module 2: SQL Server BI Features with Microsoft SharePoint
This 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 environment

Lab : Design a SQL Server BI infrastructure
After 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 Services
This 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 recovery

Lab : Configuring analysis services
After 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 high-availability and disaster recovery

Module 4: Supporting Analysis Services
This module introduces PowerPivot for SharePoint server.

Lessons
Testing analysis services cubes
Tuning analysis services
Maintaining analysis services

Lab : Supporting Analysis Services
After completing this module, you will be able to:
Test analysis services
Tune analysis services
Maintain analysis services

Module 5: Operate and Support Reporting services
This 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 errors

Lab : Installing reporting services
After 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 Server
This module introduces PowerPivot for SharePoint.

Lessons
PowerPivot for SharePoint
Install and configure PowerPivot for SharePoint

Lab : Install PowerPivot for SharePoint
After 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 BI
This module introduces Windows Azure HDInsight.

Lessons
Power BI desktop
PowerBI.Com
Mobile Power BI

Lab : Using Power BI
After completing this module, you will be able to:
Install and Configure Power BI desktop
Implement Power BI dashboards
Describe mobile power BI

Lignende kurser

MCSE SQL 2016: Data Management & Analytics inkl. MCSA Database Admin (70-764 & 70-765 & 70-767) Skriv dig op som interesseret til dette kursus
Analyzing Big Data with Microsoft R 20773 (70-773) Skriv dig op som interesseret til dette kursus
Perform Big Data Engineering on Microsoft Cloud Services 20776 (70-776) Skriv dig op som interesseret til dette kursus
R Programmering Videregående 30 sep
MS Transact SQL (T-SQL) Programmering 26 aug