Enable Technology

SQL SERVER ANALYSIS SERVICES ROCHDALE TRAINING COURSES 

SQL SERVER ANALYSIS SERVICES TRAINING COURSES ROCHDALE




About Enable Technology Rochdale SQL Server Analysis Services Training Courses

Enable Technology provides practical SQL Server Analysis Services skills based technology training. The training will be delivered by a Microsoft professional with development experience. We will issue each SQL Server Analysis Services training participant with learning resources which they can refer to post 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.

Our primary method of delivery is instructor led training coupled with practical hands on activities. Enable Technology SQL Server Analysis Services training courses can be delivered at your offices. We can supply the necessary software and computers. We also offer the option of scheduling of SQL Server Analysis Services course at a socially distanced venue near you in Rochdale. The SQL Server Analysis Services syllabus can be modified to accommodate your specific training needs.

This course can also be delivered in a virtual classroom. Delegates can log into a scheduled SQL Server Analysis Services course, watch the tutor demonstrate tasks, ask questions and share their own screen.

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Lloyds TSB Bank PLC, Shell UK Oil Products Ltd, Total Telecommunications Limited, Capita Group PLC, Canadian High Commission, West Bromwich Building Society, Norfolk Police Constabulary and Royal & Sun Alliance Group PLC.




Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Rochdale
  • 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 ...
  • Hide or freeze columns
    Impersonation
    Create a Calculated Table
    Tabular model designer
    Add sample data to DirectQuery models
    Analyze in Excel
    Data sources supported in tabular 1400 models
    Import data by using a native query
    Import from Power View
    Restore from Power Pivot
    Delete Relationships
    Version comparison
    Change table, column
    Bi-directional cross filters  Calculations
    Create a Calculated Column
    Manage Roles by using SSMS
    Data types supported
    Rename a Table or Column
    Add a table Delete a Table
    Create and Manage Partitions in the Workspace

  • See Training Course Details...


Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Rochdale
  • 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 ...
  • Deploy Model Solutions Using the Deployment Wizard
    Processing Databases, Dimensions and Partitions
    Add a Standard Action
    Deployment Requirements and Considerations for Analysis Services Deployment
    Define Named Queries in a Data Source View
    Deploy Model Solutions Using XMLA
    Set Partition Storage
    Read Definition permissions
    Using SQL Server Data Tools (SSDT)
    Modify or Delete an Analysis Services Database
    Add or Remove Tables or Views in a Data Source View
    Create an Analysis Services Project
    Define Attribute Relationships
    Change a Partition Source
    Define Assignments and Other Script Commands
    Define a Regular Relationship and Regular Relationship Properties
    Test an Action
    Move an Analysis Services Database
    Dimension permissions
    BI Wizard
    Define a Referenced Relationship and Referenced Relationship Properties

  • See Training Course Details...



Email us about this courses



Other Rochdale Enable Technology Training Courses

Access VBA - Rochdale Access Training Courses
JavaScript Rochdale Training Courses
Access Rochdale Training Courses
JQuery - Rochdale JavaScript Training Courses
Oracle SQL Rochdale Training Courses
SSIS Rochdale Training Courses