Enable Technology



About Enable Technology Ashton-under-lyne SQL Server Analysis Services Training Courses

We offer intensive two and three days SQL Server Analysis Services courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Every person attending a SQL Server Analysis Services course will be provided with training materials and practice files to retain after the course. 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.

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. Alternatively we could schedule a course at a local socially distanced venue in Ashton-under-lyne. Every SQL Server Analysis Services course can be modified to meet your bespoke requirements.

We also deliver this course online through virtual classrooms. Delegates can join scheduled SQL Server Analysis Services classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.

We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are Birmingham City Council, Nationwide Building Society Limited, Total Telecommunications Limited, Boots UK Limited, Cadbury PLC, Unipart Group, GKN PLC and National Power PLC.

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Ashton-under-lyne
  • 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
    Analyze in Excel
    DAX formula compatibility in DirectQuery mode Tables and Columns
    Filter Data in a Table Relationships
    Row filter mappings
    Add columns to a table
    Import data by using a native query
    Deploy from SQL Server Data Tools Manage Tabular Model Databases
    Hide or freeze columns
    Connect to a tabular model database
    DirectQuery Mode
    Import Data
    Import from Power Pivot
    Create and Manage Hierarchies Partitions
    Specify Mark as Date Table for use with Time Intelligence
    Data sources supported in SSAS  tabular 2016 Create Tabular Models
    Create a Calculated Table
    Data sources supported in tabular 1400 models
    Restore from Power Pivot

  • See Training Course Details...

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Ashton-under-lyne
  • 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 ...
  • Database permissions
    Define Logical Primary Keys in a Data Source View
    Change a Partition Source
    Document and Script an Analysis Services Database
    Define Assignments and Other Script Commands
    Create User-Defined Hierarchies
    Deploy Model Solutions Using XMLA
    Create Measures and Measure Groups
    Configure Measure Group Properties
    Add or Remove Tables or Views in a Data Source View
    Using SQL Server Data Tools (SSDT)
    Test an Action
    Multidimensional models
    Use a Template to Create an Action Deployment
    Define Semiadditive Behavior
    Defined Linked Measure Groups Partitions
    Deploy Analysis Services Projects
    Delete a Data Source View Dimensions
    Work with Diagrams in Data Source View Designer
    Define Logical Relationships in a Data Source View
    Replace a Table or a Named Query in a Data Source View

  • See Training Course Details...

Email us about this courses

Other Ashton-under-lyne Enable Technology Training Courses

Excel Power Pivot - Ashton-under-lyne Excel Training Courses
Excel 365 Advanced Ashton-under-lyne Training Courses
Data Warehouse - Ashton-under-lyne SQL Training Courses
JQuery Mobile Ashton-under-lyne Training Courses
VBA Ashton-under-lyne Training Courses
Access Ashton-under-lyne Training Courses