Enable Technology



About Enable Technology Barnsley 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. The course will always be taught by a Microsoft Certified Professional (MCP). Every course participant is given SQL Server Analysis Services courseware which they can refer to after the training. Our policy is to provide open ended SQL Server Analysis Services post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.

We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. We can deliver at your premises. We can provide the equipment. Alternatively we could schedule a SQL Server Analysis Services course at an alternative training site in Barnsley. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite SQL Server Analysis Services course to some extent is bespoke and tailored to your needs.

SQL Server Analysis Services courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: EDF Energy PLC, University of Birmingham, Countrywide Homes Limited, Wolverhampton City Council, Norfolk Police Constabulary, Royal Air Force, Shell UK Oil Products Ltd and Boots UK Limited.

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Barnsley
  • 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 ...
  • Delete a Data Source
    Define Time Intelligence
    Database permissions
    Partition Writeback Calculations
    Multidimensional models
    Processing Databases, Dimensions and Partitions
    Calculations using the Business Intelligence Wizard
    Define a Regular Relationship and Regular Relationship Properties
    Defined Linked Measure Groups Partitions
    Use Aggregate Functions
    Define Semiadditive Behavior
    Work with Diagrams in Data Source View Designer
    Tools and Approaches for Processing
    Define Named Queries in a Data Source View
    Set Impersonation Options for a Data Source Connection
    Modify or Delete in Solution Explorer Database Dimensions
    Ragged Hierarchies
    Attach and Detach Analysis Services Databases
    Error Configuration Roles and Permissions
    Create a Dimension by Generating a Non-Time Table in the Data Source
    Create a Data Source

  • See Training Course Details...

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Barnsley
  • 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 ...
  • Import from Analysis Services
    Manage Roles by using SSMS
    Add a table Delete a Table
    Connect to a tabular model database
    Enable DirectQuery mode in SSMS
    Data sources supported in tabular 1400 models
    Process Tabular Model Partitions
    Delete a Column
    Data sources supported in SSAS  tabular 2016 Create Tabular Models
    Specify Mark as Date Table for use with Time Intelligence
    Data types supported
    Version comparison
    Hide or freeze columns
    DAX formula compatibility in DirectQuery mode Tables and Columns
    Create and Manage KPIs Hierarchies
    Create a Calculated Table
    Analyze in Excel
    Bi-directional cross filters  Calculations
    Create a New Tabular Model Project

  • See Training Course Details...

Email us about this courses

Other Barnsley Enable Technology Training Courses

SSIS Barnsley Training Courses
Oracle SQL Barnsley Training Courses
Power Query Barnsley Training Courses
Excel 365 Advanced - Barnsley Excel Training Courses
VBA Barnsley Training Courses
DAX - Barnsley Excel Training Courses