Enable Technology



About Enable Technology Black Country SQL Server Analysis Services Training Courses

We are a company that provides short intensive SQL Server Analysis Services training courses. The course will always be taught by a Microsoft Certified Professional (MCP). Each course participant will be issued with training SQL Server Analysis Services resources which they can continue to use after the training. If delegates have have questions about SQL Server Analysis Services after the course they are welcome to contact the course Tutor. This post training support is ongoing.

SQL Server Analysis Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We can bring the equipment necessary to deliver SQL Server Analysis Services courses at your site. We are also more than happy to organise a local course at a socially distanced training location in Black Country. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services training needs.

We also deliver this course online. Delegates participate in a virtual SQL Server Analysis Services class and can both talk to and share their screen with the tutor.

The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Aston University, Wolverhampton City Council, Homeserve PLC, South Staffordshire Water PLC, Shell UK Oil Products Ltd, Cadbury PLC, Nationwide Building Society Limited and GKN PLC.

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Black Country
  • 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 ...
  • Define Logical Primary Keys in a Data Source View
    Use Aggregate Functions
    Create a Time Dimension by Generating a Time Table
    Deploy Model Solutions Using the Deployment Wizard
    Define Assignments and Other Script Commands
    Configure Analysis Services Project Properties
    Supported Data Sources
    Overview of SSAS Multidimensional Modelling
    Authorizing access to objects and operations
    Create User-Defined Hierarchies
    Tools and Approaches for Processing
    Define Time Intelligence
    Set Partition Storage
    Data Source Views
    Move an Analysis Services Database
    Add or Remove Tables or Views in a Data Source View
    Deploy Model Solutions Using XMLA
    BI Wizard
    Define a Regular Relationship and Regular Relationship Properties
    Create a Dimension by Using an Existing Table
    Processing Databases, Dimensions and Partitions

  • See Training Course Details...

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Black Country
  • 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 ...
  • Understanding DAX in Tabular Models Measures
    Test a model in DirectQuery mode
    Analyze in Excel
    Add columns to a table
    Add sample data to DirectQuery models
    Object-level security
    Data sources supported in tabular 1400 models
    Connect to a tabular model database
    DAX formula compatibility in DirectQuery mode Tables and Columns
    Enable DirectQuery mode in SSDT
    Import from Power View
    Create and Manage KPIs Hierarchies
    Data sources supported in SSAS  tabular 2016 Create Tabular Models
    Rename a Table or Column
    Topics include- Overview of SSAS Tabular models
    Delete a Column
    Define partitions in DirectQuery models
    Create and Manage Roles
    Row filter mappings
    Sort Data in a Table
    Create a Calculated Table

  • See Training Course Details...

Email us about this courses

Other Black Country Enable Technology Training Courses

Data Warehouse Black Country Training Courses
SQL Black Country Training Courses
Report Builder - Black Country SQL Server Reporting Services Training Courses
VBA Black Country Training Courses
JavaScript - Black Country JavaScript Training Courses
Excel 365 Advanced Black Country Training Courses