Enable Technology



About Enable Technology Tonypandy SQL Server Analysis Services Training Courses

Enable Technology specialise in succinct skills based SQL Server Analysis Services training. We guarantee the training will be delivered by a Microsoft certified expert. Each person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials after the training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Analysis Services queries.

We provide instructor led training coupled with hands on training. Our SQL Server Analysis Services training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. If you prefer we can offer an offsite socially distanced training location in Tonypandy. Every SQL Server Analysis Services course can be modified to meet your bespoke requirements.

SQL Server Analysis Services courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Boots UK Limited, South Staffordshire Water PLC, Dollond & Aitchison Limited, Cadbury PLC, Birmingham City Council, National Power PLC, Norwich Union PLC and Shell UK Oil Products Ltd.

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Tonypandy
  • 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 Local Partitions
    Data Source object permissions
    Backup and Restore of Analysis Services Databases
    Delete a Data Source View Dimensions
    Attach and Detach Analysis Services Databases
    Read Definition permissions
    Error Configuration Roles and Permissions
    Dimension permissions
    BI Wizard
    Define Logical Primary Keys in a Data Source View
    Cube or model permissions Process permissions
    Create Named Sets
    Configure Measure Group Properties
    Define Logical Relationships in a Data Source View
    Overview of SSAS Multidimensional Modelling
    Define a Regular Relationship and Regular Relationship Properties
    Create a Dimension by Using an Existing Table
    Create Calculated Members
    Deploy Model Solutions Using XMLA
    Replace a Table or a Named Query in a Data Source View
    Multidimensional models

  • See Training Course Details...

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Tonypandy
  • 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 ...
  • Define partitions in DirectQuery models
    DirectQuery Mode
    Create and Manage Tabular Model Partitions
    Enable DirectQuery mode in SSMS
    Create and Manage Hierarchies Partitions
    Data sources supported in SSAS tabular 2017
    Delete Relationships
    Manage Roles by using SSMS
    Analyze a tabular model in Excel Deploy tabular model solutions
    DAX formula compatibility in DirectQuery mode Tables and Columns
    Object-level security
    Enable DirectQuery mode in SSDT
    Filter Data in a Table Relationships
    Add columns to a table
    Process Database, Table, or Partition
    Create and Manage Perspectives Translations Roles
    Analyze in Excel
    Import from Power Pivot
    Bi-directional cross filters  Calculations
    Import data by using a native query
    Rename a Table or Column

  • See Training Course Details...

Email us about this courses

Other Tonypandy Enable Technology Training Courses

PL/SQL - Tonypandy SQL Training Courses
TSQL - Tonypandy SQL Training Courses
SSRS Tonypandy Training Courses
Oracle SQL - Tonypandy SQL Training Courses
JQuery - Tonypandy JavaScript Training Courses
JQuery Mobile Tonypandy Training Courses