Training agenda
  1. Introduction to Business Intelligence and data modelling

    • Introduction to business analysis
    • Microsoft business analysis platform
  2. Developing multi-level databases

    • Introduction to multi-level analysis
    • Developing data sources and data source views
    • Creating cubes
    • A review of cube securities
  3. Working with cubes and dimensions

    • Configuring dimensions
    • Defining hierarchy attributes
    • Sorting and grouping hierarchy
  4. Working with measures and groups

    • Working with measures
    • Working with group of measures
  5. Introduction to MDX

    • MDX fundamentals
    • Adding calculated elements to the cube
    • Using MDX language to cube query
  6. Expanding the cube

    • The use of Key Performance Indicators
    • The use of actions
    • The use of persperctives
    • The use of translations
  7. Implementing array data model in Analysis Services

    • Introduction to array data model
    • Developing array data model
    • The use of array data model in company
  8. Introduction to Data Analysis Expressions (DAX)

    • DAX fundamentals
    • The use of DAX to create calculated columns and measures in array data model
  9. Performing predictive analysis with Data Mining

    • A review of Data Mining
    • The use of data mining add-on to Excel
    • Creating your own Data Mining solution
    • Data Mining model validation
    • Mreging and consuming data with data mining model