M20768 Developing SQL Data Models - Seminar / Kurs von brainymotion AG

Inhalte

This course is aimed at database professionals who fulfil a Business Intelligence (BI) developer role. Students will learn to implement multidimensional databases by using SQL Server Analysis Services (SSAS), and at creating tabular semantic data models.

Lernziele

1 - Introduction to Business Intelligence and Data ModelingIntroduction to Business IntelligenceThe Microsoft business intelligence platform2 - Creating Multidimensional DatabasesIntroduction to multidimensional analysisCreating data sources and data source viewsCreating a cubeOverview of cube security3 - Working with Cubes and DimensionsConfiguring dimensionsDefine attribute hierarchiesSorting and grouping attributes4 - Working with Measures and Measure GroupsWorking with measuresWorking with measure groups5 - Introduction to MDXMDX fundamentalsAdding calculations to a cubeUsing MDX to query a cube6 - Customizing Cube FunctionalityImplementing key performance indicatorsImplementing actionsImplementing perspectivesImplementing translations7 - Implementing a Tabular Data Model by Using Analysis ServicesIntroduction to tabular data modelsCreating a tabular data modelUsing an analysis services tabular model in an enterprise BI solution8 - Introduction to Data Analysis Expression (DAX)DAX fundamentalsUsing DAX to create calculated columns and measures in a tabular data model9 - Performing Predictive Analysis with Data MiningOverview of data miningUsing the data mining add-in for ExcelCreating a custom data mining solutionValidating a data mining modelConnecting to and consuming a data mining model

SG-Seminar-Nr.: 5150576

Anbieter-Seminar-Nr.: 855707768

Preis jetzt anfragen

Seminar merken ›

Sie buchen immer automatisch den besten Preis für jeden Termin. Semigator berücksichtigt

  • Frühbucher-Preise
  • Last-Minute-Preise
  • Gruppenkonditionen

und verfügt über Sonderkonditionen mit einigen Anbietern.

Der Anbieter ist für den Inhalt verantwortlich.

Über Semigator mehr erfahren

  • Anbietervergleich von über 1.500 Seminaranbietern
  • Vollständige Veranstaltungsinformationen
  • Schnellbuchung
  • Persönlicher Service