Enable Technology

SQL SERVER ANALYSIS SERVICES SALISBURY TRAINING COURSES 

SQL SERVER ANALYSIS SERVICES TRAINING COURSES SALISBURY




About Enable Technology Salisbury SQL Server Analysis Services Training Courses

Enable Technology SQL Server Analysis Services courses are short, skill focused and hands on. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. We provide every candidate with SQL Server Analysis Services training materials which they keep after the course. We also provide an ongoing support service to people attending our SQL Server Analysis Services courses. Delegates can contact the course tutor with specific SQL Server Analysis Services questions for as long as they need following the course.

We provide instructor led training coupled with hands on training. 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. The SQL Server Analysis Services course could also be scheduled at a socially distanced site near you in Salisbury. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services 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 over twenty years continuous technical training experience. Our clients include: Canadian High Commission, Wolverhampton City Council, Royal Air Force, Queen's Medical Centre Nottingham, GKN PLC, TalkTalk Direct Limited, Countrywide Homes Limited and National Power PLC.




Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Salisbury
  • 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 ...
  • Database Process Partitions in the Workspace Database Perspectives
    Rename a Table or Column
    Specify Mark as Date Table for use with Time Intelligence
    Row filter mappings
    Delete Relationships
    Enable DirectQuery mode in SSDT
    Create a New Tabular Model Project
    Process Tabular Model Partitions
    Create a Relationship Between Two Tables
    Deploy from SQL Server Data Tools Manage Tabular Model Databases
    DAX formula compatibility in DirectQuery mode Tables and Columns
    Set the Data Type of a Column
    Restore from Power Pivot
    Create and Manage Tabular Model Partitions
    Import Data
    Tabular model designer
    Impersonation
    Import data by using a native query
    Filter Data in a Table Relationships
    Create and Manage Partitions in the Workspace

  • See Training Course Details...


Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Salisbury
  • 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
    View the XML for an Analysis Services Project Data Sources
    BI Wizard
    Create a Dimension by Generating a Non-Time Table in the Data Source
    Move an Analysis Services Database
    Deploy Model Solutions with the Deployment Utility
    Add a Standard Action
    Delete a Data Source View Dimensions
    Create a Dimension Using the Dimension Wizard
    Create a Dimension by Using an Existing Table
    Explore Data in a Data Source View
    Delete a Data Source
    Create Measures and Measure Groups
    Overview of SSAS Multidimensional Modelling
    Define Attribute Relationships
    Designing Aggregations
    Rename a Multidimensional Database Processing a multidimensional model
    Create an Analysis Services Project
    Change a Partition Source
    Supported Data Sources
    Configure Analysis Services Project Properties

  • See Training Course Details...



Email us about this courses



Other Salisbury Enable Technology Training Courses

Access VBA - Salisbury Access Training Courses
Excel Power Pivot Salisbury Training Courses
SSIS - Salisbury SQL Server Integration Services Training Courses
SSRS - Salisbury SQL Server Reporting Services Training Courses
SQL Salisbury Training Courses
JQuery Mobile - Salisbury JavaScript Training Courses