Enable Technology



About Enable Technology Bromsgrove SQL Server Analysis Services Training Courses

We are company which specialises in short, two and three day intensive SQL Server Analysis Services technology training courses. The tutor delivering the course will be a Microsoft certified expert. We will issue each SQL Server Analysis Services training participant with learning resources which they can refer to post training. Enable Technology offer post course help to all delegates. Participants on the SQL Server Analysis Services course can contact the tutor for as long as they like if they encounter SQL Server Analysis Services problems.

Enable Technology offers instructor led training taught by technology specialists. Enable Technology SQL Server Analysis Services courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Another way we could deliver the SQL Server Analysis Services course is at a local socially distanced training site. 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 over twenty years continuous technical training experience. Our clients include: Dollond & Aitchison Limited, Canadian High Commission, Nationwide Building Society Limited, West Bromwich Building Society, Royal Air Force, Birmingham Heartlands Hospital, Boots UK Limited and Barclays Bank PLC.

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Bromsgrove
  • 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 ...
  • Configure Analysis Services Project Properties
    Move an Analysis Services Database
    Dimension permissions
    Set Partition Storage
    Change a Partition Source
    Modify or Delete an Analysis Services Database
    Create Remote Partitions
    Data Source Views
    Create Calculated Members
    Create an Analysis Services Project
    View the XML for an Analysis Services Project Data Sources
    KPIs Actions
    Attach and Detach Analysis Services Databases
    Partition Writeback Calculations
    Error Configuration Roles and Permissions
    Ragged Hierarchies
    Rename a Multidimensional Database Processing a multidimensional model
    Read Definition permissions
    Delete a Data Source
    Multidimensional models
    Edit or Delete Partitions Merge Partitions

  • See Training Course Details...

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Bromsgrove
  • 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 Power Pivot
    Understanding DAX in Tabular Models Measures
    Hide or freeze columns
    Data sources supported in tabular 1200 models
    Database Process Partitions in the Workspace Database Perspectives
    Row filter mappings
    Connect to a tabular model database
    Analyze in Excel
    Change table, column
    Enable DirectQuery mode in SSDT
    Create a New Tabular Model Project
    Data sources supported in SSAS  tabular 2016 Create Tabular Models
    Bi-directional cross filters  Calculations
    Create and Manage KPIs Hierarchies
    Data types supported
    Tabular model designer
    Delete a Column
    Specify Mark as Date Table for use with Time Intelligence

  • See Training Course Details...

Email us about this courses

Other Bromsgrove Enable Technology Training Courses

JQuery Mobile Bromsgrove Training Courses
SQL - Bromsgrove SQL Training Courses
Power Query - Bromsgrove Excel Training Courses
Power BI - Bromsgrove Microsoft Power BI Training Courses
DAX Bromsgrove Training Courses
SSRS Bromsgrove Training Courses