Enable Technology



About Enable Technology Herefordshire SQL Server Analysis Services Training Courses

Enable Technology SQL Server Analysis Services courses are short, skill focused and hands on. All of our tutors are Microsoft Certified Professionals. Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source 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.

Our primary method of delivery is instructor led training coupled with practical hands on activities. 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 course at a local socially distanced venue in Herefordshire. We will work with you prior to the course to tailor the SQL Server Analysis Services syllabus to match your requirements.

This instructor led SQL Server Analysis Services training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.

Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Queen's Medical Centre Nottingham, Birmingham City Council, Canadian High Commission, Aston University, Barclays Bank PLC, Unipart Group, Wolverhampton City Council and Birmingham City University.

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Herefordshire
  • 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 ...
  • Work with Diagrams in Data Source View Designer
    Create Calculated Members
    Deployment Requirements and Considerations for Analysis Services Deployment
    Create Local Partitions
    Deploy Model Solutions Using XMLA
    KPIs Actions
    Define a Fact Relationship and Fact Relationship Properties
    Define Time Intelligence
    Replace a Table or a Named Query in a Data Source View
    Create Measures and Measure Groups
    Define a Referenced Relationship and Referenced Relationship Properties
    Create an Analysis Services Project
    Supported Data Sources
    Define Attribute Relationships
    Processing Options and Settings
    Define a Regular Relationship and Regular Relationship Properties
    Designing Aggregations
    Delete a Data Source
    Set Partition Storage
    Rename a Multidimensional Database Processing a multidimensional model
    Configure Measure Group Properties

  • See Training Course Details...

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Herefordshire
  • 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 ...
  • Impersonation
    Analyze in Excel
    Import from Analysis Services
    Create and Manage Hierarchies Partitions
    Create a Calculated Table
    Create and Manage Perspectives Translations Roles
    Data sources supported in SSAS tabular 2017
    Test a model in DirectQuery mode
    Data types supported
    Data sources supported in tabular 1400 models
    Hide or freeze columns
    Import Data
    Specify Mark as Date Table for use with Time Intelligence
    Rename a Table or Column
    Import from Power View
    Row filter mappings
    Tabular model designer
    Enable DirectQuery mode in SSMS
    Process Tabular Model Partitions

  • See Training Course Details...

Email us about this courses

Other Herefordshire Enable Technology Training Courses

Excel Power Pivot Herefordshire Training Courses
JavaScript Herefordshire Training Courses
VBA Herefordshire Training Courses
Excel 365 Basic Herefordshire Training Courses
SSRS Herefordshire Training Courses
Power Query Herefordshire Training Courses