Enable Technology



About Enable Technology Rhyl SQL Server Analysis Services Training Courses

We have a twenty year history of providing skills based SQL Server Analysis Services industry training. 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. 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.

We provide instructor led training coupled with hands on training. We can set up a training lab at your premises and deliver SQL Server Analysis Services courses onsite at your site. We can also deliver the SQL Server Analysis Services course at a socially distanced local training venue in Rhyl. The SQL Server Analysis Services syllabus can be modified to accommodate your specific training needs.

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 TalkTalk Direct Limited, Norwich Union PLC, Nationwide Building Society Limited, Fujistu PLC, Barclays Bank PLC, National Power PLC, Canadian High Commission and Shell UK Oil Products Ltd.

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Rhyl
  • 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 ...
  • Tools and Approaches for Processing
    Partition Writeback Calculations
    KPIs Actions
    Delete a Data Source View Dimensions
    Deploy Model Solutions with the Deployment Utility
    Multidimensional models
    Configure Analysis Services Project Properties
    Define a Data Source View
    Create Measures and Measure Groups
    Defined Linked Measure Groups Partitions
    Using SQL Server Data Tools (SSDT)
    Deploy Model Solutions Using the Deployment Wizard
    Set Data Source Properties
    Authorizing access to objects and operations
    Create an Analysis Services Project
    Define Semiadditive Behavior
    Create a Dimension by Using an Existing Table
    Processing Databases, Dimensions and Partitions
    Define Named Queries in a Data Source View
    Set Impersonation Options for a Data Source Connection
    Overview of SSAS Multidimensional Modelling

  • See Training Course Details...

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Rhyl
  • 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 ...
  • Manage Roles by using SSMS
    Set the Data Type of a Column
    Process Tabular Model Partitions
    Version comparison
    Create and Manage Perspectives Translations Roles
    Analyze a tabular model in Excel Deploy tabular model solutions
    Rename a Table or Column
    Create and Manage Tabular Model Partitions
    Data types supported
    Deploy from SQL Server Data Tools Manage Tabular Model Databases
    Filter Data in a Table Relationships
    Add columns to a table
    Analyze in Excel
    Create a New Tabular Model Project
    Add sample data to DirectQuery models
    Row filter mappings
    Import Data
    Create and Manage KPIs Hierarchies
    Database Process Partitions in the Workspace Database Perspectives
    Import from Power Pivot
    Bi-directional cross filters  Calculations

  • See Training Course Details...

Email us about this courses

Other Rhyl Enable Technology Training Courses

Access - Rhyl Access Training Courses
Excel 365 Basic Rhyl Training Courses
VBA Rhyl Training Courses
JavaScript - Rhyl JavaScript Training Courses
SSRS - Rhyl SQL Server Reporting Services Training Courses
Oracle SQL - Rhyl SQL Training Courses