Enable Technology



About Enable Technology Llanrumney SQL Server Analysis Services Training Courses

We are a company that offers short, practical, SQL Server Analysis Services hands on technology courses. The tutor delivering the course will be a Microsoft certified expert. Every course participant is given SQL Server Analysis Services courseware which they can refer to after the training. 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 provide instructor led training coupled with hands on training. Enable Technology can provide SQL Server Analysis Services courses onsite at your location. We will bring the necessary laptops with the required software installed. Alternatively we could schedule a course at a local socially distanced venue in Llanrumney. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services training 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.

We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: Fujistu PLC, Royal Air Force, Lloyds TSB Bank PLC, Norfolk Police Constabulary, Halfords Group PLC, National Power PLC, Boots UK Limited and West Bromwich Building Society.

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Llanrumney
  • 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 and Manage Roles
    Change table, column
    Version comparison
    Process Tabular Model Partitions
    Create and Manage Measures KPIs
    Restore from Power Pivot
    Add sample data to DirectQuery models
    Set the Data Type of a Column
    Data sources supported in tabular 1200 models
    Enable DirectQuery mode in SSMS
    Data sources supported in SSAS  tabular 2016 Create Tabular Models
    Rename a Table or Column
    Add a table Delete a Table
    Sort Data in a Table
    Specify Mark as Date Table for use with Time Intelligence
    Import data by using a native query
    Data types supported
    Deploy from SQL Server Data Tools Manage Tabular Model Databases
    Understanding DAX in Tabular Models Measures
    Create and Manage Hierarchies Partitions

  • See Training Course Details...

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Llanrumney
  • 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 Time Dimension by Generating a Time Table
    Create a Dimension by Using an Existing Table
    Change a Partition Source
    Configure Analysis Services Project Properties
    Backup Options Restore Options
    Delete a Data Source View Dimensions
    Add a Standard Action
    Using SQL Server Data Tools (SSDT)
    Define Named Queries in a Data Source View
    Ragged Hierarchies
    Database permissions
    Tools and Approaches for Processing
    Create User-Defined Hierarchies
    Data Source object permissions
    Create Calculated Members
    Define Named Calculations in a Data Source View
    Deploy Model Solutions with the Deployment Utility
    Cube or model permissions Process permissions
    Deploy Analysis Services Projects
    Add or Remove Tables or Views in a Data Source View
    Create Measures and Measure Groups

  • See Training Course Details...

Email us about this courses

Other Llanrumney Enable Technology Training Courses

SSIS - Llanrumney SQL Server Integration Services Training Courses
Access - Llanrumney Access Training Courses
Excel 365 Advanced - Llanrumney Excel Training Courses
Power Query - Llanrumney Excel Training Courses
DAX Llanrumney Training Courses
SQL Llanrumney Training Courses