Enable Technology



About Enable Technology Milford Haven SQL Server Analysis Services Training Courses

Enable Technology provides practical SQL Server Analysis Services skills based technology training. We guarantee the training will be delivered by a Microsoft certified expert. Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source after the course. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.

Enable Technology training courses are delivered as instructor led courses. Enable Technology SQL Server Analysis Services courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Alternatively we could schedule a SQL Server Analysis Services course at an alternative training site in Milford Haven. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.

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.

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Royal & Sun Alliance Group PLC, Birmingham Heartlands Hospital, Royal Air Force, Nationwide Building Society Limited, West Bromwich Building Society, EDF Energy PLC, Norfolk Police Constabulary and Loughborough University.

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Milford Haven
  • 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 ...
  • Add a Standard Action
    Test an Action
    Define a Referenced Relationship and Referenced Relationship Properties
    Change a Partition Source
    Partition Writeback Calculations
    Deploy Model Solutions Using XMLA
    Create Measures and Measure Groups
    Document and Script an Analysis Services Database
    Read Definition permissions
    Database permissions
    View the XML for an Analysis Services Project Data Sources
    Delete a Data Source
    Define a Data Source View
    Tools and Approaches for Processing
    Overview of SSAS Multidimensional Modelling
    Defined Linked Measure Groups Partitions
    Define Assignments and Other Script Commands
    Calculations using the Business Intelligence Wizard
    Authorizing access to objects and operations
    Create User-Defined Hierarchies
    Cube or model permissions Process permissions

  • See Training Course Details...

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Milford Haven
  • 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 Partitions in the Workspace
    Enable DirectQuery mode in SSDT
    Test a model in DirectQuery mode
    Restore from Power Pivot
    Add columns to a table
    Import from Analysis Services
    Version comparison
    Delete Relationships
    Analyze in Excel
    Object-level security
    Create a Relationship Between Two Tables
    DAX formula compatibility in DirectQuery mode Tables and Columns
    Deploy from SQL Server Data Tools Manage Tabular Model Databases
    Connect to a tabular model database
    Filter Data in a Table Relationships
    Rename a Table or Column
    Data sources supported in SSAS  tabular 2016 Create Tabular Models
    Hide or freeze columns
    Process Tabular Model Partitions
    Bi-directional cross filters  Calculations

  • See Training Course Details...

Email us about this courses

Other Milford Haven Enable Technology Training Courses

JavaScript Milford Haven Training Courses
JQuery Mobile Milford Haven Training Courses
SQL - Milford Haven SQL Training Courses
Access VBA Milford Haven Training Courses
Data Warehouse Milford Haven Training Courses
Excel Power Pivot Milford Haven Training Courses