Enable Technology



About Enable Technology Leek 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 person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials after the training. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.

Enable Technology SQL Server Analysis Services courses are instructor led and taught by an experienced Microsoft expert. We can bring the equipment necessary to deliver SQL Server Analysis Services courses at your site. Alternatively we could schedule a course at a local socially distanced venue in Leek. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.

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.

We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: Aston University, Shell UK Oil Products Ltd, Countrywide Homes Limited, Halfords Group PLC, Capita Group PLC, Total Telecommunications Limited, Norwich Union PLC and South Staffordshire Water PLC.

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Leek
  • 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 ...
  • Create a Dimension by Generating a Non-Time Table in the Data Source
    Create Named Sets
    Add or Remove Tables or Views in a Data Source View
    Define a Fact Relationship and Fact Relationship Properties
    Authorizing access to objects and operations
    Create User-Defined Hierarchies
    Set Impersonation Options for a Data Source Connection
    Use a Template to Create an Action Deployment
    Tools and Approaches for Processing
    Test an Action
    Rename a Multidimensional Database Processing a multidimensional model
    Define Time Intelligence
    BI Wizard
    Configure Measure Group Properties
    Data Source Views
    Processing Options and Settings
    Batch Processing Remote Processing
    Create a Dimension by Using an Existing Table
    Use Aggregate Functions
    Set Data Source Properties
    Modify or Delete an Analysis Services Database

  • See Training Course Details...

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Leek
  • 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 ...
  • Analyze a tabular model in Excel Deploy tabular model solutions
    Filter Data in a Table Relationships
    Import data by using a native query
    Set the Data Type of a Column
    Create a Calculated Column
    Row filter mappings
    Deploy from SQL Server Data Tools Manage Tabular Model Databases
    Add columns to a table
    Database Process Partitions in the Workspace Database Perspectives
    Version comparison
    DAX formula compatibility in DirectQuery mode Tables and Columns
    Data types supported
    Import from Analysis Services
    Object-level security
    Restore from Power Pivot
    Data sources supported in tabular 1400 models
    Hide or freeze columns
    Data sources supported in SSAS  tabular 2016 Create Tabular Models
    Create and Manage Measures KPIs
    Understanding DAX in Tabular Models Measures

  • See Training Course Details...

Email us about this courses

Other Leek Enable Technology Training Courses

Excel Power Pivot - Leek Excel Training Courses
Access Leek Training Courses
Access VBA - Leek Access Training Courses
Excel 365 Intermediate Leek Training Courses
Power BI Leek Training Courses
DAX Leek Training Courses