Enable Technology



About Enable Technology Salford SQL Server Analysis Services Training Courses

We have a twenty year history of providing skills based SQL Server Analysis Services industry training. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every person attending a SQL Server Analysis Services course will be provided with training materials and practice files to retain after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Analysis Services queries.

Courses are instructor led and groups sizes small. Enable Technology can provide SQL Server Analysis Services courses onsite at your location. We will bring the necessary laptops with the required software installed. If you prefer we can offer an offsite socially distanced training location in Salford. The SQL Server Analysis Services syllabus can be modified to accommodate your specific training needs.

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

The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Shell UK Oil Products Ltd, Cadbury PLC, Boots UK Limited, Carillion PLC, Yell Group PLC, Birmingham City Council, Unipart Group and Homeserve PLC.

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Salford
  • 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 from Power View
    Import Data
    Rename a Table or Column
    Create a Calculated Table
    Analyze in Excel
    Deploy from SQL Server Data Tools Manage Tabular Model Databases
    Test a model in DirectQuery mode
    Data sources supported in SSAS tabular 2017
    Create and Manage Perspectives Translations Roles
    Data sources supported in SSAS  tabular 2016 Create Tabular Models
    Data types supported
    Import from Analysis Services
    Create a Calculated Column
    Create a New Tabular Model Project
    Row filter mappings
    Process Database, Table, or Partition
    Delete a Column
    Understanding DAX in Tabular Models Measures

  • See Training Course Details...

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Salford
  • 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 ...
  • Rename a Multidimensional Database Processing a multidimensional model
    Add a Standard Action
    Configure Measure Group Properties
    Define Time Intelligence
    Set Impersonation Options for a Data Source Connection
    Supported Data Sources
    BI Wizard
    Configure Analysis Services Project Properties
    Create a Dimension by Generating a Non-Time Table in the Data Source
    Authorizing access to objects and operations
    Document and Script an Analysis Services Database
    Processing Options and Settings
    Create Remote Partitions
    Data Source object permissions
    Define a Fact Relationship and Fact Relationship Properties
    Multidimensional models
    Backup Options Restore Options
    Create a Data Source
    Dimension permissions
    Add or Remove Tables or Views in a Data Source View
    Define Assignments and Other Script Commands

  • See Training Course Details...

Email us about this courses

Other Salford Enable Technology Training Courses

DAX - Salford Excel Training Courses
JQuery Mobile Salford Training Courses
Excel 365 Advanced - Salford Excel Training Courses
JavaScript Salford Training Courses
Excel 365 Intermediate Salford Training Courses
SSRS Salford Training Courses