Enable Technology



About Enable Technology Wetherby SQL Server Analysis Services Training Courses

Enable Technology has twenty year track record of providing short intensive SQL Server Analysis Services skills based training courses. The tutor delivering the course will be a Microsoft certified expert. 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.

We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology SQL Server Analysis Services training courses can be delivered at your offices. We can supply the necessary software and computers. If delivery onsite is an issue we will organise a socially distanced venue near you in Wetherby. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.

This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.

The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are EDF Energy PLC, Birmingham City Council, Loughborough University, DHL Express, Dollond & Aitchison Limited, Countrywide Homes Limited, Halfords Group PLC and Shell UK Oil Products Ltd.

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Wetherby
  • 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 ...
  • Create Named Sets
    Cube or model permissions Process permissions
    Define a Referenced Relationship and Referenced Relationship Properties
    Define Time Intelligence
    Attach and Detach Analysis Services Databases
    Define a Data Source View
    Create Measures and Measure Groups
    Document and Script an Analysis Services Database
    Create a Data Source
    Set Impersonation Options for a Data Source Connection
    Define Logical Relationships in a Data Source View
    Define Assignments and Other Script Commands
    Tools and Approaches for Processing
    BI Wizard
    Using SQL Server Data Tools (SSDT)
    Explore Data in a Data Source View
    Create an Analysis Services Project
    Move an Analysis Services Database
    Use a Template to Create an Action Deployment
    Processing Options and Settings
    Configure Measure Group Properties

  • See Training Course Details...

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Wetherby
  • 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 ...
  • Bi-directional cross filters  Calculations
    Change table, column
    Create and Manage Hierarchies Partitions
    Tabular model designer
    Import from Power View
    Set the Data Type of a Column
    Create and Manage KPIs Hierarchies
    Specify Mark as Date Table for use with Time Intelligence
    Data sources supported in tabular 1200 models
    Create and Manage Roles
    Analyze in Excel
    Rename a Table or Column
    Process Database, Table, or Partition
    Sort Data in a Table
    Object-level security
    Enable DirectQuery mode in SSDT
    Create and Manage Perspectives Translations Roles
    Version comparison
    Create and Manage Tabular Model Partitions
    Import from Analysis Services
    Process Tabular Model Partitions

  • See Training Course Details...

Email us about this courses

Other Wetherby Enable Technology Training Courses

JavaScript Wetherby Training Courses
JQuery Wetherby Training Courses
Oracle SQL Wetherby Training Courses
PL/SQL - Wetherby SQL Training Courses
Excel 365 Intermediate Wetherby Training Courses
SQL Wetherby Training Courses