Enable Technology



About Enable Technology Solihull 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. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.

We provide instructor led training coupled with hands on training. Enable Technology SQL Server Analysis Services training courses can be delivered at your offices. We can supply the necessary software and computers. We can also deliver the SQL Server Analysis Services course at a socially distanced local training venue in Solihull. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services 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.

Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Queen's Medical Centre Nottingham, Nationwide Building Society Limited, Boots UK Limited, Lloyds TSB Bank PLC, Carillion PLC, Capita Group PLC, National Power PLC and West Bromwich Building Society.

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Solihull
  • 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 a Calculated Table
    Analyze a tabular model in Excel Deploy tabular model solutions
    Enable DirectQuery mode in SSMS
    Delete a Column
    Filter Data in a Table Relationships
    Object-level security
    Bi-directional cross filters  Calculations
    Row filter mappings
    Data sources supported in tabular 1400 models
    DirectQuery Mode
    Test a model in DirectQuery mode
    Create and Manage Perspectives Translations Roles
    Specify Mark as Date Table for use with Time Intelligence
    Process Database, Table, or Partition
    Create and Manage Partitions in the Workspace
    Import Data
    Create and Manage Measures KPIs
    Change table, column
    Connect to a tabular model database
    Import from Power Pivot

  • See Training Course Details...

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Solihull
  • 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 ...
  • Attach and Detach Analysis Services Databases
    Modify or Delete an Analysis Services Database
    KPIs Actions
    Backup and Restore of Analysis Services Databases
    Data Source Views
    Replace a Table or a Named Query in a Data Source View
    Work with Diagrams in Data Source View Designer
    Designing Aggregations
    Create Local Partitions
    Create Measures and Measure Groups
    Add a Standard Action
    Define Assignments and Other Script Commands
    Move an Analysis Services Database
    Dimension permissions
    Set Partition Storage
    Database permissions
    Define Attribute Relationships
    Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
    Processing Databases, Dimensions and Partitions
    Overview of SSAS Multidimensional Modelling
    Read Definition permissions

  • See Training Course Details...

Email us about this courses

Other Solihull Enable Technology Training Courses

Power Query - Solihull Excel Training Courses
Excel 365 Intermediate - Solihull Excel Training Courses
DAX Solihull Training Courses
JavaScript - Solihull JavaScript Training Courses
Excel Power Pivot - Solihull Excel Training Courses
VBA - Solihull Excel Training Courses