Enable Technology

SQL SERVER ANALYSIS SERVICES SWANSEA TRAINING COURSES 

SQL SERVER ANALYSIS SERVICES TRAINING COURSES SWANSEA




About Enable Technology Swansea SQL Server Analysis Services Training Courses

We are a company that offers short, practical, SQL Server Analysis Services hands on technology courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. We provide every candidate with SQL Server Analysis Services training materials which they keep after the course. Course participants are welcome contact the Tutor after the course with specific SQL Server Analysis Services queries. This support is open ended.

Delegates are taught by an experienced Microsoft professional. SQL Server Analysis Services courses are delivered through a mix of practical hands on exercises and walk throughs. Our SQL Server Analysis Services training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Another option is we can organise a local socially distanced training site in Swansea. We offer the option of working with you to develop a bespoke SQL Server Analysis Services programme which precisely matches your organisations training requirements.

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 Lloyds TSB Bank PLC, DHL Express, Fujistu PLC, Loughborough University, Shell UK Oil Products Ltd, Yell Group PLC, National Power PLC and Norfolk Police Constabulary.




Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Swansea
  • 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 ...
  • Ragged Hierarchies
    Delete a Data Source View Dimensions
    Deploy Model Solutions Using the Deployment Wizard
    Configure Analysis Services Project Properties
    Configure Measure Group Properties
    Define a Fact Relationship and Fact Relationship Properties
    Overview of SSAS Multidimensional Modelling
    Deployment Requirements and Considerations for Analysis Services Deployment
    Authorizing access to objects and operations
    KPIs Actions
    Database permissions
    Set Data Source Properties
    Using SQL Server Data Tools (SSDT)
    Define a Referenced Relationship and Referenced Relationship Properties
    Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
    Defined Linked Measure Groups Partitions
    Processing Options and Settings
    Add a Standard Action
    BI Wizard
    Define a Data Source View
    Error Configuration Roles and Permissions

  • See Training Course Details...


Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Swansea
  • 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 ...
  • Delete a Column
    Create and Manage Perspectives Translations Roles
    Manage Roles by using SSMS
    Enable DirectQuery mode in SSDT
    Add columns to a table
    Hide or freeze columns
    Define partitions in DirectQuery models
    Topics include- Overview of SSAS Tabular models
    Filter Data in a Table Relationships
    Create and Manage Tabular Model Partitions
    Create a Relationship Between Two Tables
    Database Process Partitions in the Workspace Database Perspectives
    Data sources supported in SSAS  tabular 2016 Create Tabular Models
    Import data by using a native query
    Import from Power View
    Create a Calculated Column
    Deploy from SQL Server Data Tools Manage Tabular Model Databases
    Specify Mark as Date Table for use with Time Intelligence
    Sort Data in a Table
    Enable DirectQuery mode in SSMS
    Version comparison

  • See Training Course Details...



Email us about this courses



Other Swansea Enable Technology Training Courses

SSRS - Swansea SQL Server Reporting Services Training Courses
JQuery Mobile Swansea Training Courses
PL/SQL Swansea Training Courses
VBA Swansea Training Courses
Oracle SQL - Swansea SQL Training Courses
SSIS - Swansea SQL Server Integration Services Training Courses