Enable Technology

SQL SERVER ANALYSIS SERVICES RHOSLLANERCHRUGOG TRAINING COURSES 

SQL SERVER ANALYSIS SERVICES TRAINING COURSES RHOSLLANERCHRUGOG




About Enable Technology Rhosllanerchrugog SQL Server Analysis Services Training Courses

Enable Technology has twenty year track record of providing short intensive SQL Server Analysis Services skills based training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. We provide every candidate with SQL Server Analysis Services training materials which they keep after the course. Enable Technology offer post course help to all delegates. Participants on the SQL Server Analysis Services course can contact the tutor for as long as they like if they encounter SQL Server Analysis Services problems.

Courses are instructor led and groups sizes small. We can set up a training lab at your premises and deliver SQL Server Analysis Services courses onsite at your site. Another option is we can organise a local socially distanced training site in Rhosllanerchrugog. 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.

Our teaching team have over twenty years continuous technical training experience. Some of our clients are Lloyds TSB Bank PLC, South Staffordshire Water PLC, Wolverhampton City Council, Barclays Bank PLC, Vodafone Group Services, Shell UK Oil Products Ltd, Homeserve PLC and Norwich Union PLC.




Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Rhosllanerchrugog
  • 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 ...
  • Define Logical Primary Keys in a Data Source View
    KPIs Actions
    Define a Fact Relationship and Fact Relationship Properties
    Rename a Multidimensional Database Processing a multidimensional model
    Processing Databases, Dimensions and Partitions
    Configure Measure Group Properties
    Read Definition permissions
    Dimension permissions
    Modify or Delete an Analysis Services Database
    Create a Dimension by Using an Existing Table
    Define Semiadditive Behavior
    Deploy Model Solutions with the Deployment Utility
    Create Measures and Measure Groups
    Use a Template to Create an Action Deployment
    Ragged Hierarchies
    Document and Script an Analysis Services Database
    Use Aggregate Functions
    Error Configuration Roles and Permissions
    Define Attribute Relationships
    Using SQL Server Data Tools (SSDT)
    View the XML for an Analysis Services Project Data Sources

  • See Training Course Details...


Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Rhosllanerchrugog
  • 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 ...
  • Manage Roles by using SSMS
    Database Process Partitions in the Workspace Database Perspectives
    Add columns to a table
    Bi-directional cross filters  Calculations
    Data sources supported in tabular 1400 models
    Version comparison
    Set the Data Type of a Column
    Rename a Table or Column
    Create and Manage Perspectives Translations Roles
    DirectQuery Mode
    Row filter mappings
    Analyze in Excel
    Import from Power Pivot
    Create a Relationship Between Two Tables
    Add sample data to DirectQuery models
    Add a table Delete a Table
    Hide or freeze columns
    Topics include- Overview of SSAS Tabular models
    Test a model in DirectQuery mode
    Impersonation

  • See Training Course Details...



Email us about this courses



Other Rhosllanerchrugog Enable Technology Training Courses

Excel Power Pivot Rhosllanerchrugog Training Courses
Excel 365 Advanced - Rhosllanerchrugog Excel Training Courses
Report Builder Rhosllanerchrugog Training Courses
Oracle SQL - Rhosllanerchrugog SQL Training Courses
VBA Rhosllanerchrugog Training Courses
Excel 365 Intermediate - Rhosllanerchrugog Excel Training Courses