Enable Technology



About Enable Technology Rowley SQL Server Analysis Services Training Courses

Enable Technology specialise in succinct skills based SQL Server Analysis Services training. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. We will issue each SQL Server Analysis Services training participant with learning resources which they can refer to post training. Anyone attending the course can contact the Tutor for as long as they like after the SQL Server Analysis Services course. The ongoing support by a Microsoft expert is an important part of the service we offer.

Enable Technology SQL Server Analysis Services courses are instructor led and taught by an experienced Microsoft expert. Enable Technology can provide SQL Server Analysis Services courses onsite at your location. We will bring the necessary laptops with the required software installed. Alternatively we could schedule a course at a local socially distanced venue in Rowley. 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.

The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Barclays Bank PLC, TalkTalk Direct Limited, DHL Express, GKN PLC, Birmingham Heartlands Hospital, Norwich Union PLC, Vodafone Group Services and Total Telecommunications Limited.

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Rowley
  • 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 ...
  • Process Tabular Model Partitions
    Manage Roles by using SSMS
    Create a New Tabular Model Project
    Filter Data in a Table Relationships
    Row filter mappings
    Data sources supported in tabular 1200 models
    Create and Manage Tabular Model Partitions
    Bi-directional cross filters  Calculations
    Create and Manage KPIs Hierarchies
    Sort Data in a Table
    Add sample data to DirectQuery models
    Enable DirectQuery mode in SSMS
    Test a model in DirectQuery mode
    Create and Manage Partitions in the Workspace
    Analyze a tabular model in Excel Deploy tabular model solutions
    Create and Manage Hierarchies Partitions
    Understanding DAX in Tabular Models Measures
    Enable DirectQuery mode in SSDT
    Version comparison

  • See Training Course Details...

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Rowley
  • 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 ...
  • Backup Options Restore Options
    Define a Regular Relationship and Regular Relationship Properties
    Move an Analysis Services Database
    Delete a Data Source View Dimensions
    Deploy Model Solutions Using the Deployment Wizard
    Create a Data Source
    Deploy Model Solutions with the Deployment Utility
    Error Configuration Roles and Permissions
    Define Named Queries in a Data Source View
    Data Source object permissions
    Define Assignments and Other Script Commands
    Tools and Approaches for Processing
    Create an Analysis Services Project
    Create a Dimension by Using an Existing Table
    Deploy Analysis Services Projects
    Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
    Calculations using the Business Intelligence Wizard
    Database permissions
    Define Named Calculations in a Data Source View
    Document and Script an Analysis Services Database
    Create Named Sets

  • See Training Course Details...

Email us about this courses

Other Rowley Enable Technology Training Courses

SQL Rowley Training Courses
Report Builder Rowley Training Courses
Excel Power Pivot Rowley Training Courses
PL/SQL - Rowley SQL Training Courses
Excel 365 Basic Rowley Training Courses
Data Warehouse - Rowley SQL Training Courses