Enable Technology



About Enable Technology Bridlington SQL Server Analysis Services Training Courses

We are a company that provides short intensive SQL Server Analysis Services training courses. The tutor delivering the course will be a Microsoft certified expert. All course participants are issued SQL Server Analysis Services training manuals they can refer to after the course. We also provide an ongoing support service to people attending our SQL Server Analysis Services courses. Delegates can contact the course tutor with specific SQL Server Analysis Services questions for as long as they need following the course.

Our primary method of delivery is instructor led training coupled with practical hands on activities. Enable Technology SQL Server Analysis Services courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. If delivery onsite is an issue we will organise a socially distanced venue near you in Bridlington. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite SQL Server Analysis Services course to some extent is bespoke and tailored to your needs.

Taught SQL Server Analysis Services courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.

Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Loughborough University, Boots UK Limited, Unipart Group, Countrywide Homes Limited, Norfolk Police Constabulary, Halfords Group PLC, Dollond & Aitchison Limited and Total Telecommunications Limited.

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Bridlington
  • 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 ...
  • Error Configuration Roles and Permissions
    Backup and Restore of Analysis Services Databases
    Using SQL Server Data Tools (SSDT)
    Set Partition Storage
    Designing Aggregations
    Move an Analysis Services Database
    Create User-Defined Hierarchies
    Define Time Intelligence
    Calculations using the Business Intelligence Wizard
    KPIs Actions
    Configure Analysis Services Project Properties
    Delete a Data Source
    Test an Action
    Define a Fact Relationship and Fact Relationship Properties
    Tools and Approaches for Processing
    View the XML for an Analysis Services Project Data Sources
    Multidimensional models
    Batch Processing Remote Processing
    Create Calculated Members
    Deploy Model Solutions with the Deployment Utility
    Data Source object permissions

  • See Training Course Details...

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Bridlington
  • 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 ...
  • Delete Relationships
    Bi-directional cross filters  Calculations
    Create and Manage Roles
    Data sources supported in SSAS  tabular 2016 Create Tabular Models
    DAX formula compatibility in DirectQuery mode Tables and Columns
    Create a New Tabular Model Project
    Create and Manage Perspectives Translations Roles
    Restore from Power Pivot
    Create and Manage Measures KPIs
    Specify Mark as Date Table for use with Time Intelligence
    Understanding DAX in Tabular Models Measures
    Import Data
    Process Database, Table, or Partition
    Database Process Partitions in the Workspace Database Perspectives
    DirectQuery Mode
    Data sources supported in tabular 1200 models
    Create a Calculated Column
    Filter Data in a Table Relationships

  • See Training Course Details...

Email us about this courses

Other Bridlington Enable Technology Training Courses

JQuery Bridlington Training Courses
VBA Bridlington Training Courses
Excel Power Pivot Bridlington Training Courses
Data Warehouse Bridlington Training Courses
JQuery Mobile Bridlington Training Courses
Access - Bridlington Access Training Courses