Enable Technology

SQL SERVER ANALYSIS SERVICES BRIDGNORTH TRAINING COURSES 

SQL SERVER ANALYSIS SERVICES TRAINING COURSES BRIDGNORTH




About Enable Technology Bridgnorth SQL Server Analysis Services Training Courses

Enable Technology SQL Server Analysis Services courses are short, skill focused and hands on. The tutor delivering the course will be a Microsoft certified expert. Every course participant is given SQL Server Analysis Services courseware which they can refer to after the training. 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.

SQL Server Analysis Services courses are taught by a Microsoft Certified Solutions Expert. We can deliver at your premises. We can provide the equipment. We are also more than happy to organise a local course at a training location in Bridgnorth. 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.

The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Homeserve PLC, Dollond & Aitchison Limited, Keele University, Norfolk Police Constabulary, South Staffordshire Water PLC, Lloyds TSB Bank PLC, West Bromwich Building Society and Boots UK Limited.




Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Bridgnorth
  • 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 ...
  • Add or Remove Tables or Views in a Data Source View
    Set Data Source Properties
    Create an Analysis Services Project
    Define Time Intelligence
    Use a Template to Create an Action Deployment
    KPIs Actions
    Create a Dimension by Using an Existing Table
    Batch Processing Remote Processing
    Create Named Sets
    Add a Standard Action
    Define Attribute Relationships
    Backup Options Restore Options
    Define Named Calculations in a Data Source View
    Set Impersonation Options for a Data Source Connection
    Replace a Table or a Named Query in a Data Source View
    Define Logical Primary Keys in a Data Source View
    Tools and Approaches for Processing
    Create Measures and Measure Groups
    Create a Time Dimension by Generating a Time Table
    Move an Analysis Services Database
    Create User-Defined Hierarchies

  • See Training Course Details...


Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Bridgnorth
  • 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 ...
  • Process Tabular Model Partitions
    Tabular model designer
    Database Process Partitions in the Workspace Database Perspectives
    Data sources supported in SSAS  tabular 2016 Create Tabular Models
    DAX formula compatibility in DirectQuery mode Tables and Columns
    Enable DirectQuery mode in SSDT
    Impersonation
    Restore from Power Pivot
    DirectQuery Mode
    Import data by using a native query
    Add columns to a table
    Create a Calculated Column
    Add a table Delete a Table
    Create a New Tabular Model Project
    Import from Analysis Services
    Test a model in DirectQuery mode
    Create and Manage Roles
    Analyze a tabular model in Excel Deploy tabular model solutions
    Add sample data to DirectQuery models
    Specify Mark as Date Table for use with Time Intelligence
    Filter Data in a Table Relationships

  • See Training Course Details...



Email us about this courses



Other Bridgnorth Enable Technology Training Courses

Excel 365 Advanced - Bridgnorth Excel Training Courses
SQL Bridgnorth Training Courses
JQuery Mobile - Bridgnorth JavaScript Training Courses
Power Query - Bridgnorth Excel Training Courses
Excel 365 Basic Bridgnorth Training Courses
Oracle SQL Bridgnorth Training Courses