Enable Technology



About Enable Technology Chadderton SQL Server Analysis Services Training Courses

We offer intensive two and three days SQL Server Analysis Services courses. The tutor delivering the course will be a Microsoft certified expert. We will issue each SQL Server Analysis Services training participant with learning resources which they can refer to post training. If delegates have have questions about SQL Server Analysis Services after the course they are welcome to contact the course Tutor. This post training support is ongoing.

Courses are instructor led and groups sizes small. Enable Technology SQL Server Analysis Services training courses can be delivered at your offices. We can supply the necessary software and computers. Another option is we can organise a local socially distanced training site in Chadderton. We are happy to modify the SQL Server Analysis Services syllabus to match your teams training requirements.

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.

The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: DHL Express, National Power PLC, Cadbury PLC, Dollond & Aitchison Limited, Total Telecommunications Limited, Shell UK Oil Products Ltd, Halfords Group PLC and Norfolk Police Constabulary.

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Chadderton
  • 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 ...
  • Data sources supported in tabular 1400 models
    Import data by using a native query
    Enable DirectQuery mode in SSMS
    Sort Data in a Table
    Topics include- Overview of SSAS Tabular models
    Import Data
    Hide or freeze columns
    Create a Calculated Column
    Data types supported
    Manage Roles by using SSMS
    Create and Manage Partitions in the Workspace
    Restore from Power Pivot
    Create and Manage Tabular Model Partitions
    Import from Power Pivot
    Understanding DAX in Tabular Models Measures
    Bi-directional cross filters  Calculations
    Create a Relationship Between Two Tables
    Database Process Partitions in the Workspace Database Perspectives
    Deploy from SQL Server Data Tools Manage Tabular Model Databases
    Specify Mark as Date Table for use with Time Intelligence

  • See Training Course Details...

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Chadderton
  • 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 ...
  • Configure Analysis Services Project Properties
    Edit or Delete Partitions Merge Partitions
    Using SQL Server Data Tools (SSDT)
    Processing Databases, Dimensions and Partitions
    Document and Script an Analysis Services Database
    Create Measures and Measure Groups
    Calculations using the Business Intelligence Wizard
    Cube or model permissions Process permissions
    Attach and Detach Analysis Services Databases
    Database permissions
    Read Definition permissions
    Deploy Model Solutions Using the Deployment Wizard
    Deploy Model Solutions with the Deployment Utility
    Create Local Partitions
    Define Logical Primary Keys in a Data Source View
    Create a Dimension by Generating a Non-Time Table in the Data Source
    Backup and Restore of Analysis Services Databases
    Define Time Intelligence
    Define a Regular Relationship and Regular Relationship Properties
    Set Impersonation Options for a Data Source Connection
    Error Configuration Roles and Permissions

  • See Training Course Details...

Email us about this courses

Other Chadderton Enable Technology Training Courses

DAX - Chadderton Excel Training Courses
VBA - Chadderton Excel Training Courses
Excel 365 Intermediate - Chadderton Excel Training Courses
SSRS - Chadderton SQL Server Reporting Services Training Courses
Access - Chadderton Access Training Courses
Data Warehouse - Chadderton SQL Training Courses