Enable Technology



About Enable Technology Newtown 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. All course participants are issued SQL Server Analysis Services training manuals they can refer to after the course. If delegates have have questions about SQL Server Analysis Services after the course they are welcome to contact the course Tutor. This post training support is ongoing.

Courses are instructor led and groups sizes small. We are set up to deliver SQL Server Analysis Services training courses onsite at your premises. Another option is we can organise a local socially distanced training site in Newtown. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.

SQL Server Analysis Services courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.

In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Dollond & Aitchison Limited, Canadian High Commission, Carillion PLC, TalkTalk Direct Limited, GKN PLC, Barclays Bank PLC, Countrywide Homes Limited and Boots UK Limited.

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Newtown
  • 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 ...
  • Define a Data Source View
    Create Named Sets
    Create User-Defined Hierarchies
    View the XML for an Analysis Services Project Data Sources
    Define Time Intelligence
    Error Configuration Roles and Permissions
    Backup and Restore of Analysis Services Databases
    Rename a Multidimensional Database Processing a multidimensional model
    Define a Fact Relationship and Fact Relationship Properties
    Cube or model permissions Process permissions
    Configure Measure Group Properties
    Define Assignments and Other Script Commands
    Create Calculated Members
    Define Logical Primary Keys in a Data Source View
    Document and Script an Analysis Services Database
    Create a Dimension by Generating a Non-Time Table in the Data Source
    Define a Referenced Relationship and Referenced Relationship Properties
    Attach and Detach Analysis Services Databases
    Create a Time Dimension by Generating a Time Table
    Define a Regular Relationship and Regular Relationship Properties
    Use Aggregate Functions

  • See Training Course Details...

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Newtown
  • 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 ...
  • Version comparison
    Filter Data in a Table Relationships
    Object-level security
    Data sources supported in tabular 1400 models
    Add sample data to DirectQuery models
    Analyze in Excel
    Add columns to a table
    Data sources supported in SSAS  tabular 2016 Create Tabular Models
    Understanding DAX in Tabular Models Measures
    Create and Manage Perspectives Translations Roles
    Enable DirectQuery mode in SSDT
    Connect to a tabular model database
    Data types supported
    Import Data
    Topics include- Overview of SSAS Tabular models
    Create and Manage Measures KPIs
    Deploy from SQL Server Data Tools Manage Tabular Model Databases

  • See Training Course Details...

Email us about this courses

Other Newtown Enable Technology Training Courses

SSRS - Newtown SQL Server Reporting Services Training Courses
Data Warehouse - Newtown SQL Training Courses
PL/SQL - Newtown SQL Training Courses
Excel Power Pivot Newtown Training Courses
JQuery Newtown Training Courses
JQuery Mobile Newtown Training Courses