Enable Technology

SQL SERVER ANALYSIS SERVICES EVESHAM TRAINING COURSES 

SQL SERVER ANALYSIS SERVICES TRAINING COURSES EVESHAM




About Enable Technology Evesham SQL Server Analysis Services Training Courses

Enable Technology offer short intensive skills based SQL Server Analysis Services training courses. We guarantee the training will be delivered by a Microsoft certified expert. We provide every candidate with SQL Server Analysis Services training materials which they keep after the course. 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. If delivery onsite is an issue we will organise a socially distanced venue near you in Evesham. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services training needs.

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 two decades of delivering technical training predominantly in the West Midlands. Our clients include: Royal Air Force, Carillion PLC, Dollond & Aitchison Limited, Nationwide Building Society Limited, Total Telecommunications Limited, Halfords Group PLC, DHL Express and EDF Energy PLC.




Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Evesham
  • 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 ...
  • Delete Relationships
    Enable DirectQuery mode in SSDT
    Connect to a tabular model database
    Create and Manage Measures KPIs
    Create and Manage Tabular Model Partitions
    Deploy from SQL Server Data Tools Manage Tabular Model Databases
    Process Tabular Model Partitions
    Data sources supported in tabular 1400 models
    Restore from Power Pivot
    Data sources supported in SSAS  tabular 2016 Create Tabular Models
    Create a Calculated Column
    Add columns to a table
    Understanding DAX in Tabular Models Measures
    Define partitions in DirectQuery models
    Import data by using a native query
    Import from Analysis Services
    Create and Manage Perspectives Translations Roles
    Hide or freeze columns
    Create a Relationship Between Two Tables
    Import from Power Pivot

  • See Training Course Details...


Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Evesham
  • 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 Calculated Members
    Rename a Multidimensional Database Processing a multidimensional model
    Set Partition Storage
    Define Logical Primary Keys in a Data Source View
    Configure Analysis Services Project Properties
    Designing Aggregations
    Define Logical Relationships in a Data Source View
    Create a Time Dimension by Generating a Time Table
    Explore Data in a Data Source View
    Define a Regular Relationship and Regular Relationship Properties
    Add or Remove Tables or Views in a Data Source View
    Define Named Queries in a Data Source View
    Batch Processing Remote Processing
    Partition Writeback Calculations
    Data Source Views
    Set Impersonation Options for a Data Source Connection
    Create User-Defined Hierarchies
    View the XML for an Analysis Services Project Data Sources
    KPIs Actions
    Configure Measure Group Properties

  • See Training Course Details...



Email us about this courses



Other Evesham Enable Technology Training Courses

Power BI Evesham Training Courses
Access VBA Evesham Training Courses
Power Query - Evesham Excel Training Courses
Excel 365 Intermediate - Evesham Excel Training Courses
Excel 365 Advanced Evesham Training Courses
SQL Evesham Training Courses