Enable Technology

SQL SERVER ANALYSIS SERVICES MERSEYSIDE TRAINING COURSES 

SQL SERVER ANALYSIS SERVICES TRAINING COURSES MERSEYSIDE




About Enable Technology Merseyside SQL Server Analysis Services Training Courses

Enable Technology offer short intensive skills based SQL Server Analysis Services training courses. All of our tutors are Microsoft Certified Professionals. Every course participant will receives course practice files and SQL Server Analysis Services course resources that can be referenced post training. 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.

Enable Technology offers instructor led training taught by technology specialists. Enable Technology can provide SQL Server Analysis Services courses onsite at your location. We will bring the necessary laptops with the required software installed. If you prefer we can offer an offsite training location in Merseyside. All SQL Server Analysis Services courses can be customised to meet your particular requirements.

SQL Server Analysis Services courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen

The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Royal & Sun Alliance Group PLC, Unipart Group, Countrywide Homes Limited, Nationwide Building Society Limited, Halfords Group PLC, EDF Energy PLC, Birmingham Heartlands Hospital and West Bromwich Building Society.




Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Merseyside
  • 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 ...
  • Multidimensional models
    Explore Data in a Data Source View
    Create User-Defined Hierarchies
    Data Source object permissions
    Set Partition Storage
    Create a Dimension by Using an Existing Table
    Processing Databases, Dimensions and Partitions
    Configure Analysis Services Project Properties
    Designing Aggregations
    Modify or Delete an Analysis Services Database
    Create Measures and Measure Groups
    Ragged Hierarchies
    Replace a Table or a Named Query in a Data Source View
    Create Named Sets
    Overview of SSAS Multidimensional Modelling
    Configure Measure Group Properties
    BI Wizard
    Tools and Approaches for Processing
    Define Assignments and Other Script Commands
    Use a Template to Create an Action Deployment
    Database permissions

  • See Training Course Details...


Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Merseyside
  • 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 ...
  • Bi-directional cross filters  Calculations
    Create and Manage Roles
    Specify Mark as Date Table for use with Time Intelligence
    Object-level security
    Process Database, Table, or Partition
    Topics include- Overview of SSAS Tabular models
    Data types supported
    Create and Manage Measures KPIs
    DirectQuery Mode
    Create a Relationship Between Two Tables
    Create a Calculated Column
    Test a model in DirectQuery mode
    Create and Manage KPIs Hierarchies
    Manage Roles by using SSMS
    Hide or freeze columns
    Data sources supported in SSAS  tabular 2016 Create Tabular Models
    Create and Manage Hierarchies Partitions
    Import from Power View
    Add columns to a table
    Delete Relationships

  • See Training Course Details...



Email us about this courses



Other Merseyside Enable Technology Training Courses

Access - Merseyside Access Training Courses
JavaScript Merseyside Training Courses
Report Builder Merseyside Training Courses
DAX - Merseyside Excel Training Courses
JQuery Mobile - Merseyside JavaScript Training Courses
SSRS Merseyside Training Courses