Enable Technology

SQL SERVER ANALYSIS SERVICES YORK TRAINING COURSES 

SQL SERVER ANALYSIS SERVICES TRAINING COURSES YORK




About Enable Technology York SQL Server Analysis Services Training Courses

We are a company that offers short, practical, SQL Server Analysis Services hands on technology 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. We also provide an ongoing support service to people attending our SQL Server Analysis Services courses. Delegates can contact the course tutor with specific SQL Server Analysis Services questions for as long as they need following the course.

We provide instructor led training coupled with hands on training. 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 York. We offer the option of working with you to develop a bespoke SQL Server Analysis Services programme which precisely matches your organisations training requirements.

We also deliver this course online through virtual classrooms. Delegates can join scheduled SQL Server Analysis Services classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.

Our teaching team have over twenty years continuous technical training experience. Our clients include: Vodafone Group Services, Total Telecommunications Limited, Birmingham Heartlands Hospital, Lloyds TSB Bank PLC, Canadian High Commission, Norwich Union PLC, University of Birmingham and Fujistu PLC.




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 ...
  • Deploy Model Solutions Using the Deployment Wizard
    Read Definition permissions
    Deploy Model Solutions with the Deployment Utility
    Use Aggregate Functions
    Add a Standard Action
    Define a Referenced Relationship and Referenced Relationship Properties
    Test an Action
    Work with Diagrams in Data Source View Designer
    Use a Template to Create an Action Deployment
    Define a Fact Relationship and Fact Relationship Properties
    Set Partition Storage
    Cube or model permissions Process permissions
    Define Named Calculations in a Data Source View
    View the XML for an Analysis Services Project Data Sources
    Delete a Data Source
    Modify or Delete in Solution Explorer Database Dimensions
    Rename a Multidimensional Database Processing a multidimensional model
    Set Impersonation Options for a Data Source Connection
    Deploy Analysis Services Projects
    Create Calculated Members
    Configure Measure Group Properties

  • See Training Course Details...


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 ...
  • Import from Power View
    Database Process Partitions in the Workspace Database Perspectives
    Import from Analysis Services
    Delete Relationships
    Test a model in DirectQuery mode
    Create and Manage Measures KPIs
    Create and Manage Hierarchies Partitions
    Impersonation
    Create a Relationship Between Two Tables
    Add a table Delete a Table
    Row filter mappings
    Create and Manage KPIs Hierarchies
    Process Database, Table, or Partition
    Create a New Tabular Model Project
    Manage Roles by using SSMS
    Deploy from SQL Server Data Tools Manage Tabular Model Databases
    Filter Data in a Table Relationships
    Data sources supported in tabular 1200 models
    Import Data
    Set the Data Type of a Column

  • See Training Course Details...



Email us about this courses



Other York Enable Technology Training Courses

Power BI - York Microsoft Power BI Training Courses
JQuery Mobile York Training Courses
PL/SQL York Training Courses
TSQL York Training Courses
SSRS York Training Courses
DAX York Training Courses