Enable Technology



About Enable Technology Leyland SQL Server Analysis Services Training Courses

Enable Technology offer short intensive skills based SQL Server Analysis Services training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). All candidates receive comprehensive SQL Server Analysis Services training materials and practice files which are theirs to refer to 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. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Analysis Services onsite. The SQL Server Analysis Services course could also be scheduled at a socially distanced site near you in Leyland. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services training needs.

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.

Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: DHL Express, Dollond & Aitchison Limited, Cadbury PLC, Wolverhampton City Council, Carillion PLC, Barclays Bank PLC, Total Telecommunications Limited and Unipart Group.

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Leyland
  • 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 ...
  • Authorizing access to objects and operations
    Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
    Create Local Partitions
    Test an Action
    Cube or model permissions Process permissions
    Define Named Queries in a Data Source View
    Create an Analysis Services Project
    Set Impersonation Options for a Data Source Connection
    Deployment Requirements and Considerations for Analysis Services Deployment
    Modify or Delete an Analysis Services Database
    BI Wizard
    Define a Regular Relationship and Regular Relationship Properties
    Attach and Detach Analysis Services Databases
    Modify or Delete in Solution Explorer Database Dimensions
    Data Source Views
    Work with Diagrams in Data Source View Designer
    Processing Databases, Dimensions and Partitions
    View the XML for an Analysis Services Project Data Sources
    Supported Data Sources
    Define a Referenced Relationship and Referenced Relationship Properties
    Batch Processing Remote Processing

  • See Training Course Details...

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Leyland
  • 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
    Enable DirectQuery mode in SSDT
    Test a model in DirectQuery mode
    Bi-directional cross filters  Calculations
    Import from Analysis Services
    Add a table Delete a Table
    Enable DirectQuery mode in SSMS
    Deploy from SQL Server Data Tools Manage Tabular Model Databases
    Data sources supported in SSAS tabular 2017
    Create and Manage KPIs Hierarchies
    DAX formula compatibility in DirectQuery mode Tables and Columns
    Data sources supported in tabular 1200 models
    DirectQuery Mode
    Import from Power Pivot
    Create and Manage Tabular Model Partitions
    Create and Manage Roles
    Delete a Column
    Create a Calculated Column
    Create and Manage Partitions in the Workspace

  • See Training Course Details...

Email us about this courses

Other Leyland Enable Technology Training Courses

Excel 365 Intermediate - Leyland Excel Training Courses
SQL Leyland Training Courses
Excel 365 Advanced Leyland Training Courses
Excel 365 Basic Leyland Training Courses
PL/SQL Leyland Training Courses
Power BI Leyland Training Courses