Enable Technology



About Enable Technology Runcorn SQL Server Analysis Services Training Courses

Enable Technology SQL Server Analysis Services courses are short, skill focused and hands on. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. We provide every candidate with SQL Server Analysis Services training materials which they keep after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Analysis Services queries.

SQL Server Analysis Services courses are taught by a Microsoft Certified Solutions Expert. We are set up to deliver SQL Server Analysis Services training courses onsite at your premises. We are also more than happy to organise a local course at a socially distanced training location in Runcorn. The SQL Server Analysis Services syllabus can be modified to accommodate your specific training needs.

SQL Server Analysis Services courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.

Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Nuclear Engineering Services, Aston University, Keele University, Birmingham City University, Queen's Medical Centre Nottingham, Dollond & Aitchison Limited, Norwich Union PLC and Lloyds TSB Bank PLC.

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Runcorn
  • Telephone on 01952 938014
  • Course Outline
  • This intensive two day course is intended for SQL professionals and business intelligence professionals. The course covers the use of Analysis Services development tools to create and deploy multidimensional SSAS projects.

  • Some of the training topics covered include ...
  • Define Named Calculations in a Data Source View
    Move an Analysis Services Database
    Create Calculated Members
    Add or Remove Tables or Views in a Data Source View
    Partition Writeback Calculations
    Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
    Backup and Restore of Analysis Services Databases
    Create a Dimension by Generating a Non-Time Table in the Data Source
    Use a Template to Create an Action Deployment
    Using SQL Server Data Tools (SSDT)
    Configure Analysis Services Project Properties
    Error Configuration Roles and Permissions
    Create User-Defined Hierarchies
    Define a Regular Relationship and Regular Relationship Properties
    Calculations using the Business Intelligence Wizard
    Edit or Delete Partitions Merge Partitions
    Tools and Approaches for Processing
    Set Partition Storage
    Create a Data Source
    Add a Standard Action
    Test an Action

  • See Training Course Details...

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Runcorn
  • Telephone on 01952 938014
  • Course Outline
  • A two day intensive course detailing how to create, deploy, use and manage tabular models in Microsoft SQL Server Analysis Services (SSAS) . The course is aimed at Data Analysts and SQL professionals.  No prior knowledge of SSAS is assumed.

  • Some of the training topics covered include ...
  • Create and Manage KPIs Hierarchies
    Create and Manage Measures KPIs
    Data types supported
    Deploy from SQL Server Data Tools Manage Tabular Model Databases
    Database Process Partitions in the Workspace Database Perspectives
    Tabular model designer
    Delete a Column
    Create and Manage Partitions in the Workspace
    Import data by using a native query
    DirectQuery Mode
    Delete Relationships
    Import from Power View
    Filter Data in a Table Relationships
    Hide or freeze columns
    Topics include- Overview of SSAS Tabular models
    Bi-directional cross filters  Calculations
    Enable DirectQuery mode in SSDT
    Create a Relationship Between Two Tables
    Data sources supported in SSAS tabular 2017

  • See Training Course Details...

Email us about this courses

Other Runcorn Enable Technology Training Courses

Excel Power Pivot - Runcorn Excel Training Courses
TSQL - Runcorn SQL Training Courses
JavaScript Runcorn Training Courses
Power BI - Runcorn Microsoft Power BI Training Courses
Data Warehouse Runcorn Training Courses
Access VBA Runcorn Training Courses