Enable Technology



About Enable Technology Harrogate SQL Server Analysis Services Training Courses

We are a company that offers short, practical, SQL Server Analysis Services hands on technology courses. The course will always be taught by a Microsoft Certified Professional (MCP). All course participants are issued SQL Server Analysis Services training manuals they can refer to after the course. 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. If you prefer we can offer an offsite socially distanced training location in Harrogate. We are happy to modify the SQL Server Analysis Services syllabus to match your teams training requirements.

We can also deliver SQL Server Analysis Services courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.

We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Boots UK Limited, Queen's Medical Centre Nottingham, EDF Energy PLC, South Staffordshire Water PLC, Canadian High Commission, Nationwide Building Society Limited, Aston University and Birmingham City Council.

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Harrogate
  • 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
    Using SQL Server Data Tools (SSDT)
    Set Data Source Properties
    Configure Measure Group Properties
    Create Measures and Measure Groups
    Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
    Supported Data Sources
    Add a Standard Action
    Deploy Model Solutions Using XMLA
    Explore Data in a Data Source View
    Create a Dimension by Using an Existing Table
    Processing Databases, Dimensions and Partitions
    Create a Dimension by Generating a Non-Time Table in the Data Source
    Data Source object permissions
    Edit or Delete Partitions Merge Partitions
    Define Logical Primary Keys in a Data Source View
    Define Attribute Relationships
    Multidimensional models
    Backup and Restore of Analysis Services Databases
    Move an Analysis Services Database
    Modify or Delete an Analysis Services Database

  • See Training Course Details...

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Harrogate
  • 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 ...
  • Delete a Column
    Manage Roles by using SSMS
    Import data by using a native query
    Create and Manage Perspectives Translations Roles
    Connect to a tabular model database
    Create and Manage Roles
    Create a Calculated Column
    Filter Data in a Table Relationships
    Create a New Tabular Model Project
    Enable DirectQuery mode in SSDT
    Specify Mark as Date Table for use with Time Intelligence
    Process Tabular Model Partitions
    Test a model in DirectQuery mode
    Analyze in Excel
    Add columns to a table
    Restore from Power Pivot
    Create a Relationship Between Two Tables
    Data sources supported in tabular 1200 models
    Rename a Table or Column

  • See Training Course Details...

Email us about this courses

Other Harrogate Enable Technology Training Courses

VBA - Harrogate Excel Training Courses
Oracle SQL Harrogate Training Courses
JQuery Mobile - Harrogate JavaScript Training Courses
SSRS Harrogate Training Courses
Excel Power Pivot - Harrogate Excel Training Courses
Data Warehouse Harrogate Training Courses