Enable Technology



About Enable Technology Tonypandy SQL Server Analysis Services Training Courses

We have a twenty year history of providing skills based SQL Server Analysis Services industry training. All Enable Technology tutors are Microsoft certified experts. Every course participant is given SQL Server Analysis Services courseware which they can refer to 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.

SQL Server Analysis Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology SQL Server Analysis Services courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. We also offer the option of scheduling of SQL Server Analysis Services course at a socially distanced venue near you in Tonypandy. The SQL Server Analysis Services syllabus can be modified to accommodate your specific training needs.

SQL Server Analysis Services courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Countrywide Homes Limited, Nationwide Building Society Limited, Norwich Union PLC, Vodafone Group Services, Birmingham City Council, Yell Group PLC, EDF Energy PLC and Royal Air Force.

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 ...
  • Set Data Source Properties
    Replace a Table or a Named Query in a Data Source View
    Use Aggregate Functions
    Create User-Defined Hierarchies
    Create a Data Source
    KPIs Actions
    Batch Processing Remote Processing
    Create Calculated Members
    Use a Template to Create an Action Deployment
    Defined Linked Measure Groups Partitions
    Change a Partition Source
    Create Local Partitions
    Define a Referenced Relationship and Referenced Relationship Properties
    Supported Data Sources
    Read Definition permissions
    Data Source object permissions
    Create a Time Dimension by Generating a Time Table
    Multidimensional models
    Deployment Requirements and Considerations for Analysis Services Deployment
    Define Logical Primary Keys in a Data Source View
    Modify or Delete in Solution Explorer Database Dimensions

  • 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 ...
  • Data sources supported in SSAS  tabular 2016 Create Tabular Models
    Delete Relationships
    Delete a Column
    DirectQuery Mode
    Bi-directional cross filters  Calculations
    Create and Manage Roles
    Import from Power View
    Topics include- Overview of SSAS Tabular models
    Analyze a tabular model in Excel Deploy tabular model solutions
    Import from Analysis Services
    Process Database, Table, or Partition
    Import Data
    Data types supported
    Data sources supported in tabular 1200 models
    Tabular model designer
    Create a Calculated Table
    Deploy from SQL Server Data Tools Manage Tabular Model Databases
    Add columns to a table
    Import data by using a native query

  • See Training Course Details...

Email us about this courses

Other Tonypandy Enable Technology Training Courses

SSRS - Tonypandy SQL Server Reporting Services Training Courses
TSQL Tonypandy Training Courses
JQuery - Tonypandy JavaScript Training Courses
SQL - Tonypandy SQL Training Courses
Access Tonypandy Training Courses
VBA Tonypandy Training Courses