Enable Technology



About Enable Technology Shropshire SQL Server Analysis Services Training Courses

We have a twenty year history of providing skills based SQL Server Analysis Services industry training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Every course participant is given SQL Server Analysis Services courseware which they can refer to after the training. We offer a post training support service and delegates will have access to a Microsoft expert on SQL Server Analysis Services for as long as they need.

SQL Server Analysis Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology can provide SQL Server Analysis Services courses onsite at your location. We will bring the necessary laptops with the required software installed. We also offer the option of scheduling of SQL Server Analysis Services course at a socially distanced venue near you in Shropshire. Every SQL Server Analysis Services course can be modified to meet your bespoke requirements.

We also deliver this course online through virtual classrooms. Delegates can join scheduled SQL Server Analysis Services classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Capita Group PLC, GKN PLC, Royal Air Force, Wolverhampton City Council, Barclays Bank PLC, Birmingham Heartlands Hospital, Cadbury PLC and Loughborough University.

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Version comparison
    Add sample data to DirectQuery models
    Process Tabular Model Partitions
    Enable DirectQuery mode in SSDT
    DirectQuery Mode
    Topics include- Overview of SSAS Tabular models
    Import from Analysis Services
    Database Process Partitions in the Workspace Database Perspectives
    Import data by using a native query
    Add columns to a table
    Delete Relationships
    Import from Power View
    Specify Mark as Date Table for use with Time Intelligence
    Create and Manage Hierarchies Partitions
    Hide or freeze columns
    Create a Relationship Between Two Tables
    Process Database, Table, or Partition
    Create and Manage Tabular Model Partitions
    Create and Manage Partitions in the Workspace
    Create and Manage Perspectives Translations Roles
    Add a table Delete a Table

  • See Training Course Details...

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Shropshire
  • 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 ...
  • Batch Processing Remote Processing
    Define Attribute Relationships
    Create Remote Partitions
    Deploy Model Solutions Using XMLA
    Define a Referenced Relationship and Referenced Relationship Properties
    Configure Measure Group Properties
    Define a Regular Relationship and Regular Relationship Properties
    Tools and Approaches for Processing
    BI Wizard
    Data Source object permissions
    Create User-Defined Hierarchies
    Deployment Requirements and Considerations for Analysis Services Deployment
    Replace a Table or a Named Query in a Data Source View
    Create Measures and Measure Groups
    Create a Data Source
    Test an Action
    Create an Analysis Services Project
    Supported Data Sources
    Create a Time Dimension by Generating a Time Table
    Define Named Calculations in a Data Source View
    Defined Linked Measure Groups Partitions

  • See Training Course Details...

Email us about this courses

Other Shropshire Enable Technology Training Courses

JQuery - Shropshire JavaScript Training Courses
Oracle SQL - Shropshire SQL Training Courses
Power BI Shropshire Training Courses
Power Query - Shropshire Excel Training Courses
JavaScript - Shropshire JavaScript Training Courses
Data Warehouse - Shropshire SQL Training Courses