Enable Technology



About Enable Technology Sandwell SQL Server Analysis Services Training Courses

Enable Technology SQL Server Analysis Services courses are short, skill focused and hands on. All Enable Technology tutors are Microsoft certified experts. Every course participant is given SQL Server Analysis Services courseware which they can refer to after the training. We offer a post training support service and delegates will have access to a Microsoft expert on SQL Server Analysis Services for as long as they need.

Enable Technology training courses are delivered as instructor led courses. We can deliver at your premises. We can provide the equipment. We can also deliver the SQL Server Analysis Services course at a socially distanced local training venue in Sandwell. 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.

We can also deliver SQL Server Analysis Services courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.

The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Aston University, Dollond & Aitchison Limited, Keele University, GKN PLC, West Bromwich Building Society, TalkTalk Direct Limited, Royal & Sun Alliance Group PLC and Unipart Group.

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Sandwell
  • 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 ...
  • Hide or freeze columns
    Create a Relationship Between Two Tables
    Rename a Table or Column
    Analyze in Excel
    Enable DirectQuery mode in SSDT
    Data types supported
    Create a Calculated Table
    Enable DirectQuery mode in SSMS
    Create and Manage Roles
    Data sources supported in tabular 1400 models
    Connect to a tabular model database
    DAX formula compatibility in DirectQuery mode Tables and Columns
    Import Data
    Create and Manage Tabular Model Partitions
    Tabular model designer
    Import from Analysis Services
    Create and Manage Partitions in the Workspace
    Bi-directional cross filters  Calculations
    Data sources supported in SSAS  tabular 2016 Create Tabular Models
    Test a model in DirectQuery mode

  • See Training Course Details...

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Sandwell
  • 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 ...
  • Define Named Calculations in a Data Source View
    Deploy Model Solutions with the Deployment Utility
    Create Measures and Measure Groups
    Document and Script an Analysis Services Database
    Deploy Analysis Services Projects
    Define Logical Primary Keys in a Data Source View
    Cube or model permissions Process permissions
    Add or Remove Tables or Views in a Data Source View
    Use Aggregate Functions
    Create a Data Source
    Read Definition permissions
    Define Logical Relationships in a Data Source View
    Modify or Delete in Solution Explorer Database Dimensions
    Error Configuration Roles and Permissions
    Change a Partition Source
    Tools and Approaches for Processing
    Define Assignments and Other Script Commands
    Create Calculated Members
    Define a Data Source View
    KPIs Actions
    Rename a Multidimensional Database Processing a multidimensional model

  • See Training Course Details...

Email us about this courses

Other Sandwell Enable Technology Training Courses

Data Warehouse - Sandwell SQL Training Courses
Oracle SQL - Sandwell SQL Training Courses
Power BI - Sandwell Microsoft Power BI Training Courses
Excel 365 Intermediate - Sandwell Excel Training Courses
Power Query - Sandwell Excel Training Courses
Excel Power Pivot Sandwell Training Courses