Enable Technology



About Enable Technology Blackpool SQL Server Analysis Services Training Courses

Enable Technology specialise in succinct skills based SQL Server Analysis Services training. All Enable Technology tutors are Microsoft certified experts. Each course participant will be issued with training SQL Server Analysis Services resources which they can continue to use after the training. It is our company policy to provide SQL Server Analysis Services training participants with ongoing support from the course Tutor. People who attend a SQL Server Analysis Services course can contact the Tutor for as long as they need assistance after the training.

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. Alternatively we could schedule a course at a local socially distanced venue in Blackpool. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services training requirements.

SQL Server Analysis Services courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen

We have operated primarily in the West Midlands for twenty years. Our clients include: Fujistu PLC, Unipart Group, Capita Group PLC, Norfolk Police Constabulary, Cadbury PLC, Royal Air Force, Birmingham City Council and Homeserve PLC.

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Blackpool
  • 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 ...
  • Delete a Data Source
    Add or Remove Tables or Views in a Data Source View
    Work with Diagrams in Data Source View Designer
    Define Semiadditive Behavior
    Define Time Intelligence
    Create an Analysis Services Project
    Define Attribute Relationships
    Defined Linked Measure Groups Partitions
    Create a Data Source
    Deploy Model Solutions with the Deployment Utility
    Error Configuration Roles and Permissions
    Create Measures and Measure Groups
    Cube or model permissions Process permissions
    Deployment Requirements and Considerations for Analysis Services Deployment
    Ragged Hierarchies
    Processing Options and Settings
    Create Calculated Members
    Deploy Analysis Services Projects
    Using SQL Server Data Tools (SSDT)
    Add a Standard Action
    Define Logical Primary Keys in a Data Source View

  • See Training Course Details...

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Blackpool
  • 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 ...
  • Filter Data in a Table Relationships
    Data types supported
    Create and Manage KPIs Hierarchies
    Data sources supported in tabular 1200 models
    Add columns to a table
    Create and Manage Measures KPIs
    Create a Relationship Between Two Tables
    DAX formula compatibility in DirectQuery mode Tables and Columns
    Create and Manage Partitions in the Workspace
    Delete a Column
    Delete Relationships
    Data sources supported in SSAS tabular 2017
    Create and Manage Perspectives Translations Roles
    Import from Analysis Services
    Version comparison
    Understanding DAX in Tabular Models Measures
    Create and Manage Tabular Model Partitions
    Data sources supported in tabular 1400 models
    Restore from Power Pivot
    Row filter mappings

  • See Training Course Details...

Email us about this courses

Other Blackpool Enable Technology Training Courses

Power BI - Blackpool Microsoft Power BI Training Courses
SSIS - Blackpool SQL Server Integration Services Training Courses
VBA - Blackpool Excel Training Courses
SSRS - Blackpool SQL Server Reporting Services Training Courses
JQuery Mobile Blackpool Training Courses
Power Query Blackpool Training Courses