Enable Technology



About Enable Technology Trowbridge SQL Server Analysis Services Training Courses

We are company which specialises in short, two and three day intensive SQL Server Analysis Services technology training courses. All Enable Technology tutors are Microsoft certified experts. Each person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials after the training. We offer a post training support service and delegates will have access to a Microsoft expert on SQL Server Analysis Services for as long as they need.

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. The SQL Server Analysis Services course could also be scheduled at a socially distanced site near you in Trowbridge. 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.

This instructor led SQL Server Analysis Services training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.

In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Total Telecommunications Limited, Barclays Bank PLC, South Staffordshire Water PLC, Capita Group PLC, Lloyds TSB Bank PLC, Canadian High Commission, Dollond & Aitchison Limited and Boots UK Limited.

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Trowbridge
  • 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 ...
  • Processing Databases, Dimensions and Partitions
    Tools and Approaches for Processing
    Define Logical Relationships in a Data Source View
    Using SQL Server Data Tools (SSDT)
    Set Impersonation Options for a Data Source Connection
    Rename a Multidimensional Database Processing a multidimensional model
    Replace a Table or a Named Query in a Data Source View
    Error Configuration Roles and Permissions
    Create Named Sets
    Use Aggregate Functions
    Define Named Queries in a Data Source View
    Create Local Partitions
    Calculations using the Business Intelligence Wizard
    Supported Data Sources
    Move an Analysis Services Database
    Cube or model permissions Process permissions
    KPIs Actions
    Processing Options and Settings
    Work with Diagrams in Data Source View Designer
    Deploy Analysis Services Projects
    Create a Dimension Using the Dimension Wizard

  • See Training Course Details...

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Trowbridge
  • 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 ...
  • Import data by using a native query
    Enable DirectQuery mode in SSMS
    Add sample data to DirectQuery models
    Create and Manage Hierarchies Partitions
    DirectQuery Mode
    Understanding DAX in Tabular Models Measures
    Deploy from SQL Server Data Tools Manage Tabular Model Databases
    Delete a Column
    Specify Mark as Date Table for use with Time Intelligence
    Create and Manage Tabular Model Partitions
    Create a Relationship Between Two Tables
    Create and Manage Perspectives Translations Roles
    Enable DirectQuery mode in SSDT
    Topics include- Overview of SSAS Tabular models
    Process Tabular Model Partitions
    Add columns to a table
    Database Process Partitions in the Workspace Database Perspectives
    Import from Power View

  • See Training Course Details...

Email us about this courses

Other Trowbridge Enable Technology Training Courses

Oracle SQL Trowbridge Training Courses
JQuery Trowbridge Training Courses
VBA Trowbridge Training Courses
Access VBA - Trowbridge Access Training Courses
PL/SQL - Trowbridge SQL Training Courses
Excel 365 Basic Trowbridge Training Courses