Enable Technology



About Enable Technology Pyle SQL Server Analysis Services Training Courses

We offer intensive two and three days SQL Server Analysis Services courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Each person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials after the training. Anyone attending the course can contact the Tutor for as long as they like after the SQL Server Analysis Services course. The ongoing support by a Microsoft expert is an important part of the service we offer.

Enable Technology training courses are delivered as instructor led courses. Enable Technology can provide SQL Server Analysis Services courses onsite at your location. We will bring the necessary laptops with the required software installed. If you prefer we can offer an offsite socially distanced training location in Pyle. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.

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 Norfolk Police Constabulary, Keele University, Nuclear Engineering Services, West Bromwich Building Society, Boots UK Limited, Shell UK Oil Products Ltd, South Staffordshire Water PLC and Vodafone Group Services.

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Pyle
  • 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 Using an Existing Table
    Batch Processing Remote Processing
    Use Aggregate Functions
    Create Measures and Measure Groups
    Error Configuration Roles and Permissions
    Backup Options Restore Options
    Delete a Data Source View Dimensions
    Document and Script an Analysis Services Database
    Define a Data Source View
    Modify or Delete an Analysis Services Database
    Define a Referenced Relationship and Referenced Relationship Properties
    Backup and Restore of Analysis Services Databases
    Cube or model permissions Process permissions
    Deploy Model Solutions Using XMLA
    Partition Writeback Calculations
    Define Named Calculations in a Data Source View
    View the XML for an Analysis Services Project Data Sources
    Deployment Requirements and Considerations for Analysis Services Deployment
    Edit or Delete Partitions Merge Partitions
    Configure Measure Group Properties
    Define Logical Relationships in a Data Source View

  • See Training Course Details...

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Pyle
  • 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 in Excel
    Import from Analysis Services
    Import data by using a native query
    Create and Manage Hierarchies Partitions
    Data sources supported in SSAS tabular 2017
    Enable DirectQuery mode in SSDT
    Delete a Column
    Enable DirectQuery mode in SSMS
    Row filter mappings
    Bi-directional cross filters  Calculations
    Import Data
    Restore from Power Pivot
    Deploy from SQL Server Data Tools Manage Tabular Model Databases
    Understanding DAX in Tabular Models Measures
    Create a Calculated Column
    Import from Power View
    Create and Manage Perspectives Translations Roles
    Database Process Partitions in the Workspace Database Perspectives
    Import from Power Pivot

  • See Training Course Details...

Email us about this courses

Other Pyle Enable Technology Training Courses

Excel 365 Advanced Pyle Training Courses
Data Warehouse - Pyle SQL Training Courses
Access VBA - Pyle Access Training Courses
DAX Pyle Training Courses
SQL - Pyle SQL Training Courses
Excel 365 Intermediate - Pyle Excel Training Courses