Enable Technology



About Enable Technology Holyhead SQL Server Analysis Services Training Courses

Enable Technology offer short intensive skills based SQL Server Analysis Services training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). We provide every candidate with SQL Server Analysis Services training materials which they keep 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.

Enable Technology training courses are delivered as instructor led courses. We are set up to deliver SQL Server Analysis Services training courses onsite at your premises. We also offer the option of scheduling of SQL Server Analysis Services course at a socially distanced venue near you in Holyhead. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services training requirements.

We can also deliver SQL Server Analysis Services courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Carillion PLC, Birmingham City Council, Yell Group PLC, Birmingham Heartlands Hospital, Royal Air Force, Shell UK Oil Products Ltd, Cadbury PLC and Homeserve PLC.

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Holyhead
  • 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 ...
  • Add a Standard Action
    KPIs Actions
    Define Named Calculations in a Data Source View
    Cube or model permissions Process permissions
    Error Configuration Roles and Permissions
    Modify or Delete an Analysis Services Database
    Change a Partition Source
    Define a Data Source View
    Deploy Model Solutions with the Deployment Utility
    Deploy Analysis Services Projects
    Rename a Multidimensional Database Processing a multidimensional model
    Define Attribute Relationships
    Configure Analysis Services Project Properties
    Batch Processing Remote Processing
    Delete a Data Source View Dimensions
    Define Assignments and Other Script Commands
    Explore Data in a Data Source View
    Designing Aggregations
    Overview of SSAS Multidimensional Modelling
    Create Named Sets
    Attach and Detach Analysis Services Databases

  • See Training Course Details...

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Holyhead
  • 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 ...
  • Topics include- Overview of SSAS Tabular models
    Data sources supported in tabular 1400 models
    Create a Relationship Between Two Tables
    Tabular model designer
    Bi-directional cross filters  Calculations
    Add columns to a table
    Data sources supported in SSAS  tabular 2016 Create Tabular Models
    Create and Manage Perspectives Translations Roles
    Analyze a tabular model in Excel Deploy tabular model solutions
    Create a Calculated Column
    Rename a Table or Column
    Delete Relationships
    Analyze in Excel
    Enable DirectQuery mode in SSDT
    Database Process Partitions in the Workspace Database Perspectives
    Deploy from SQL Server Data Tools Manage Tabular Model Databases
    Object-level security
    Create and Manage Partitions in the Workspace

  • See Training Course Details...

Email us about this courses

Other Holyhead Enable Technology Training Courses

Power Query Holyhead Training Courses
DAX Holyhead Training Courses
Oracle SQL Holyhead Training Courses
SSIS - Holyhead SQL Server Integration Services Training Courses
JavaScript - Holyhead JavaScript Training Courses
Excel 365 Intermediate - Holyhead Excel Training Courses