Enable Technology



About Enable Technology Merthyr Tydfil SQL Server Analysis Services Training Courses

Enable Technology provides practical SQL Server Analysis Services skills based technology training. All Enable Technology tutors are Microsoft certified experts. Each person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials after the training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Analysis Services queries.

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. Alternatively we could schedule a SQL Server Analysis Services course at an alternative training site in Merthyr Tydfil. The SQL Server Analysis Services syllabus can be modified to accommodate your specific training needs.

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.

Our teaching team have over twenty years continuous technical training experience. Some of our clients are Nationwide Building Society Limited, West Bromwich Building Society, Loughborough University, Boots UK Limited, Canadian High Commission, Homeserve PLC, TalkTalk Direct Limited and Capita Group PLC.

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Merthyr Tydfil
  • 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 ...
  • Work with Diagrams in Data Source View Designer
    Configure Analysis Services Project Properties
    Create Remote Partitions
    Modify or Delete in Solution Explorer Database Dimensions
    Create a Time Dimension by Generating a Time Table
    Create an Analysis Services Project
    Set Partition Storage
    Designing Aggregations
    Data Source object permissions
    Ragged Hierarchies
    Configure Measure Group Properties
    Defined Linked Measure Groups Partitions
    Deploy Model Solutions with the Deployment Utility
    Add a Standard Action
    BI Wizard
    Create a Dimension by Using an Existing Table
    Batch Processing Remote Processing
    Define a Referenced Relationship and Referenced Relationship Properties
    Use a Template to Create an Action Deployment
    Attach and Detach Analysis Services Databases
    Delete a Data Source View Dimensions

  • See Training Course Details...

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Merthyr Tydfil
  • 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 ...
  • Data sources supported in SSAS tabular 2017
    Create and Manage Partitions in the Workspace
    Tabular model designer
    Data types supported
    DirectQuery Mode
    Manage Roles by using SSMS
    Import data by using a native query
    Version comparison
    Specify Mark as Date Table for use with Time Intelligence
    Create a New Tabular Model Project
    Connect to a tabular model database
    Analyze a tabular model in Excel Deploy tabular model solutions
    Process Database, Table, or Partition
    Enable DirectQuery mode in SSMS
    Bi-directional cross filters  Calculations
    Change table, column
    Database Process Partitions in the Workspace Database Perspectives
    Rename a Table or Column
    DAX formula compatibility in DirectQuery mode Tables and Columns
    Create and Manage Hierarchies Partitions

  • See Training Course Details...

Email us about this courses

Other Merthyr Tydfil Enable Technology Training Courses

Data Warehouse Merthyr Tydfil Training Courses
SSIS - Merthyr Tydfil SQL Server Integration Services Training Courses
Power BI Merthyr Tydfil Training Courses
TSQL - Merthyr Tydfil SQL Training Courses
Excel 365 Advanced - Merthyr Tydfil Excel Training Courses
Excel 365 Intermediate Merthyr Tydfil Training Courses