Enable Technology



About Enable Technology Normanton SQL Server Analysis Services Training Courses

We have a twenty year history of providing skills based SQL Server Analysis Services industry training. The tutor delivering the course will be a Microsoft certified expert. Each person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials after the training. 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.

We provide instructor led training coupled with hands on training. Enable Technology SQL Server Analysis Services courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Another way we could deliver the SQL Server Analysis Services course is at a local socially distanced training site. Every SQL Server Analysis Services course can be modified to meet your bespoke requirements.

Taught SQL Server Analysis Services courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.

In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Royal & Sun Alliance Group PLC, University of Birmingham, Royal Air Force, Wolverhampton City Council, Shell UK Oil Products Ltd, Birmingham Heartlands Hospital, Capita Group PLC and Nationwide Building Society Limited.

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Normanton
  • 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 data by using a native query
    Add a table Delete a Table
    Create and Manage Partitions in the Workspace
    Create a Relationship Between Two Tables
    Filter Data in a Table Relationships
    Bi-directional cross filters  Calculations
    Create a Calculated Table
    Enable DirectQuery mode in SSMS
    Version comparison
    Import from Analysis Services
    Create and Manage Tabular Model Partitions
    Understanding DAX in Tabular Models Measures
    Define partitions in DirectQuery models
    Sort Data in a Table
    Deploy from SQL Server Data Tools Manage Tabular Model Databases
    Import Data
    Import from Power View
    Database Process Partitions in the Workspace Database Perspectives
    Create and Manage Measures KPIs
    Create and Manage Hierarchies Partitions
    Add sample data to DirectQuery models

  • See Training Course Details...

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Normanton
  • 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 ...
  • BI Wizard
    Create Local Partitions
    Define Named Queries in a Data Source View
    Backup Options Restore Options
    Error Configuration Roles and Permissions
    Tools and Approaches for Processing
    Ragged Hierarchies
    Change a Partition Source
    Deploy Model Solutions with the Deployment Utility
    Deploy Model Solutions Using XMLA
    Add or Remove Tables or Views in a Data Source View
    Processing Databases, Dimensions and Partitions
    Create a Dimension Using the Dimension Wizard
    Set Partition Storage
    Overview of SSAS Multidimensional Modelling
    Create an Analysis Services Project
    Use Aggregate Functions
    Attach and Detach Analysis Services Databases
    Define Semiadditive Behavior
    Define Time Intelligence
    Processing Options and Settings

  • See Training Course Details...

Email us about this courses

Other Normanton Enable Technology Training Courses

Excel 365 Intermediate - Normanton Excel Training Courses
Report Builder Normanton Training Courses
SSIS - Normanton SQL Server Integration Services Training Courses
Oracle SQL - Normanton SQL Training Courses
SQL Normanton Training Courses
Excel Power Pivot - Normanton Excel Training Courses