Enable Technology



About Enable Technology Doncaster SQL Server Analysis Services Training Courses

We offer intensive two and three days SQL Server Analysis Services courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). All course participants are issued SQL Server Analysis Services training manuals they can refer to after the course. 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 offers instructor led training taught by technology specialists. We can set up a training lab at your premises and deliver SQL Server Analysis Services courses onsite at your site. If you prefer we can offer an offsite socially distanced training location in Doncaster. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services training requirements.

This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.

The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Halfords Group PLC, Shell UK Oil Products Ltd, Countrywide Homes Limited, Royal & Sun Alliance Group PLC, Birmingham Heartlands Hospital, Carillion PLC, Vodafone Group Services and Norwich Union PLC.

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Doncaster
  • 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
    Deploy Model Solutions with the Deployment Utility
    Delete a Data Source View Dimensions
    Add or Remove Tables or Views in a Data Source View
    Work with Diagrams in Data Source View Designer
    Change a Partition Source
    Deploy Analysis Services Projects
    Create Measures and Measure Groups
    Rename a Multidimensional Database Processing a multidimensional model
    Define Logical Primary Keys in a Data Source View
    Defined Linked Measure Groups Partitions
    KPIs Actions
    Using SQL Server Data Tools (SSDT)
    Backup and Restore of Analysis Services Databases
    Read Definition permissions
    Define Semiadditive Behavior
    Move an Analysis Services Database
    Define Attribute Relationships
    Create an Analysis Services Project
    Define Named Queries in a Data Source View
    Create Local Partitions

  • See Training Course Details...

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Doncaster
  • 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 ...
  • Create a Calculated Table
    Specify Mark as Date Table for use with Time Intelligence
    Add sample data to DirectQuery models
    Process Tabular Model Partitions
    Create and Manage Partitions in the Workspace
    Topics include- Overview of SSAS Tabular models
    Change table, column
    Create and Manage Hierarchies Partitions
    Bi-directional cross filters  Calculations
    Process Database, Table, or Partition
    Create and Manage Tabular Model Partitions
    Delete a Column
    Connect to a tabular model database
    Understanding DAX in Tabular Models Measures
    Enable DirectQuery mode in SSDT
    Data sources supported in tabular 1400 models
    Define partitions in DirectQuery models
    Create a New Tabular Model Project
    Import Data
    Analyze in Excel

  • See Training Course Details...

Email us about this courses

Other Doncaster Enable Technology Training Courses

Power BI Doncaster Training Courses
TSQL - Doncaster SQL Training Courses
JQuery Mobile - Doncaster JavaScript Training Courses
SQL Doncaster Training Courses
Excel 365 Advanced Doncaster Training Courses
SSRS - Doncaster SQL Server Reporting Services Training Courses