Dgroove S.r.l. - PCSNET Nordest

      MOC 20768 - Developing SQL Data Models

      Dgroove S.r.l. - PCSNET Nordest
      A Villafranca di Verona

      1.155 
      +IVA
      Preferisci chiamare subito il centro?
      04586... Leggi tutto
      Chiedi informazioni a un consulente Emagister

      Informazioni importanti

      Tipologia Corso
      Luogo Villafranca di verona
      Ore di lezione 21h
      Durata 3 Giorni
      Inizio Scegli data
      • Corso
      • Villafranca di verona
      • 21h
      • Durata:
        3 Giorni
      • Inizio:
        Scegli data
      Descrizione

      Descrivere i componenti, l'architettura, e la natura di una soluzione di BI
      Creare un database multidimensionale con servizi di analisi
      Implementare dimensioni in un cubo
      Implementare misure e gruppi di misure in un cubo
      Utilizzare la sintassi MDX
      Personalizzare un cubo
      Implementare un database tabulare
      Utilizzare DAX per interrogare un modello tabellare
      Utilizzare il data mining per l'analisi predittiva

      Strutture (1)
      Dove e quando
      Inizio Luogo
      Scegli data
      Scegli data
      Villafranca di Verona
      Via Monte Baldo 6, 37069, Verona, Italia
      Visualizza mappa
      Inizio Scegli data
      Scegli data
      Luogo
      Villafranca di Verona
      Via Monte Baldo 6, 37069, Verona, Italia
      Visualizza mappa

      Domande e risposte

      Comunicaci i tuoi dubbi,altri utenti potranno risponderti

      Cosa impari in questo corso?

      SQL
      Business intelligence
      Data Mining
      Developing
      Database
      Data Warehouse
      DAX
      Microsoft
      Microsoft Excel
      Microsoft SQL Server

      Programma

      Module 1: Introduction to Business Intelligence and Data ModelingIntroduction to Business IntelligenceThe Microsoft business intelligence platformLab : Exploring a Data WarehouseAfter completing this module, you will be able to:Describe the concept of business intelligenceDescribe the Microsoft business intelligence platformModule 2: Creating Multidimensional DatabasesIntroduction to multidimensional analysisCreating data sources and data source viewsCreating a cubeOverview of cube securityLab : Creating a multidimensional databaseAfter completing this module, you will be able to:Use multidimensional analysisCreate data sources and data source viewsCreate a cubeDescribe cube securityModule 3: Working with Cubes and DimensionsConfiguring dimensionsDefine attribute hierarchiesSorting and grouping attributesLab : Working with Cubes and DimensionsAfter completing this module, you will be able to:Configure dimensionsDefine attribute hierarchies.Sort and group attributesModule 4: Working with Measures and Measure GroupsWorking with measuresWorking with measure groupsLab : Configuring Measures and Measure GroupsAfter completing this module, you will be able to:Work with measuresWork with measure groupsModule 5: Introduction to MDXMDX fundamentalsAdding calculations to a cubeUsing MDX to query a cubeLab : Using MDXAfter completing this module, you will be able to:Describe the fundamentals of MDXAdd calculations to a cubeQuery a cube using MDXModule 6: Customizing Cube FunctionalityImplementing key performance indicatorsImplementing actionsImplementing perspectivesImplementing translationsLab : Customizing a CubeAfter completing this module, you will be able to:Implement key performance indicatorsImplement actionsImplement perspectivesImplement translationsModule 7: 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 solutionLab : Working with an Analysis services tabular data modelAfter completing this module, you will be able to:Describe tabular data modelsCreate a tabular data modelBe able to use an analysis services tabular data model in an enterprise BI solutionModule 8: Introduction to Data Analysis Expression (DAX)DAX fundamentalsUsing DAX to create calculated columns and measures in a tabular data modelLab : Creating Calculated Columns and Measures by using DAXAfter completing this module, you will be able to:Describe the fundamentals of DAXUse DAX to create calculated columns and measures in a tabular data modelModule 9: 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 modelLab : Perform Predictive Analysis with Data MiningAfter completing this module, you will be able to:Describe data miningUse the data mining add-in for ExcelCreate a custom data mining solutionValidate a data mining solutionConnect to and consume a data mining solution