Enable Technology

SQL SERVER ANALYSIS SERVICES MALVERN TRAINING COURSES 

SQL SERVER ANALYSIS SERVICES TRAINING COURSES MALVERN




About Enable Technology Malvern SQL Server Analysis Services Training Courses

We have a twenty year history of providing skills based SQL Server Analysis Services industry training. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. All candidates receive comprehensive SQL Server Analysis Services training materials and practice files which are theirs to refer to 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.

Our primary method of delivery is instructor led training coupled with practical hands on activities. We are set up to deliver SQL Server Analysis Services training courses onsite at your premises. The SQL Server Analysis Services course could also be scheduled at a socially distanced site near you in Malvern. Every SQL Server Analysis Services course can be modified to meet your bespoke 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.

We have operated primarily in the West Midlands for twenty years. Our clients include: West Bromwich Building Society, Unipart Group, Norwich Union PLC, Loughborough University, Cadbury PLC, Keele University, Fujistu PLC and DHL Express.




Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Malvern
  • 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 ...
  • Dimension permissions
    Processing Databases, Dimensions and Partitions
    Create a Dimension by Generating a Non-Time Table in the Data Source
    Define a Fact Relationship and Fact Relationship Properties
    Set Partition Storage
    Define a Data Source View
    Backup and Restore of Analysis Services Databases
    Create Local Partitions
    Deployment Requirements and Considerations for Analysis Services Deployment
    Tools and Approaches for Processing
    Using SQL Server Data Tools (SSDT)
    Ragged Hierarchies
    Create Measures and Measure Groups
    Create Remote Partitions
    Create a Dimension by Using an Existing Table
    Create a Time Dimension by Generating a Time Table
    Multidimensional models
    Define a Regular Relationship and Regular Relationship Properties
    Deploy Model Solutions Using XMLA
    Define Assignments and Other Script Commands
    Define Named Queries in a Data Source View

  • See Training Course Details...


Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Malvern
  • 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 Perspectives Translations Roles
    Delete Relationships
    Import from Power View
    Set the Data Type of a Column
    Row filter mappings
    Specify Mark as Date Table for use with Time Intelligence
    Bi-directional cross filters  Calculations
    Import Data
    Test a model in DirectQuery mode
    Create and Manage Tabular Model Partitions
    Create a Relationship Between Two Tables
    Hide or freeze columns
    Create and Manage KPIs Hierarchies
    Sort Data in a Table
    Restore from Power Pivot
    Create and Manage Roles
    Understanding DAX in Tabular Models Measures
    Database Process Partitions in the Workspace Database Perspectives
    Impersonation
    Analyze in Excel

  • See Training Course Details...



Email us about this courses



Other Malvern Enable Technology Training Courses

SSRS - Malvern SQL Server Reporting Services Training Courses
Excel Power Pivot - Malvern Excel Training Courses
Report Builder - Malvern SQL Server Reporting Services Training Courses
Data Warehouse - Malvern SQL Training Courses
PL/SQL Malvern Training Courses
TSQL - Malvern SQL Training Courses