Enable Technology



About Enable Technology Prestatyn SQL Server Analysis Services Training Courses

We are company which specialises in short, two and three day intensive SQL Server Analysis Services technology training courses. The training will be delivered by a Microsoft professional with development experience. Every person attending a SQL Server Analysis Services course will be provided with training materials and practice files to retain after the course. Course participants are welcome contact the Tutor after the course with specific SQL Server Analysis Services queries. This support is open ended.

Courses are instructor led and groups sizes small. We can set up a training lab at your premises and deliver SQL Server Analysis Services courses onsite at your site. We also offer the option of scheduling of SQL Server Analysis Services course at a socially distanced venue near you in Prestatyn. All SQL Server Analysis Services courses can be customised to meet your particular 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. Our clients include: Unipart Group, University of Birmingham, Aston University, Fujistu PLC, Boots UK Limited, Canadian High Commission, GKN PLC and Nationwide Building Society Limited.

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Prestatyn
  • 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 ...
  • Define a Referenced Relationship and Referenced Relationship Properties
    Defined Linked Measure Groups Partitions
    Backup Options Restore Options
    Document and Script an Analysis Services Database
    Configure Analysis Services Project Properties
    Backup and Restore of Analysis Services Databases
    Edit or Delete Partitions Merge Partitions
    Data Source Views
    BI Wizard
    Create User-Defined Hierarchies
    Define a Fact Relationship and Fact Relationship Properties
    Authorizing access to objects and operations
    Set Impersonation Options for a Data Source Connection
    Overview of SSAS Multidimensional Modelling
    Modify or Delete an Analysis Services Database
    Use a Template to Create an Action Deployment
    Work with Diagrams in Data Source View Designer
    Define Logical Primary Keys in a Data Source View
    Processing Options and Settings
    Using SQL Server Data Tools (SSDT)
    Create Named Sets

  • See Training Course Details...

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Prestatyn
  • 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 ...
  • Impersonation
    Manage Roles by using SSMS
    Specify Mark as Date Table for use with Time Intelligence
    Data types supported
    Set the Data Type of a Column
    Hide or freeze columns
    Analyze a tabular model in Excel Deploy tabular model solutions
    Create a Calculated Table
    Version comparison
    Create and Manage Hierarchies Partitions
    Process Database, Table, or Partition
    Connect to a tabular model database
    Enable DirectQuery mode in SSDT
    Rename a Table or Column
    Tabular model designer
    Delete Relationships
    Restore from Power Pivot
    Add columns to a table
    Create and Manage KPIs Hierarchies
    Create and Manage Partitions in the Workspace

  • See Training Course Details...

Email us about this courses

Other Prestatyn Enable Technology Training Courses

Power Query Prestatyn Training Courses
PL/SQL Prestatyn Training Courses
Oracle SQL - Prestatyn SQL Training Courses
TSQL Prestatyn Training Courses
Report Builder - Prestatyn SQL Server Reporting Services Training Courses
SSIS - Prestatyn SQL Server Integration Services Training Courses