Enable Technology



About Enable Technology Cirencester SQL Server Analysis Services Training Courses

We are company which specialises in short, two and three day intensive SQL Server Analysis Services technology training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Every course participant will receives course practice files and SQL Server Analysis Services course resources that can be referenced post training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Analysis Services queries.

Enable Technology offers instructor led training taught by technology specialists. Enable Technology SQL Server Analysis Services courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. We can also deliver the SQL Server Analysis Services course at a socially distanced local training venue in Cirencester. We are happy to modify the SQL Server Analysis Services syllabus to match your teams 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.

In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Aston University, South Staffordshire Water PLC, Dollond & Aitchison Limited, Norfolk Police Constabulary, Cadbury PLC, Birmingham City Council, Birmingham Heartlands Hospital and TalkTalk Direct Limited.

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Cirencester
  • 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 ...
  • Data sources supported in SSAS tabular 2017
    Data sources supported in tabular 1200 models
    Define partitions in DirectQuery models
    Import Data
    Object-level security
    Rename a Table or Column
    Data sources supported in tabular 1400 models
    Data sources supported in SSAS  tabular 2016 Create Tabular Models
    Manage Roles by using SSMS
    Add a table Delete a Table
    Add sample data to DirectQuery models
    Create and Manage Measures KPIs
    Bi-directional cross filters  Calculations
    Enable DirectQuery mode in SSDT
    Import from Analysis Services
    Create a New Tabular Model Project
    Deploy from SQL Server Data Tools Manage Tabular Model Databases
    Create and Manage KPIs Hierarchies
    Create and Manage Perspectives Translations Roles
    Process Tabular Model Partitions

  • See Training Course Details...

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Cirencester
  • 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 ...
  • Error Configuration Roles and Permissions
    KPIs Actions
    Rename a Multidimensional Database Processing a multidimensional model
    Create Remote Partitions
    Add or Remove Tables or Views in a Data Source View
    Create Measures and Measure Groups
    Delete a Data Source View Dimensions
    Database permissions
    Use Aggregate Functions
    Define Semiadditive Behavior
    Work with Diagrams in Data Source View Designer
    Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
    Define a Fact Relationship and Fact Relationship Properties
    Dimension permissions
    Test an Action
    Define Logical Relationships in a Data Source View
    Set Impersonation Options for a Data Source Connection
    BI Wizard
    Tools and Approaches for Processing
    Processing Databases, Dimensions and Partitions
    Set Partition Storage

  • See Training Course Details...

Email us about this courses

Other Cirencester Enable Technology Training Courses

SQL - Cirencester SQL Training Courses
Data Warehouse - Cirencester SQL Training Courses
VBA - Cirencester Excel Training Courses
Access Cirencester Training Courses
Report Builder Cirencester Training Courses
Excel 365 Basic - Cirencester Excel Training Courses