20768 DEVELOPING SQL DATA MODELS

Duration: 2 days , Course language: finnish, Material language: english, Material: pdf
20768 DEVELOPING SQL DATA MODELS, ei tenttiä
1 Pcs
20768 DEVELOPING SQL DATA MODELS (2 days), 19.09.2019
1390 €
+ vat.. 24%.
Oppiasopimus price: 1 390,00€

Description

KURSSIN SISÄLTÖ

MODULE 1: INTRODUCTION TO BUSINESS INTELLIGENCE AND DATA MODELING

  • Introduction to Business Intelligence
  • The Microsoft business intelligence platform

MODULE 2: CREATING MULTIDIMENSIONAL DATABASES

  • Introduction to multidimensional analysis
  • Data sources and data source views
  • Cubes
  • Overview of cube security
  • Configure SSAS
  • Monitoring SSAS

MODULE 3: WORKING WITH CUBES AND DIMENSIONS

  • Configuring dimensions
  • Define attribute hierarchies
  • Implementing Sorting and Grouping Attributes
  • Slowly Changing Dimensions

MODULE 4: WORKING WITH MEASURES AND MEASURE GROUPS

  • Working with measures
  • Working with measure groups

MODULE 5: INTRODUCTION TO MDX

  • MDX fundamentals
  • Adding calculations to a cube
  • Using MDX to query a cube

MODULE 6: CUSTOMIZING CUBE FUNCTIONALITY

  • Implementing key performance indicators
  • Implementing actions
  • Implementing perspectives
  • Implementing translations

MODULE 7: IMPLEMENTING A TABULAR DATA MODEL BY USING ANALYSIS SERVICES

  • Introduction to tabular data models
  • Creating a tabular data model
  • Using an analysis services tabular model in an enterprise BI solution

MODULE 8: INTRODUCTION TO DATA ANALYSIS EXPRESSION (DAX)

  • DAX fundamentals
  • Using DAX to create calculated columns and measures in a tabular data model

MODULE 9: PERFORMING PREDICTIVE ANALYSIS WITH DATA MINING

  • Overview of data mining
  • Using the data mining add-in for Excel
  • Creating a custom data mining solution
  • Validating a data mining model
  • Connecting to and consuming a data mining model
  • Using the Data Mining add-in for Excel


Schedule

Date
Start time
End time
Nb!
19.09.2019
09:00
16:00
20.09.2019
09:00
16:00
Cancellation terms

Ilmoittautuminen on sitova. Mikäli ilmoittautuja ei pääse kurssille, voi hänen sijastaan tulla toinen henkilö. Mikäli ilmoittautumisen peruutus tehdään vähemmän kuin 14 päivää ennen kurssin alkua, veloitamme toimisto- ja varauskuluina 50% kurssimaksusta. Mikäli ilmoittautunut jää saapumatta kurssille ilman peruutusilmoitusta, veloitamme koko osallistumismaksun. Kurssimateriaalin toimittamisesta oppilaalle peruuntumistapauksessa veloitamme lisäksi 100 EUR. Peruutusmaksut veloitetaan myös sairastapauksissa.

Your course or event to Oppia.fi?

Contact us!