Enable Technology



About Enable Technology Stafford 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. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Each person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials after the training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Analysis Services queries.

Courses are instructor led and groups sizes small. Enable Technology can provide SQL Server Analysis Services courses onsite at your location. We will bring the necessary laptops with the required software installed. Alternatively we could schedule a SQL Server Analysis Services course at an alternative training site in Stafford. We will work with you prior to the course to tailor the SQL Server Analysis Services syllabus to match your requirements.

SQL Server Analysis Services courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.

We have operated primarily in the West Midlands for twenty years. Our clients include: Vodafone Group Services, Royal Air Force, Cadbury PLC, Queen's Medical Centre Nottingham, Canadian High Commission, West Bromwich Building Society, Norfolk Police Constabulary and Wolverhampton City Council.

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Stafford
  • 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 ...
  • Database permissions
    Create an Analysis Services Project
    Data Source Views
    Set Partition Storage
    Data Source object permissions
    Using SQL Server Data Tools (SSDT)
    Backup and Restore of Analysis Services Databases
    Overview of SSAS Multidimensional Modelling
    Document and Script an Analysis Services Database
    Move an Analysis Services Database
    Define Logical Relationships in a Data Source View
    Modify or Delete an Analysis Services Database
    Define Named Queries in a Data Source View
    Define Semiadditive Behavior
    Create Calculated Members
    Calculations using the Business Intelligence Wizard
    Supported Data Sources
    Create Named Sets
    Create User-Defined Hierarchies
    Create Measures and Measure Groups
    Partition Writeback Calculations

  • See Training Course Details...

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Stafford
  • 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 ...
  • Sort Data in a Table
    Data sources supported in tabular 1200 models
    Add a table Delete a Table
    Process Database, Table, or Partition
    Import from Power Pivot
    Create and Manage Measures KPIs
    Create a Relationship Between Two Tables
    Bi-directional cross filters  Calculations
    Tabular model designer
    Set the Data Type of a Column
    Delete Relationships
    Create and Manage KPIs Hierarchies
    DirectQuery Mode
    Create and Manage Perspectives Translations Roles
    Version comparison
    Create and Manage Roles
    Object-level security
    Analyze in Excel
    Filter Data in a Table Relationships

  • See Training Course Details...

Email us about this courses

Other Stafford Enable Technology Training Courses

Excel 365 Advanced - Stafford Excel Training Courses
Access VBA - Stafford Access Training Courses
SSRS Stafford Training Courses
Oracle SQL - Stafford SQL Training Courses
Data Warehouse Stafford Training Courses
Power BI - Stafford Microsoft Power BI Training Courses