Enable Technology



About Enable Technology Wells SQL Server Analysis Services Training Courses

We have a twenty year history of providing skills based SQL Server Analysis Services industry training. All of our tutors are Microsoft Certified Professionals. Each course participant will be issued with training SQL Server Analysis Services resources which they can continue to use after the training. 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.

SQL Server Analysis Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology can supply all of the equipment necessary to deliver SQL Server Analysis Services courses onsite at your offices. You simply need to provide a suitable room. If you prefer we can offer an offsite socially distanced training location in Wells. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services training needs.

This course can also be delivered in a virtual classroom. Delegates can log into a scheduled SQL Server Analysis Services course, watch the tutor demonstrate tasks, ask questions and share their own screen.

We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Nuclear Engineering Services, Vodafone Group Services, Keele University, West Bromwich Building Society, TalkTalk Direct Limited, Loughborough University, Aston University and University of Birmingham.

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Wells
  • 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 ...
  • Define partitions in DirectQuery models
    Test a model in DirectQuery mode
    Bi-directional cross filters  Calculations
    Manage Roles by using SSMS
    Delete a Column
    Topics include- Overview of SSAS Tabular models
    Filter Data in a Table Relationships
    Data types supported
    Analyze in Excel
    Import data by using a native query
    Add columns to a table
    Version comparison
    Add a table Delete a Table
    Enable DirectQuery mode in SSMS
    Hide or freeze columns
    Create a Relationship Between Two Tables
    Create a New Tabular Model Project
    Deploy from SQL Server Data Tools Manage Tabular Model Databases
    Restore from Power Pivot
    Process Database, Table, or Partition
    Create and Manage Tabular Model Partitions

  • See Training Course Details...

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Wells
  • 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 ...
  • Tools and Approaches for Processing
    Create Calculated Members
    Attach and Detach Analysis Services Databases
    Define a Referenced Relationship and Referenced Relationship Properties
    Batch Processing Remote Processing
    Define Assignments and Other Script Commands
    Define Logical Relationships in a Data Source View
    Read Definition permissions
    Set Impersonation Options for a Data Source Connection
    Calculations using the Business Intelligence Wizard
    Add a Standard Action
    Define Semiadditive Behavior
    Create Named Sets
    Data Source object permissions
    Create Remote Partitions
    Cube or model permissions Process permissions
    Create a Dimension Using the Dimension Wizard
    Backup and Restore of Analysis Services Databases
    Move an Analysis Services Database
    Deployment Requirements and Considerations for Analysis Services Deployment
    Work with Diagrams in Data Source View Designer

  • See Training Course Details...

Email us about this courses

Other Wells Enable Technology Training Courses

VBA Wells Training Courses
Data Warehouse - Wells SQL Training Courses
Access VBA - Wells Access Training Courses
Report Builder Wells Training Courses
Excel 365 Advanced Wells Training Courses
JavaScript Wells Training Courses