Enable Technology



About Enable Technology Risca SQL Server Analysis Services Training Courses

We have a twenty year history of providing skills based SQL Server Analysis Services industry training. All of our tutors are Microsoft Certified Professionals. Every course participant is given SQL Server Analysis Services courseware which they can refer to after the training. Enable Technology offer post course help to all delegates. Participants on the SQL Server Analysis Services course can contact the tutor for as long as they like if they encounter SQL Server Analysis Services problems.

Enable Technology training courses are delivered as instructor led courses. We can set up a training lab at your premises and deliver SQL Server Analysis Services courses onsite at your site. Alternatively we could schedule a SQL Server Analysis Services course at an alternative training site in Risca. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite SQL Server Analysis Services course to some extent is bespoke and tailored to your needs.

We also deliver this course online through virtual classrooms. Delegates can join scheduled SQL Server Analysis Services classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.

Our teaching team have over twenty years continuous technical training experience. Our clients include: Countrywide Homes Limited, Total Telecommunications Limited, Royal & Sun Alliance Group PLC, Halfords Group PLC, Carillion PLC, Yell Group PLC, University of Birmingham and Aston University.

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Risca
  • 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 ...
  • Deploy from SQL Server Data Tools Manage Tabular Model Databases
    Process Tabular Model Partitions
    Create a New Tabular Model Project
    Create and Manage Roles
    Data sources supported in SSAS  tabular 2016 Create Tabular Models
    Set the Data Type of a Column
    Delete Relationships
    Import from Power View
    Specify Mark as Date Table for use with Time Intelligence
    Create and Manage Perspectives Translations Roles
    Delete a Column
    Analyze a tabular model in Excel Deploy tabular model solutions
    Database Process Partitions in the Workspace Database Perspectives
    Data sources supported in tabular 1200 models
    Data sources supported in SSAS tabular 2017
    Bi-directional cross filters  Calculations
    Import from Analysis Services
    Test a model in DirectQuery mode

  • See Training Course Details...

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Risca
  • 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 ...
  • Attach and Detach Analysis Services Databases
    Calculations using the Business Intelligence Wizard
    Processing Databases, Dimensions and Partitions
    Deploy Model Solutions Using XMLA
    Create Calculated Members
    Add a Standard Action
    Database permissions
    Delete a Data Source
    Processing Options and Settings
    Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
    Using SQL Server Data Tools (SSDT)
    Configure Measure Group Properties
    Set Impersonation Options for a Data Source Connection
    Edit or Delete Partitions Merge Partitions
    Authorizing access to objects and operations
    Deploy Analysis Services Projects
    Set Partition Storage
    Create an Analysis Services Project
    Define Logical Primary Keys in a Data Source View
    Create a Data Source
    Backup and Restore of Analysis Services Databases

  • See Training Course Details...

Email us about this courses

Other Risca Enable Technology Training Courses

TSQL Risca Training Courses
Oracle SQL - Risca SQL Training Courses
Power Query Risca Training Courses
JQuery Mobile Risca Training Courses
Excel 365 Intermediate - Risca Excel Training Courses
Report Builder - Risca SQL Server Reporting Services Training Courses