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

We have a twenty year history of providing skills based SQL Server Analysis Services industry training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Every person attending a SQL Server Analysis Services course will be provided with training materials and practice files to retain 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 specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Analysis Services onsite. We can also deliver the SQL Server Analysis Services course at a socially distanced local training venue in Salisbury. We will work with you prior to the course to tailor the SQL Server Analysis Services syllabus to match your requirements.

This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.

We have operated primarily in the West Midlands for twenty years. Some of our clients are Vodafone Group Services, TalkTalk Direct Limited, Lloyds TSB Bank PLC, West Bromwich Building Society, Yell Group PLC, Royal Air Force, Loughborough University and University of Birmingham.




Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Salisbury
  • 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 ...
  • Edit or Delete Partitions Merge Partitions
    Backup and Restore of Analysis Services Databases
    View the XML for an Analysis Services Project Data Sources
    Define a Regular Relationship and Regular Relationship Properties
    Cube or model permissions Process permissions
    Set Partition Storage
    Create Measures and Measure Groups
    Tools and Approaches for Processing
    Delete a Data Source View Dimensions
    BI Wizard
    Designing Aggregations
    Create an Analysis Services Project
    Data Source Views
    Rename a Multidimensional Database Processing a multidimensional model
    Use Aggregate Functions
    Define Time Intelligence
    Define Attribute Relationships
    Create a Data Source
    Define a Referenced Relationship and Referenced Relationship Properties
    Define a Fact Relationship and Fact Relationship Properties
    Create Calculated Members

  • See Training Course Details...


Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Salisbury
  • 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 ...
  • Import data by using a native query
    Data sources supported in SSAS tabular 2017
    Database Process Partitions in the Workspace Database Perspectives
    Object-level security
    Rename a Table or Column
    Process Tabular Model Partitions
    Create and Manage Hierarchies Partitions
    Tabular model designer
    Create and Manage Tabular Model Partitions
    Create and Manage KPIs Hierarchies
    Add columns to a table
    Data sources supported in tabular 1400 models
    Connect to a tabular model database
    Set the Data Type of a Column
    Add sample data to DirectQuery models
    Topics include- Overview of SSAS Tabular models
    Version comparison
    Bi-directional cross filters  Calculations
    Create a New Tabular Model Project
    Process Database, Table, or Partition

  • See Training Course Details...



Email us about this courses



Other Salisbury Enable Technology Training Courses

JQuery Mobile - Salisbury JavaScript Training Courses
TSQL - Salisbury SQL Training Courses
Excel 365 Basic - Salisbury Excel Training Courses
Oracle SQL - Salisbury SQL Training Courses
Power BI Salisbury Training Courses
Report Builder Salisbury Training Courses