Võta ühendust:
+372 618 1720
info@koolitus.ee

MOC-20467 Designing Self-Service Business Intelligence and Big Data Solutions

MOC-20467

Maht: 5 päeva
Hind:
1 090 € (+ km 20%)

Koolituse kokkuvõte:

Autentne koolitus

This five-day instructor-led course teaches database and business intelligence (BI) professionals how to plan and design a BI solution that is based on Microsoft SQL Server 2014 and other Microsoft BI technologies.

Kellele koolitus on suunatud:

This course is not designed for students who are new to SQL Server 2014 BI technologies; it is targeted at BI professionals with experience of implementing solutions with SQL Server database Engine, SQL Server Integration Services, SQL Server Analysis Services, and SQL Server Reporting Services.

Koolitaja: Henn Sarv


Koolituse oodatav tulemus/eesmärk (õpiväljundid):

After completing this course, students will be able to:

  • Plan a BI solution.
  • Plan SQL Server BI infrastructure.
  • Design a data warehouse.
  • Design an extract, transform and load (ETL) solution.
  • Design analytical data models.
  • Plan a BI delivery solution.
  • Design a Reporting Services solution.
  • Design a Microsoft Excel-based reporting solution.
  • Plan a SharePoint Server BI solution.
  • Monitor and optimize a BI solution.
  • Operate a BI solution.

Lisatasu eest ligipääs iseseisvale harjutuskeskkonnale Microsoft Labs Online (MLO). Loe siit, mis on MLO.

Koolitusel osalemise eeldused (soovitavalt):

In addition to their professional experience, students who attend this training should already have the following technical knowledge:

  • A basic understanding of dimensional modeling (star schema) for data warehouses
  • Basic server hardware knowledge
  • The ability to create Integration Services packages that include control flows and data flows
  • The ability to create a basic multidimensional cube with Analysis Services
  • The ability to create a basic tabular model with PowerPivot and Analysis Services
  • The ability to create Reporting Services reports with Report Designer
  • The ability to implement authentication and permissions in the SQL Server database engine, Analysis Services, and Reporting Services
  • Familiarity with SharePoint Server and Microsoft Office applications – particularly Excel
Lisainfo:

Koolitushind sisaldab:

  • ametlikke õppematerjale;
  • koolitaja konsultatsiooni õpitud teemade kohta e-posti teel pärast koolitust;
  • tunnistust.

Lisaväärtusena pakume:

  • ühe Microsofti sertifitseerimiseksami sooritamise võimalust 6 kuu jooksul pärast koolitust;
  • võimalust osaleda tasuta korduskoolitusel, kui on soov teemasid korrata;
  • sooje jooke koos küpsistega;
  • lõunasööki igal koolituspäeval;
  • soodushinnaga registreerimise võimalust järgmisele kalendrikoolitusele;
  • tasuta parkimist.