Enable Technology

SQL SERVER ANALYSIS SERVICES LLANELLI TRAINING COURSES 

SQL SERVER ANALYSIS SERVICES TRAINING COURSES LLANELLI




About Enable Technology Llanelli SQL Server Analysis Services Training Courses

Enable Technology provides practical SQL Server Analysis Services skills based technology training. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Every course participant is given SQL Server Analysis Services courseware which they can refer to after the training. We offer a post training support service and delegates will have access to a Microsoft expert on SQL Server Analysis Services for as long as they need.

Courses are instructor led and groups sizes small. Enable Technology can provide SQL Server Analysis Services courses onsite at your location. We will bring the necessary laptops with the required software installed. The SQL Server Analysis Services course could also be scheduled at a socially distanced site near you in Llanelli. The SQL Server Analysis Services syllabus can be modified to accommodate your specific training needs.

This instructor led SQL Server Analysis Services training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Capita Group PLC, Queen's Medical Centre Nottingham, National Power PLC, West Bromwich Building Society, Wolverhampton City Council, Royal Air Force, Vodafone Group Services and Nuclear Engineering Services.




Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Llanelli
  • 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 ...
  • Ragged Hierarchies
    Create a Data Source
    Supported Data Sources
    Define a Referenced Relationship and Referenced Relationship Properties
    Change a Partition Source
    Define Logical Relationships in a Data Source View
    Attach and Detach Analysis Services Databases
    Database permissions
    Create Calculated Members
    Create a Time Dimension by Generating a Time Table
    Create an Analysis Services Project
    Deployment Requirements and Considerations for Analysis Services Deployment
    Set Impersonation Options for a Data Source Connection
    Dimension permissions
    Set Data Source Properties
    Calculations using the Business Intelligence Wizard
    Configure Measure Group Properties
    Backup Options Restore Options
    Create a Dimension by Generating a Non-Time Table in the Data Source
    Delete a Data Source
    Rename a Multidimensional Database Processing a multidimensional model

  • See Training Course Details...


Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Llanelli
  • 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 ...
  • Version comparison
    Create and Manage Hierarchies Partitions
    Database Process Partitions in the Workspace Database Perspectives
    Object-level security
    Data sources supported in SSAS tabular 2017
    Set the Data Type of a Column
    Row filter mappings
    Change table, column
    Manage Roles by using SSMS
    Analyze in Excel
    Data sources supported in tabular 1200 models
    Create and Manage Partitions in the Workspace
    Create and Manage Roles
    Tabular model designer
    Delete Relationships
    Create and Manage Measures KPIs
    Data sources supported in tabular 1400 models
    Add columns to a table
    Filter Data in a Table Relationships
    Create a New Tabular Model Project

  • See Training Course Details...



Email us about this courses



Other Llanelli Enable Technology Training Courses

SSIS Llanelli Training Courses
Report Builder Llanelli Training Courses
Excel 365 Basic Llanelli Training Courses
SSRS - Llanelli SQL Server Reporting Services Training Courses
JQuery Llanelli Training Courses
VBA - Llanelli Excel Training Courses