Enable Technology



About Enable Technology Telford SQL Server Analysis Services Training Courses

We are company which specialises in short, two and three day intensive SQL Server Analysis Services technology training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Each course participant will be issued with training SQL Server Analysis Services resources which they can continue to use after the training. Course participants are welcome contact the Tutor after the course with specific SQL Server Analysis Services queries. This support is open ended.

Delegates are taught by an experienced Microsoft professional. SQL Server Analysis Services courses are delivered through a mix of practical hands on exercises and walk throughs. Our SQL Server Analysis Services training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Alternatively we could schedule a course at a local socially distanced venue in Telford. We are happy to modify the SQL Server Analysis Services syllabus to match your teams training requirements.

We also deliver this course online. Delegates participate in a virtual SQL Server Analysis Services class and can both talk to and share their screen with the tutor.

Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Total Telecommunications Limited, TalkTalk Direct Limited, Norfolk Police Constabulary, Vodafone Group Services, Birmingham City University, Yell Group PLC, Boots UK Limited and Nuclear Engineering Services.

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Telford
  • 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 a New Tabular Model Project
    Enable DirectQuery mode in SSDT
    Test a model in DirectQuery mode
    Add columns to a table
    Add a table Delete a Table
    Import from Analysis Services
    Row filter mappings
    Connect to a tabular model database
    Filter Data in a Table Relationships
    Data types supported
    Create a Calculated Column
    Set the Data Type of a Column
    Create a Relationship Between Two Tables
    Deploy from SQL Server Data Tools Manage Tabular Model Databases
    Analyze in Excel
    Add sample data to DirectQuery models
    Create and Manage KPIs Hierarchies
    Define partitions in DirectQuery models
    Create and Manage Partitions in the Workspace

  • See Training Course Details...

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Telford
  • 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 ...
  • Processing Options and Settings
    Set Data Source Properties
    Define a Data Source View
    Error Configuration Roles and Permissions
    Rename a Multidimensional Database Processing a multidimensional model
    Work with Diagrams in Data Source View Designer
    Define Named Queries in a Data Source View
    Create a Dimension by Generating a Non-Time Table in the Data Source
    Create a Dimension Using the Dimension Wizard
    Define Assignments and Other Script Commands
    BI Wizard
    Configure Measure Group Properties
    Document and Script an Analysis Services Database
    Using SQL Server Data Tools (SSDT)
    Cube or model permissions Process permissions
    Backup Options Restore Options
    Read Definition permissions
    Delete a Data Source View Dimensions
    Deploy Model Solutions Using the Deployment Wizard
    Calculations using the Business Intelligence Wizard
    Replace a Table or a Named Query in a Data Source View

  • See Training Course Details...

Email us about this courses

Other Telford Enable Technology Training Courses

SSIS Telford Training Courses
SSRS Telford Training Courses
Access VBA Telford Training Courses
DAX Telford Training Courses
TSQL Telford Training Courses
SQL Telford Training Courses