Enable Technology



About Enable Technology Derby 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. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source after the course. Course participants are welcome contact the Tutor after the course with specific SQL Server Analysis Services queries. This support is open ended.

Our primary method of delivery is instructor led training coupled with practical hands on activities. Enable Technology SQL Server Analysis Services courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. If delivery onsite is an issue we will organise a socially distanced venue near you in Derby. 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 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 Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Norfolk Police Constabulary, Countrywide Homes Limited, West Bromwich Building Society, Total Telecommunications Limited, GKN PLC, Unipart Group, Fujistu PLC and National Power PLC.

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Derby
  • 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
    Modify or Delete in Solution Explorer Database Dimensions
    Multidimensional models
    Deploy Model Solutions Using the Deployment Wizard
    Create a Data Source
    Define a Regular Relationship and Regular Relationship Properties
    Document and Script an Analysis Services Database
    Ragged Hierarchies
    Delete a Data Source View Dimensions
    Authorizing access to objects and operations
    Create a Dimension by Generating a Non-Time Table in the Data Source
    Configure Analysis Services Project Properties
    Create an Analysis Services Project
    Define Attribute Relationships
    Modify or Delete an Analysis Services Database
    Deploy Analysis Services Projects
    Designing Aggregations
    Define Logical Primary Keys in a Data Source View
    Create a Dimension Using the Dimension Wizard
    Processing Databases, Dimensions and Partitions
    Database permissions

  • See Training Course Details...

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Derby
  • 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 2016 Create Tabular Models
    Process Database, Table, or Partition
    Enable DirectQuery mode in SSDT
    Create and Manage Tabular Model Partitions
    Rename a Table or Column
    DAX formula compatibility in DirectQuery mode Tables and Columns
    Import from Power View
    Connect to a tabular model database
    Test a model in DirectQuery mode
    Create a New Tabular Model Project
    Database Process Partitions in the Workspace Database Perspectives
    Delete a Column
    Import from Power Pivot
    Data sources supported in tabular 1200 models
    Data sources supported in SSAS tabular 2017
    Manage Roles by using SSMS
    Delete Relationships
    Filter Data in a Table Relationships
    Analyze in Excel
    Object-level security

  • See Training Course Details...

Email us about this courses

Other Derby Enable Technology Training Courses

Excel Power Pivot - Derby Excel Training Courses
SSRS Derby Training Courses
SSIS Derby Training Courses
Access VBA - Derby Access Training Courses
Excel 365 Advanced Derby Training Courses
Power BI - Derby Microsoft Power BI Training Courses