Enable Technology



About Enable Technology Chorley SQL Server Analysis Services Training Courses

Enable Technology has twenty year track record of providing short intensive SQL Server Analysis Services skills based training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Each course participant will be issued with training SQL Server Analysis Services resources which they can continue to use 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.

Courses are instructor led and groups sizes small. Enable Technology SQL Server Analysis Services courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. We can also deliver the SQL Server Analysis Services course at a socially distanced local training venue in Chorley. We are happy to modify the SQL Server Analysis Services syllabus to match your teams training requirements.

We also deliver this course online. Delegates participate in a virtual SQL Server Analysis Services class and can both talk to and share their screen with the tutor.

We have operated primarily in the West Midlands for twenty years. Some of our clients are Halfords Group PLC, Fujistu PLC, TalkTalk Direct Limited, Nationwide Building Society Limited, South Staffordshire Water PLC, Aston University, National Power PLC and University of Birmingham.

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Chorley
  • 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 ...
  • Tools and Approaches for Processing
    Create a Time Dimension by Generating a Time Table
    Create a Dimension by Generating a Non-Time Table in the Data Source
    Define Time Intelligence
    BI Wizard
    Set Data Source Properties
    Add a Standard Action
    Create Named Sets
    Change a Partition Source
    Using SQL Server Data Tools (SSDT)
    Create User-Defined Hierarchies
    Deployment Requirements and Considerations for Analysis Services Deployment
    Rename a Multidimensional Database Processing a multidimensional model
    Define a Referenced Relationship and Referenced Relationship Properties
    Define Logical Relationships in a Data Source View
    Move an Analysis Services Database
    KPIs Actions
    Delete a Data Source
    Use Aggregate Functions
    Batch Processing Remote Processing
    Configure Measure Group Properties

  • See Training Course Details...

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Chorley
  • 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
    Tabular model designer
    Create and Manage Tabular Model Partitions
    Filter Data in a Table Relationships
    Topics include- Overview of SSAS Tabular models
    Create and Manage KPIs Hierarchies
    Set the Data Type of a Column
    Database Process Partitions in the Workspace Database Perspectives
    DirectQuery Mode
    Deploy from SQL Server Data Tools Manage Tabular Model Databases
    Import from Power View
    Manage Roles by using SSMS
    Define partitions in DirectQuery models
    Create a Calculated Column
    Import data by using a native query
    Create a New Tabular Model Project
    Object-level security
    Delete Relationships
    Add a table Delete a Table
    Understanding DAX in Tabular Models Measures
    Analyze in Excel

  • See Training Course Details...

Email us about this courses

Other Chorley Enable Technology Training Courses

Excel 365 Advanced - Chorley Excel Training Courses
Access - Chorley Access Training Courses
SSIS Chorley Training Courses
Excel 365 Intermediate - Chorley Excel Training Courses
Excel 365 Basic Chorley Training Courses
Data Warehouse - Chorley SQL Training Courses