Enable Technology

SQL SERVER ANALYSIS SERVICES HEREFORD TRAINING COURSES 

SQL SERVER ANALYSIS SERVICES TRAINING COURSES HEREFORD




About Enable Technology Hereford SQL Server Analysis Services Training Courses

Enable Technology has twenty year track record of providing short intensive SQL Server Analysis Services skills based training courses. All Enable Technology tutors are Microsoft certified experts. Every course participant will receives course practice files and SQL Server Analysis Services course resources that can be referenced post training. Course participants are welcome contact the Tutor after the course with specific SQL Server Analysis Services queries. This support is open ended.

Enable Technology training courses are delivered as instructor led courses. Our SQL Server Analysis Services training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Another option is we can organise a local socially distanced training site in Hereford. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services training needs.

SQL Server Analysis Services courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.

We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Norfolk Police Constabulary, Dollond & Aitchison Limited, Yell Group PLC, EDF Energy PLC, Norwich Union PLC, Nationwide Building Society Limited, Royal & Sun Alliance Group PLC and Aston University.




Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Hereford
  • 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 ...
  • Database Process Partitions in the Workspace Database Perspectives
    Sort Data in a Table
    Create and Manage Perspectives Translations Roles
    Enable DirectQuery mode in SSMS
    Create a Calculated Table
    Data sources supported in tabular 1400 models
    Add a table Delete a Table
    Process Tabular Model Partitions
    Topics include- Overview of SSAS Tabular models
    Test a model in DirectQuery mode
    DirectQuery Mode
    Impersonation
    Data sources supported in tabular 1200 models
    Row filter mappings
    Add columns to a table
    Set the Data Type of a Column
    Import Data
    Create and Manage Tabular Model Partitions
    Process Database, Table, or Partition
    Filter Data in a Table Relationships

  • See Training Course Details...


Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Hereford
  • 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 Analysis Services Projects
    Explore Data in a Data Source View
    Define Logical Primary Keys in a Data Source View
    Define a Data Source View
    Delete a Data Source
    Backup and Restore of Analysis Services Databases
    Partition Writeback Calculations
    Create a Time Dimension by Generating a Time Table
    Create Calculated Members
    Define Assignments and Other Script Commands
    Attach and Detach Analysis Services Databases
    Define Logical Relationships in a Data Source View
    Dimension permissions
    Modify or Delete in Solution Explorer Database Dimensions
    Designing Aggregations
    Deploy Model Solutions Using XMLA
    Batch Processing Remote Processing
    Tools and Approaches for Processing
    Set Impersonation Options for a Data Source Connection
    Create Local Partitions
    Define Semiadditive Behavior

  • See Training Course Details...



Email us about this courses



Other Hereford Enable Technology Training Courses

SSIS Hereford Training Courses
Access - Hereford Access Training Courses
Excel 365 Advanced Hereford Training Courses
Excel 365 Basic - Hereford Excel Training Courses
Power BI - Hereford Microsoft Power BI Training Courses
VBA Hereford Training Courses