Enable Technology



About Enable Technology Oxford 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 course will always be taught by a Microsoft Certified Professional (MCP). We will issue each SQL Server Analysis Services training participant with learning resources which they can refer to post 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.

SQL Server Analysis Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology SQL Server Analysis Services training courses can be delivered at your offices. We can supply the necessary software and computers. If delivery onsite is an issue we will organise a socially distanced venue near you in Oxford. We offer the option of working with you to develop a bespoke SQL Server Analysis Services programme which precisely matches your organisations training requirements.

We also deliver this course online through virtual classrooms. Delegates can join scheduled SQL Server Analysis Services classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.

Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: EDF Energy PLC, Fujistu PLC, West Bromwich Building Society, Birmingham Heartlands Hospital, Royal Air Force, Barclays Bank PLC, Total Telecommunications Limited and Norwich Union PLC.

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Oxford
  • 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 ...
  • Import from Analysis Services
    DAX formula compatibility in DirectQuery mode Tables and Columns
    Restore from Power Pivot
    Set the Data Type of a Column
    Import from Power View
    Create and Manage KPIs Hierarchies
    Create a Calculated Table
    Create and Manage Partitions in the Workspace
    DirectQuery Mode
    Create and Manage Hierarchies Partitions
    Hide or freeze columns
    Enable DirectQuery mode in SSMS
    Test a model in DirectQuery mode
    Row filter mappings
    Add columns to a table
    Define partitions in DirectQuery models
    Create and Manage Measures KPIs
    Version comparison
    Manage Roles by using SSMS

  • See Training Course Details...

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Oxford
  • 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 ...
  • Modify or Delete in Solution Explorer Database Dimensions
    Define a Referenced Relationship and Referenced Relationship Properties
    Defined Linked Measure Groups Partitions
    Database permissions
    Authorizing access to objects and operations
    Modify or Delete an Analysis Services Database
    Dimension permissions
    Create a Time Dimension by Generating a Time Table
    Batch Processing Remote Processing
    Calculations using the Business Intelligence Wizard
    Define a Data Source View
    Backup Options Restore Options
    Document and Script an Analysis Services Database
    Change a Partition Source
    Processing Options and Settings
    Use a Template to Create an Action Deployment
    Create Calculated Members
    Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
    Partition Writeback Calculations
    Define Logical Primary Keys in a Data Source View
    Tools and Approaches for Processing

  • See Training Course Details...

Email us about this courses

Other Oxford Enable Technology Training Courses

JavaScript - Oxford JavaScript Training Courses
Power BI - Oxford Microsoft Power BI Training Courses
SSRS Oxford Training Courses
TSQL Oxford Training Courses
SQL - Oxford SQL Training Courses
Data Warehouse Oxford Training Courses