Enable Technology



About Enable Technology Tamworth SQL Server Analysis Services Training Courses

Enable Technology has twenty year track record of providing short intensive SQL Server Analysis Services skills based training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source after the course. 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 SQL Server Analysis Services courses are instructor led and taught by an experienced Microsoft expert. Enable Technology SQL Server Analysis Services courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. If you prefer we can offer an offsite socially distanced training location in Tamworth. 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.

This instructor led SQL Server Analysis Services training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Wolverhampton City Council, Birmingham Heartlands Hospital, Birmingham City Council, Royal Air Force, Capita Group PLC, Homeserve PLC, Carillion PLC and DHL Express.

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Tamworth
  • 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 ...
  • Set the Data Type of a Column
    Change table, column
    Delete Relationships
    Analyze in Excel
    Add a table Delete a Table
    Filter Data in a Table Relationships
    Create a New Tabular Model Project
    Data sources supported in SSAS  tabular 2016 Create Tabular Models
    Hide or freeze columns
    Data sources supported in tabular 1400 models
    Import Data
    Process Database, Table, or Partition
    Enable DirectQuery mode in SSDT
    Tabular model designer
    Create and Manage Roles
    Import from Analysis Services
    Create and Manage Perspectives Translations Roles
    Import from Power View
    Enable DirectQuery mode in SSMS

  • See Training Course Details...

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Tamworth
  • 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 Remote Partitions
    Define Time Intelligence
    Backup Options Restore Options
    Processing Databases, Dimensions and Partitions
    Deploy Model Solutions with the Deployment Utility
    Define Attribute Relationships
    Add a Standard Action
    Tools and Approaches for Processing
    Overview of SSAS Multidimensional Modelling
    KPIs Actions
    Processing Options and Settings
    Read Definition permissions
    Partition Writeback Calculations
    Multidimensional models
    Use Aggregate Functions
    Ragged Hierarchies
    Authorizing access to objects and operations
    Define Logical Primary Keys in a Data Source View
    View the XML for an Analysis Services Project Data Sources
    Calculations using the Business Intelligence Wizard
    Edit or Delete Partitions Merge Partitions

  • See Training Course Details...

Email us about this courses

Other Tamworth Enable Technology Training Courses

SQL Tamworth Training Courses
Power BI - Tamworth Microsoft Power BI Training Courses
JavaScript - Tamworth JavaScript Training Courses
Excel 365 Basic Tamworth Training Courses
Access Tamworth Training Courses
DAX Tamworth Training Courses