20768 & 10990 Developing SQL Data Models and Analyzing Data with SQL Server Reporting Services

Loading Dogodki
DATUM: 25. 03. 2019 - 29. 03. 2019

20768 & 10990 Developing SQL Data Models and Analyzing Data with SQL Server Reporting Services

25. 03. 2019 - 29. 03. 2019

O izobraževanju

20768 Developing SQL Data Models
The focus of this 3-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures, and measure groups. This course helps you prepare for the Exam 70-768.

10990 Analyzing Data with SQL Server Reporting Services
This three-day instructor-led course teaches students how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization. The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions.

Komu je izobraževanje namenjeno

20768 Developing SQL Data Models
The primary audience for this course are database professionals who need to fulfil BI Developer role to create enterprise BI solutions. Primary responsibilities will include:
Implementing multidimensional databases by using SQL Server Analysis Services. Creating tabular semantic data models for analysis by using SQL Server Analysis Services.

10990 Analyzing Data with SQL Server Reporting Services
The primary audience for this course is database professionals who need to fulfil a BI developer role to create reports. Primary responsibilities will include implementing reports and mobile reports. The secondary audiences for this course are power information workers.

Katera znanja boste na izobraževanju pridobili

20768 Developing SQL Data Models

  • Describe the components, architecture, and nature of a BI solution
  • Create a multidimensional database with Analysis Services
  • Implement dimensions in a cube
  • Implement measures and measure groups in a cube
  • Use MDX syntax
  • Customize a cube
  • Implement a tabular database
  • Use DAX to query a tabular model
  • Use data mining for predictive analysis

10990 Analyzing Data with SQL Server Reporting Services

  • Describe key features of data modeling within business intelligence
  • Describe various report services data sources and how these are configured
  • Create reports with report designer and/or report designer
  • Configure reports with report designer and/or report builder
  • Create SQL Server mobile reports

Vsebina izobraževanja

20768 Developing SQL Data Models

  • Module 1: Introduction to Business Intelligence and Data Modeling
  • Module 2: Creating Multidimensional Databases
  • Module 3: Working with Cubes and Dimensions
  • Module 4: Working with Measures and Measure Groups
  • Module 5: Introduction to MDX
  • Module 6: Customizing Cube Functionality
  • Module 7: Implementing a Tabular Data Model by Using SQL Server Analysis Services
  • Module 8: Introduction to Data Analysis Expressions (DAX)
  • Module 9: Performing Predictive Analysis with Data Mining

10990 Analyzing Data with SQL Server Reporting Services

  • Module 1: Introduction to Business Intelligence and Data Modeling
  • Module 2: Reporting Services Data
  • Module 3: Implementing Reports
  • Module 4: Configuring Reports
  • Module 5: Create Mobile Reports

Potrebno predznanje
20768 Developing SQL Data Models
Experience of querying data using Transact-SQL

10990 Analyzing Data with SQL Server Reporting Services
In addition to their professional experience, students who attend this training should have technical knowledge equivalent to the following course: 20761A/B: Querying Data with Transact-SQL

Predavatelj
Danijel Novak, MCT

PROMO PONUDBA!
Ne spreglejte! Dva udeleženca istega tečaja za ceno enega! Doplačate le uradno gradivo za drugega udeleženca. Velja tudi za plačila s SA Training voucherji.

Cena
1.250,00 € + DDV = 1.525,00 €
ali 5 SA Training voucherjev

Cena z vključenim 22% DDV vključuje

  • organizacijo in strokovno izvedbo izobraževanja,
  • uradno Microsoft gradivo,
  • uradno Microsoftovo potrdilo o udeležbi,
  • blok in pisalo,
  • kosilo, osvežilne napitke in prigrizke.

Lokacija
SRC sistemske integracije d.o.o.
Tržaška cesta 116,
1001 Ljubljana

Podatki o udeležencu

Ime in priimek *

E-poštni naslov*

Telefon*

Del. mesto*

Ime in priimek

E-poštni naslov

Telefon

Del. mesto

Ime in priimek

E-poštni naslov

Telefon

Del. mesto



Podatki o plačniku

Naziv organizacije *

Ime *

Priimek*

Kontaktna oseba

Ime *

Priimek*

Kontaktni podatki

E-poštni naslov *

Telefon *

Naslov *

Poštna številka in kraj *

ID številka za DDV *

Način plačila *

Podrobnosti

Začetek:
25. 03. 2019
Konec:
29. 03. 2019
Dogodek Category: