Enable Technology



About Enable Technology Bath SQL Server Analysis Services Training Courses

We offer intensive two and three days SQL Server Analysis Services courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. All course participants are issued SQL Server Analysis Services training manuals they can refer to after the course. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.

Enable Technology SQL Server Analysis Services courses are instructor led and taught by an experienced Microsoft expert. Enable Technology can supply all of the equipment necessary to deliver SQL Server Analysis Services courses onsite at your offices. You simply need to provide a suitable room. The SQL Server Analysis Services course could also be scheduled at a socially distanced site near you in Bath. 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.

We have operated primarily in the West Midlands for twenty years. Our clients include: DHL Express, Nuclear Engineering Services, GKN PLC, Unipart Group, Royal & Sun Alliance Group PLC, Norwich Union PLC, University of Birmingham and Lloyds TSB Bank PLC.

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Bath
  • 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 Relationship Between Two Tables
    Object-level security
    Create a Calculated Table
    Create and Manage Hierarchies Partitions
    Define partitions in DirectQuery models
    DirectQuery Mode
    Data sources supported in SSAS tabular 2017
    Enable DirectQuery mode in SSMS
    Change table, column
    Hide or freeze columns
    Create a Calculated Column
    Import Data
    Data sources supported in SSAS  tabular 2016 Create Tabular Models
    Enable DirectQuery mode in SSDT
    Create and Manage Perspectives Translations Roles
    Create and Manage Measures KPIs
    Restore from Power Pivot
    Add a table Delete a Table
    Understanding DAX in Tabular Models Measures

  • See Training Course Details...

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Bath
  • 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 ...
  • Create a Dimension by Generating a Non-Time Table in the Data Source
    Set Partition Storage
    Configure Measure Group Properties
    Set Impersonation Options for a Data Source Connection
    Backup and Restore of Analysis Services Databases
    Create a Data Source
    Create a Dimension by Using an Existing Table
    Work with Diagrams in Data Source View Designer
    Define Time Intelligence
    Create Remote Partitions
    Deployment Requirements and Considerations for Analysis Services Deployment
    Using SQL Server Data Tools (SSDT)
    Defined Linked Measure Groups Partitions
    Test an Action
    Multidimensional models
    Define Semiadditive Behavior
    Dimension permissions
    Create a Time Dimension by Generating a Time Table
    KPIs Actions
    Define a Referenced Relationship and Referenced Relationship Properties
    Change a Partition Source

  • See Training Course Details...

Email us about this courses

Other Bath Enable Technology Training Courses

Excel Power Pivot Bath Training Courses
Access - Bath Access Training Courses
Power Query Bath Training Courses
PL/SQL - Bath SQL Training Courses
Excel 365 Basic - Bath Excel Training Courses
SSIS Bath Training Courses