Enable Technology



About Enable Technology York SQL Server Analysis Services Training Courses

We offer intensive two and three days SQL Server Analysis Services courses. All Enable Technology tutors are Microsoft certified experts. We provide every candidate with SQL Server Analysis Services training materials which they keep after the course. Our policy is to provide open ended SQL Server Analysis Services post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.

Courses are instructor led and groups sizes small. Our SQL Server Analysis Services training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Another way we could deliver the SQL Server Analysis Services course is at a local socially distanced training site. We are happy to modify the SQL Server Analysis Services syllabus to match your teams training requirements.

SQL Server Analysis Services courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.

In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Lloyds TSB Bank PLC, Total Telecommunications Limited, Yell Group PLC, Barclays Bank PLC, DHL Express, Capita Group PLC, Birmingham City Council and Keele University.

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: York
  • 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 and Manage KPIs Hierarchies
    Process Tabular Model Partitions
    Add columns to a table
    Import from Analysis Services
    Create and Manage Hierarchies Partitions
    Data types supported
    Rename a Table or Column
    Create a New Tabular Model Project
    Define partitions in DirectQuery models
    Deploy from SQL Server Data Tools Manage Tabular Model Databases
    Test a model in DirectQuery mode
    Analyze a tabular model in Excel Deploy tabular model solutions
    DirectQuery Mode
    Import from Power Pivot
    Connect to a tabular model database
    Object-level security
    Import Data
    Add sample data to DirectQuery models
    Topics include- Overview of SSAS Tabular models
    Understanding DAX in Tabular Models Measures

  • See Training Course Details...

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: York
  • 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 ...
  • Partition Writeback Calculations
    Define a Referenced Relationship and Referenced Relationship Properties
    Cube or model permissions Process permissions
    Set Partition Storage
    Create User-Defined Hierarchies
    Ragged Hierarchies
    View the XML for an Analysis Services Project Data Sources
    Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
    KPIs Actions
    Multidimensional models
    Use a Template to Create an Action Deployment
    Deploy Analysis Services Projects
    Create a Dimension Using the Dimension Wizard
    Tools and Approaches for Processing
    Error Configuration Roles and Permissions
    Define Semiadditive Behavior
    Add or Remove Tables or Views in a Data Source View
    Create a Time Dimension by Generating a Time Table
    BI Wizard
    Data Source Views
    Define a Fact Relationship and Fact Relationship Properties

  • See Training Course Details...

Email us about this courses

Other York Enable Technology Training Courses

Power Query - York Excel Training Courses
Access VBA York Training Courses
Excel 365 Advanced York Training Courses
Excel 365 Basic - York Excel Training Courses
Oracle SQL - York SQL Training Courses
Access - York Access Training Courses