Enable Technology



About Enable Technology Runcorn SQL Server Analysis Services Training Courses

We are a company that provides short intensive SQL Server Analysis Services training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Each person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials after the training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Analysis Services queries.

We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. We are set up to deliver SQL Server Analysis Services training courses onsite at your premises. Another way we could deliver the SQL Server Analysis Services course is at a local socially distanced training site. We are happy to modify the SQL Server Analysis Services syllabus to match your teams 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 two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Capita Group PLC, TalkTalk Direct Limited, Birmingham City University, Homeserve PLC, Nationwide Building Society Limited, West Bromwich Building Society, Royal & Sun Alliance Group PLC and Loughborough University.

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Runcorn
  • 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 ...
  • Add a table Delete a Table
    Hide or freeze columns
    Process Tabular Model Partitions
    Create a Relationship Between Two Tables
    Create and Manage Tabular Model Partitions
    Create and Manage KPIs Hierarchies
    Set the Data Type of a Column
    Bi-directional cross filters  Calculations
    Topics include- Overview of SSAS Tabular models
    Enable DirectQuery mode in SSMS
    Manage Roles by using SSMS
    Create a New Tabular Model Project
    Data types supported
    Restore from Power Pivot
    Rename a Table or Column
    Import from Power Pivot
    Sort Data in a Table
    Create a Calculated Column
    Create and Manage Measures KPIs
    Data sources supported in SSAS tabular 2017

  • See Training Course Details...

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Runcorn
  • 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 ...
  • Deploy Model Solutions with the Deployment Utility
    Overview of SSAS Multidimensional Modelling
    Create Calculated Members
    Change a Partition Source
    Set Data Source Properties
    Configure Analysis Services Project Properties
    Create Named Sets
    Deploy Analysis Services Projects
    Test an Action
    Modify or Delete an Analysis Services Database
    Define a Fact Relationship and Fact Relationship Properties
    Add or Remove Tables or Views in a Data Source View
    Move an Analysis Services Database
    Ragged Hierarchies
    Attach and Detach Analysis Services Databases
    Modify or Delete in Solution Explorer Database Dimensions
    Create a Data Source
    Database permissions
    Set Impersonation Options for a Data Source Connection
    Partition Writeback Calculations
    Define a Referenced Relationship and Referenced Relationship Properties

  • See Training Course Details...

Email us about this courses

Other Runcorn Enable Technology Training Courses

Power Query Runcorn Training Courses
Oracle SQL Runcorn Training Courses
Power BI - Runcorn Microsoft Power BI Training Courses
Excel Power Pivot Runcorn Training Courses
Excel 365 Intermediate - Runcorn Excel Training Courses
SSRS - Runcorn SQL Server Reporting Services Training Courses