Enable Technology

SQL SERVER ANALYSIS SERVICES WILTSHIRE TRAINING COURSES 

SQL SERVER ANALYSIS SERVICES TRAINING COURSES WILTSHIRE




About Enable Technology Wiltshire SQL Server Analysis Services Training Courses

We are a company that provides short intensive SQL Server Analysis Services training courses. The tutor delivering the course will be a Microsoft certified expert. Every person attending a SQL Server Analysis Services course will be provided with training materials and practice files to retain after the course. Our policy is to provide open ended SQL Server Analysis Services post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.

Enable Technology SQL Server Analysis Services courses are instructor led and taught by an experienced Microsoft expert. We can deliver at your premises. We can provide the equipment. If you prefer we can offer an offsite training location in Wiltshire. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services training requirements.

Taught SQL Server Analysis Services courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.

The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Keele University, Homeserve PLC, Capita Group PLC, Yell Group PLC, Total Telecommunications Limited, Nationwide Building Society Limited, Royal Air Force and Carillion PLC.




Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Wiltshire
  • 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 ...
  • Partition Writeback Calculations
    Configure Analysis Services Project Properties
    Define a Data Source View
    Replace a Table or a Named Query in a Data Source View
    Test an Action
    Supported Data Sources
    View the XML for an Analysis Services Project Data Sources
    Add a Standard Action
    Database permissions
    Error Configuration Roles and Permissions
    Batch Processing Remote Processing
    Create a Dimension by Using an Existing Table
    Define Attribute Relationships
    Create Remote Partitions
    Create Calculated Members
    Define Logical Relationships in a Data Source View
    Create a Data Source
    Change a Partition Source
    Add or Remove Tables or Views in a Data Source View
    Define a Fact Relationship and Fact Relationship Properties
    Configure Measure Group Properties

  • See Training Course Details...


Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Wiltshire
  • 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 ...
  • Tabular model designer
    Manage Roles by using SSMS
    Database Process Partitions in the Workspace Database Perspectives
    Hide or freeze columns
    Restore from Power Pivot
    Sort Data in a Table
    Import from Analysis Services
    Impersonation
    Set the Data Type of a Column
    Import data by using a native query
    Create a New Tabular Model Project
    Create and Manage Measures KPIs
    DirectQuery Mode
    Enable DirectQuery mode in SSDT
    Import from Power Pivot
    Row filter mappings
    Process Database, Table, or Partition
    Add a table Delete a Table
    Delete Relationships
    Data sources supported in SSAS  tabular 2016 Create Tabular Models

  • See Training Course Details...



Email us about this courses



Other Wiltshire Enable Technology Training Courses

Power Query - Wiltshire Excel Training Courses
Excel 365 Intermediate Wiltshire Training Courses
SSIS Wiltshire Training Courses
VBA Wiltshire Training Courses
SQL Wiltshire Training Courses
Report Builder - Wiltshire SQL Server Reporting Services Training Courses