Enable Technology



About Enable Technology West Midlands SQL Server Analysis Services Training Courses

Enable Technology provides practical SQL Server Analysis Services skills based technology training. All of our tutors are Microsoft Certified Professionals. All candidates receive comprehensive SQL Server Analysis Services training materials and practice files which are theirs to refer to after the course. Course participants are welcome contact the Tutor after the course with specific SQL Server Analysis Services queries. This support is open ended.

Our primary method of delivery is instructor led training coupled with practical hands on activities. We can set up a training lab at your premises and deliver SQL Server Analysis Services courses onsite at your site. We are also more than happy to organise a local course at a socially distanced training location in West Midlands. We will work with you prior to the course to tailor the SQL Server Analysis Services syllabus to match your requirements.

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.

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Canadian High Commission, Countrywide Homes Limited, Royal Air Force, EDF Energy PLC, Total Telecommunications Limited, Carillion PLC, Shell UK Oil Products Ltd and Nuclear Engineering Services.

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: West Midlands
  • 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 New Tabular Model Project
    Bi-directional cross filters  Calculations
    Import from Power View
    Define partitions in DirectQuery models
    Analyze in Excel
    Process Tabular Model Partitions
    DAX formula compatibility in DirectQuery mode Tables and Columns
    Create and Manage Perspectives Translations Roles
    Analyze a tabular model in Excel Deploy tabular model solutions
    Enable DirectQuery mode in SSMS
    Tabular model designer
    Database Process Partitions in the Workspace Database Perspectives
    Add a table Delete a Table
    Manage Roles by using SSMS
    Deploy from SQL Server Data Tools Manage Tabular Model Databases
    Rename a Table or Column
    Import data by using a native query
    Version comparison
    Create and Manage Tabular Model Partitions

  • See Training Course Details...

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: West Midlands
  • 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 User-Defined Hierarchies
    Test an Action
    Delete a Data Source
    KPIs Actions
    Authorizing access to objects and operations
    Explore Data in a Data Source View
    Modify or Delete an Analysis Services Database
    Calculations using the Business Intelligence Wizard
    Create a Dimension by Generating a Non-Time Table in the Data Source
    Create Measures and Measure Groups
    Deployment Requirements and Considerations for Analysis Services Deployment
    Define a Regular Relationship and Regular Relationship Properties
    Backup Options Restore Options
    Attach and Detach Analysis Services Databases
    Create Named Sets
    Backup and Restore of Analysis Services Databases
    Designing Aggregations
    Create Local Partitions
    Work with Diagrams in Data Source View Designer
    Create a Time Dimension by Generating a Time Table
    Create a Dimension Using the Dimension Wizard

  • See Training Course Details...

Email us about this courses

Other West Midlands Enable Technology Training Courses

PL/SQL - West Midlands SQL Training Courses
Data Warehouse West Midlands Training Courses
VBA - West Midlands Excel Training Courses
Power BI - West Midlands Microsoft Power BI Training Courses
Access - West Midlands Access Training Courses
Excel Power Pivot - West Midlands Excel Training Courses