Enable Technology



About Enable Technology Dyfed SQL Server Analysis Services Training Courses

We offer intensive two and three days SQL Server Analysis Services courses. All Enable Technology tutors are Microsoft certified experts. 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.

Enable Technology SQL Server Analysis Services courses are instructor led and taught by an experienced Microsoft expert. Enable Technology can supply all of the equipment necessary to deliver SQL Server Analysis Services courses onsite at your offices. You simply need to provide a suitable room. The SQL Server Analysis Services course could also be scheduled at a socially distanced site near you in Dyfed. We will work with you prior to the course to tailor the SQL Server Analysis Services syllabus to match your requirements.

We can also deliver SQL Server Analysis Services courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.

In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Birmingham Heartlands Hospital, Nationwide Building Society Limited, University of Birmingham, Shell UK Oil Products Ltd, Vodafone Group Services, Canadian High Commission, Total Telecommunications Limited and West Bromwich Building Society.

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Dyfed
  • 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 Measures and Measure Groups
    Define Attribute Relationships
    Deploy Model Solutions Using XMLA
    Test an Action
    Use Aggregate Functions
    Create Named Sets
    Batch Processing Remote Processing
    Deploy Model Solutions with the Deployment Utility
    KPIs Actions
    Create a Time Dimension by Generating a Time Table
    Supported Data Sources
    Delete a Data Source
    Use a Template to Create an Action Deployment
    Rename a Multidimensional Database Processing a multidimensional model
    Data Source object permissions
    Move an Analysis Services Database
    Set Partition Storage
    Create a Dimension Using the Dimension Wizard
    Define a Data Source View
    Configure Analysis Services Project Properties
    Change a Partition Source

  • See Training Course Details...

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Dyfed
  • 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 ...
  • Row filter mappings
    Test a model in DirectQuery mode
    Analyze a tabular model in Excel Deploy tabular model solutions
    Create and Manage Roles
    Change table, column
    Import Data
    Data sources supported in tabular 1200 models
    Create and Manage Hierarchies Partitions
    Import from Analysis Services
    Connect to a tabular model database
    Data types supported
    Create and Manage Partitions in the Workspace
    Bi-directional cross filters  Calculations
    DirectQuery Mode
    Import from Power Pivot
    Create a Relationship Between Two Tables
    Create and Manage KPIs Hierarchies
    Filter Data in a Table Relationships
    Object-level security
    Add a table Delete a Table
    Manage Roles by using SSMS

  • See Training Course Details...

Email us about this courses

Other Dyfed Enable Technology Training Courses

JQuery Mobile Dyfed Training Courses
Excel 365 Intermediate Dyfed Training Courses
Access VBA Dyfed Training Courses
SSRS Dyfed Training Courses
PL/SQL - Dyfed SQL Training Courses
TSQL Dyfed Training Courses