Enable Technology



About Enable Technology Rochdale SQL Server Analysis Services Training Courses

We have a twenty year history of providing skills based SQL Server Analysis Services industry training. The training will be delivered by a Microsoft professional with development experience. All candidates receive comprehensive SQL Server Analysis Services training materials and practice files which are theirs to 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 specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology SQL Server Analysis Services training courses can be delivered at your offices. We can supply the necessary software and computers. 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.

This course can also be delivered in a virtual classroom. Delegates can log into a scheduled SQL Server Analysis Services course, watch the tutor demonstrate tasks, ask questions and share their own screen.

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Total Telecommunications Limited, National Power PLC, Nationwide Building Society Limited, Cadbury PLC, Royal & Sun Alliance Group PLC, Unipart Group, Capita Group PLC and West Bromwich Building Society.

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Rochdale
  • 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 ...
  • Create a Dimension by Generating a Non-Time Table in the Data Source
    Supported Data Sources
    Create an Analysis Services Project
    Define Logical Primary Keys in a Data Source View
    Using SQL Server Data Tools (SSDT)
    Define Logical Relationships in a Data Source View
    Processing Options and Settings
    Create Remote Partitions
    Database permissions
    Tools and Approaches for Processing
    Create Measures and Measure Groups
    Change a Partition Source
    Overview of SSAS Multidimensional Modelling
    Add or Remove Tables or Views in a Data Source View
    Create User-Defined Hierarchies
    Designing Aggregations
    Deployment Requirements and Considerations for Analysis Services Deployment
    Modify or Delete an Analysis Services Database
    Authorizing access to objects and operations
    Rename a Multidimensional Database Processing a multidimensional model
    Define Named Calculations in a Data Source View

  • See Training Course Details...

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Rochdale
  • 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 ...
  • Create a New Tabular Model Project
    Create and Manage Perspectives Translations Roles
    Create a Calculated Column
    Process Tabular Model Partitions
    Import from Power Pivot
    Data sources supported in tabular 1400 models
    Create a Calculated Table
    Object-level security
    Create and Manage Partitions in the Workspace
    Sort Data in a Table
    Add columns to a table
    Create and Manage Roles
    Delete a Column
    Connect to a tabular model database
    Restore from Power Pivot
    Rename a Table or Column
    Create a Relationship Between Two Tables
    Bi-directional cross filters  Calculations

  • See Training Course Details...

Email us about this courses

Other Rochdale Enable Technology Training Courses

JQuery Rochdale Training Courses
Access VBA - Rochdale Access Training Courses
Power BI Rochdale Training Courses
Oracle SQL - Rochdale SQL Training Courses
Report Builder - Rochdale SQL Server Reporting Services Training Courses
JQuery Mobile Rochdale Training Courses