Enable Technology

SQL SERVER ANALYSIS SERVICES SOLIHULL TRAINING COURSES 

SQL SERVER ANALYSIS SERVICES TRAINING COURSES SOLIHULL




About Enable Technology Solihull SQL Server Analysis Services Training Courses

We offer intensive two and three days SQL Server Analysis Services courses. 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 offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Analysis Services queries.

Enable Technology SQL Server Analysis Services courses are instructor led and taught by an experienced Microsoft expert. Enable Technology SQL Server Analysis Services training courses can be delivered at your offices. We can supply the necessary software and computers. Another option is we can organise a local socially distanced training site in Solihull. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services training needs.

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.

We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are Vodafone Group Services, Unipart Group, Norfolk Police Constabulary, Countrywide Homes Limited, Homeserve PLC, Shell UK Oil Products Ltd, Cadbury PLC and Boots UK Limited.




Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Solihull
  • 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 ...
  • Add sample data to DirectQuery models
    Test a model in DirectQuery mode
    Analyze a tabular model in Excel Deploy tabular model solutions
    Restore from Power Pivot
    Delete a Column
    Specify Mark as Date Table for use with Time Intelligence
    Version comparison
    Row filter mappings
    Analyze in Excel
    Data sources supported in SSAS  tabular 2016 Create Tabular Models
    Data sources supported in tabular 1400 models
    Data sources supported in SSAS tabular 2017
    Process Tabular Model Partitions
    Object-level security
    Data sources supported in tabular 1200 models
    Database Process Partitions in the Workspace Database Perspectives
    Create a New Tabular Model Project
    Filter Data in a Table Relationships
    Set the Data Type of a Column
    Manage Roles by using SSMS

  • See Training Course Details...


Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Solihull
  • 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 ...
  • Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
    Modify or Delete in Solution Explorer Database Dimensions
    Designing Aggregations
    Create a Time Dimension by Generating a Time Table
    Dimension permissions
    Backup Options Restore Options
    Tools and Approaches for Processing
    Supported Data Sources
    Move an Analysis Services Database
    Document and Script an Analysis Services Database
    Define Assignments and Other Script Commands
    Batch Processing Remote Processing
    Define a Data Source View
    Multidimensional models
    Create a Dimension Using the Dimension Wizard
    Error Configuration Roles and Permissions
    Authorizing access to objects and operations
    Explore Data in a Data Source View
    Define Attribute Relationships
    Cube or model permissions Process permissions
    Data Source object permissions

  • See Training Course Details...



Email us about this courses



Other Solihull Enable Technology Training Courses

JQuery - Solihull JavaScript Training Courses
Access - Solihull Access Training Courses
JQuery Mobile Solihull Training Courses
Data Warehouse Solihull Training Courses
Excel Power Pivot - Solihull Excel Training Courses
Power BI - Solihull Microsoft Power BI Training Courses