Enable Technology



About Enable Technology Lancashire SQL Server Analysis Services Training Courses

We offer intensive two and three days SQL Server Analysis Services courses. The course will always be taught by a Microsoft Certified Professional (MCP). Each person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials after the training. Course participants are welcome contact the Tutor after the course with specific SQL Server Analysis Services queries. This support is open ended.

We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. 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 can also deliver the SQL Server Analysis Services course at a socially distanced local training venue in Lancashire. 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.

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: West Bromwich Building Society, Royal & Sun Alliance Group PLC, Halfords Group PLC, EDF Energy PLC, Dollond & Aitchison Limited, Loughborough University, Nationwide Building Society Limited and DHL Express.

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Lancashire
  • 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 ...
  • Test an Action
    Modify or Delete in Solution Explorer Database Dimensions
    Change a Partition Source
    Define a Data Source View
    Data Source object permissions
    Database permissions
    Calculations using the Business Intelligence Wizard
    Edit or Delete Partitions Merge Partitions
    Define Assignments and Other Script Commands
    Configure Analysis Services Project Properties
    Create an Analysis Services Project
    Delete a Data Source
    Create Remote Partitions
    Define a Referenced Relationship and Referenced Relationship Properties
    Define Logical Primary Keys in a Data Source View
    KPIs Actions
    Use a Template to Create an Action Deployment
    Deploy Model Solutions Using XMLA
    Set Partition Storage
    Overview of SSAS Multidimensional Modelling
    Dimension permissions

  • See Training Course Details...

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Lancashire
  • 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 ...
  • Topics include- Overview of SSAS Tabular models
    Process Database, Table, or Partition
    Specify Mark as Date Table for use with Time Intelligence
    Test a model in DirectQuery mode
    DirectQuery Mode
    Import data by using a native query
    Create and Manage Hierarchies Partitions
    Restore from Power Pivot
    Data sources supported in SSAS tabular 2017
    Import from Analysis Services
    Create a Calculated Column
    Create and Manage KPIs Hierarchies
    Create and Manage Partitions in the Workspace
    Data sources supported in SSAS  tabular 2016 Create Tabular Models
    Tabular model designer
    Create and Manage Perspectives Translations Roles
    Enable DirectQuery mode in SSMS
    Add columns to a table
    Process Tabular Model Partitions

  • See Training Course Details...

Email us about this courses

Other Lancashire Enable Technology Training Courses

Report Builder - Lancashire SQL Server Reporting Services Training Courses
JavaScript Lancashire Training Courses
PL/SQL Lancashire Training Courses
Access VBA - Lancashire Access Training Courses
TSQL Lancashire Training Courses
Power Query - Lancashire Excel Training Courses