Enable Technology



About Enable Technology Birkenhead SQL Server Analysis Services Training Courses

Enable Technology provides practical SQL Server Analysis Services skills based technology training. The training will be delivered by a Microsoft professional with development experience. 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.

SQL Server Analysis Services courses are taught by a Microsoft Certified Solutions Expert. We can bring the equipment necessary to deliver SQL Server Analysis Services courses at your site. If delivery onsite is an issue we will organise a socially distanced venue near you in Birkenhead. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.

This instructor led SQL Server Analysis Services training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.

In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Birmingham City Council, Dollond & Aitchison Limited, West Bromwich Building Society, South Staffordshire Water PLC, Queen's Medical Centre Nottingham, Carillion PLC, Loughborough University and Homeserve PLC.

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Birkenhead
  • 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 ...
  • KPIs Actions
    Define a Data Source View
    Create Calculated Members
    Deploy Model Solutions with the Deployment Utility
    Ragged Hierarchies
    Modify or Delete an Analysis Services Database
    Create Local Partitions
    Deploy Analysis Services Projects
    Define Named Calculations in a Data Source View
    Multidimensional models
    Processing Databases, Dimensions and Partitions
    Work with Diagrams in Data Source View Designer
    Database permissions
    Create a Time Dimension by Generating a Time Table
    Define Assignments and Other Script Commands
    Partition Writeback Calculations
    Designing Aggregations
    Set Partition Storage
    Create a Dimension by Generating a Non-Time Table in the Data Source
    Delete a Data Source
    Create a Dimension by Using an Existing Table

  • See Training Course Details...

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Birkenhead
  • 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 ...
  • Hide or freeze columns
    Delete Relationships
    Data sources supported in tabular 1200 models
    Create a Calculated Table
    DirectQuery Mode
    Create and Manage Hierarchies Partitions
    Data types supported
    Filter Data in a Table Relationships
    Create and Manage Perspectives Translations Roles
    Tabular model designer
    Row filter mappings
    Enable DirectQuery mode in SSMS
    Create and Manage KPIs Hierarchies
    Create and Manage Measures KPIs
    Enable DirectQuery mode in SSDT
    Bi-directional cross filters  Calculations
    Manage Roles by using SSMS
    Import from Analysis Services
    Create a Relationship Between Two Tables
    Create a Calculated Column

  • See Training Course Details...

Email us about this courses

Other Birkenhead Enable Technology Training Courses

JQuery Mobile Birkenhead Training Courses
Excel 365 Intermediate Birkenhead Training Courses
Power Query Birkenhead Training Courses
VBA - Birkenhead Excel Training Courses
Excel Power Pivot Birkenhead Training Courses
Data Warehouse Birkenhead Training Courses