Enable Technology



About Enable Technology Powys SQL Server Analysis Services Training Courses

Enable Technology has twenty year track record of providing short intensive SQL Server Analysis Services skills based training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Every course participant will receives course practice files and SQL Server Analysis Services course resources that can be referenced post training. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.

We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. We can set up a training lab at your premises and deliver SQL Server Analysis Services courses onsite at your site. Alternatively we could schedule a SQL Server Analysis Services course at an alternative training site in Powys. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services training requirements.

We also deliver this course online. Delegates participate in a virtual SQL Server Analysis Services class and can both talk to and share their screen with the tutor.

Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Loughborough University, Lloyds TSB Bank PLC, Fujistu PLC, National Power PLC, Nuclear Engineering Services, Norfolk Police Constabulary, Cadbury PLC and EDF Energy PLC.

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Powys
  • 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 Semiadditive Behavior
    Modify or Delete an Analysis Services Database
    KPIs Actions
    Define a Referenced Relationship and Referenced Relationship Properties
    Define a Data Source View
    Error Configuration Roles and Permissions
    Create User-Defined Hierarchies
    Create Remote Partitions
    Create a Dimension Using the Dimension Wizard
    Replace a Table or a Named Query in a Data Source View
    Batch Processing Remote Processing
    Calculations using the Business Intelligence Wizard
    Change a Partition Source
    Set Partition Storage
    Add or Remove Tables or Views in a Data Source View
    Define Attribute Relationships
    Processing Databases, Dimensions and Partitions
    Rename a Multidimensional Database Processing a multidimensional model
    Define Assignments and Other Script Commands
    Multidimensional models
    Using SQL Server Data Tools (SSDT)

  • See Training Course Details...

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Powys
  • 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 from Power Pivot
    Rename a Table or Column
    Row filter mappings
    Create and Manage Perspectives Translations Roles
    Define partitions in DirectQuery models
    Sort Data in a Table
    Data sources supported in SSAS  tabular 2016 Create Tabular Models
    Version comparison
    Add a table Delete a Table
    DirectQuery Mode
    Data sources supported in tabular 1200 models
    Restore from Power Pivot
    Add sample data to DirectQuery models
    Database Process Partitions in the Workspace Database Perspectives
    Create a New Tabular Model Project
    Enable DirectQuery mode in SSMS
    Import from Power View
    Data types supported
    Import Data
    Enable DirectQuery mode in SSDT
    Deploy from SQL Server Data Tools Manage Tabular Model Databases

  • See Training Course Details...

Email us about this courses

Other Powys Enable Technology Training Courses

Excel 365 Intermediate Powys Training Courses
Access - Powys Access Training Courses
Report Builder - Powys SQL Server Reporting Services Training Courses
Power BI Powys Training Courses
Oracle SQL - Powys SQL Training Courses
Data Warehouse Powys Training Courses