Who the course is for The course is intended for database specialists and analysts who are tasked with advanced data analysis and want to take advantage of technology SQL Server Analysis Services After completing this course, [...]
  • GOC641
  • Duration 3 days
  • 30 ITK points
  • 7 terms
  • Praha (19 200 Kč)

    Brno (19 200 Kč)

    Bratislava (825 €)

  • Intermediate

Who the course is for

  • The course is intended for database specialists and analysts who are tasked with advanced data analysis and want to take advantage of technology SQL Server Analysis Services

After completing this course, students will be able to:

  • Describe Analysis Services
  • Create multidimensional databases
  • Work with cube and create dimensions
  • Work with measures and measure groups
  • Descripe transactions and concurrency
  • Use basic syntax of MDX language
  • Extend cube attributes
  • Analysis Services mantenance
  • Data mining overview
  • Use basic syntax of DAX language
  • Analysis Services Tabular model
  • How to choose right model

Required skills

  • Basic knowledge of the Microsoft Windows operating system and its core functionality
  • Working knowledge of Transact-SQL
  • Basick knowledge of data warehouses

Teaching methods

Expert instruction with practical examples, computer practice

Literature

Specialized book

Course Outline

Analysis Services Overview
  • Overview
  • Basic concepts
Multidimensional database
  • Datasource
  • Datasource view
  • Creation of cubes and dimensions
Advanced techniques of cube and dimension creation
  • Advanced cube creation
  • Advanced dimension creation
Work with measures
  • Measures
  • Measure groups
MDX fundamentals
  • MDX basic concepts
  • MDX basic syntax
  • Calculated members
Cube extensions
  • KPI
  • Actions
  • Perspectives
  • Translation
Analysis Services management
  • Deploy
  • Security
  • Processing
  • Automating tasks
Datamining fundamentals
  • Datamining structures
  • Datamining models
Datamining fundamentals
  • Datamining structures
  • Datamining models
PowerPivot
  • PoverPivot overview
  • How to create InMemory model using Excel
DAX fundamentals
  • Extending data model using DAX
  • Advanced DAX
  • Using DAX on agregated level
Analysis Services Tabular model
  • Working with Tabular model
  • Tabular vs. multidimensional
  • Tabular model maintenance
How to choose right data model
  • Model comparsion
  • Discusion with students

        »
        • The course is intended for database specialists and analysts who are tasked with advanced data analysis and want to take advantage of technology SQL Server Analysis Services
        • Describe Analysis Services
        • Create multidimensional databases
        • Work with cube and create dimensions
        • Work with measures and measure groups
        • Descripe transactions and concurrency
        • Use basic syntax of MDX language
        • Extend cube attributes
        • Analysis Services mantenance
        • Data mining overview
        • Use basic syntax of DAX language
        • Analysis Services Tabular model
        • How to choose right model
        • Basic knowledge of the Microsoft Windows operating system and its core functionality
        • Working knowledge of Transact-SQL
        • Basick knowledge of data warehouses
        Analysis Services Overview
        • Overview
        • Basic concepts
        Multidimensional database
        • Datasource
        • Datasource view
        • Creation of cubes and dimensions
        Advanced techniques of cube and dimension creation
        • Advanced cube creation
        • Advanced dimension creation
        Work with measures
        • Measures
        • Measure groups
        MDX fundamentals
        • MDX basic concepts
        • MDX basic syntax
        • Calculated members
        Cube extensions
        • KPI
        • Actions
        • Perspectives
        • Translation
        Analysis Services management
        • Deploy
        • Security
        • Processing
        • Automating tasks
        Datamining fundamentals
        • Datamining structures
        • Datamining models
        Datamining fundamentals
        • Datamining structures
        • Datamining models
        PowerPivot
        • PoverPivot overview
        • How to create InMemory model using Excel
        DAX fundamentals
        • Extending data model using DAX
        • Advanced DAX
        • Using DAX on agregated level
        Analysis Services Tabular model
        • Working with Tabular model
        • Tabular vs. multidimensional
        • Tabular model maintenance
        How to choose right data model
        • Model comparsion
        • Discusion with students
              Current offer
              Training location
              Course language

              The prices are without VAT.

              10.02.2025
              GOC641 Duration 3 days Type Online Live Language: CZ/SK GOPAS Praha online
              19 200 Kč
              24.02.2025
              GOC641 Duration 3 days Type Presence Language: CZ/SK GOPAS Praha
              19 200 Kč
              02.06.2025
              GOC641 Duration 3 days Type Presence Language: CZ/SK GOPAS Praha
              19 200 Kč
              09.06.2025
              GOC641 Duration 3 days Type Online Live Language: CZ/SK GOPAS Praha online
              19 200 Kč
              14.04.2025
              GOC641 Duration 3 days Type Presence Language: CZ/SK GOPAS Bratislava prezenčne
              825 €