Enable Technology



About Enable Technology Bridgnorth 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. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Every course participant is given SQL Server Analysis Services courseware which they can refer to after the training. 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.

We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology SQL Server Analysis Services training courses can be delivered at your offices. We can supply the necessary software and computers. We also offer the option of scheduling of SQL Server Analysis Services course at a socially distanced venue near you in Bridgnorth. We offer the option of working with you to develop a bespoke SQL Server Analysis Services programme which precisely matches your organisations training requirements.

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: TalkTalk Direct Limited, Countrywide Homes Limited, Fujistu PLC, Total Telecommunications Limited, Loughborough University, Royal & Sun Alliance Group PLC, Aston University and Royal Air Force.

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Bridgnorth
  • 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 ...
  • Partition Writeback Calculations
    Overview of SSAS Multidimensional Modelling
    Delete a Data Source View Dimensions
    Deploy Model Solutions Using the Deployment Wizard
    Define Named Queries in a Data Source View
    Rename a Multidimensional Database Processing a multidimensional model
    Set Data Source Properties
    Use Aggregate Functions
    Ragged Hierarchies
    Create User-Defined Hierarchies
    Document and Script an Analysis Services Database
    Calculations using the Business Intelligence Wizard
    Define Logical Relationships in a Data Source View
    Using SQL Server Data Tools (SSDT)
    Cube or model permissions Process permissions
    Create a Dimension Using the Dimension Wizard
    Define Time Intelligence
    Designing Aggregations
    Modify or Delete in Solution Explorer Database Dimensions
    Error Configuration Roles and Permissions
    Deploy Model Solutions with the Deployment Utility

  • See Training Course Details...

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Bridgnorth
  • 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 ...
  • Define partitions in DirectQuery models
    Sort Data in a Table
    Create a New Tabular Model Project
    Add sample data to DirectQuery models
    Test a model in DirectQuery mode
    Import from Power Pivot
    Data types supported
    Hide or freeze columns
    Rename a Table or Column
    Object-level security
    Database Process Partitions in the Workspace Database Perspectives
    Filter Data in a Table Relationships
    Change table, column
    Add columns to a table
    Analyze a tabular model in Excel Deploy tabular model solutions
    Deploy from SQL Server Data Tools Manage Tabular Model Databases
    Topics include- Overview of SSAS Tabular models
    Enable DirectQuery mode in SSMS
    Process Tabular Model Partitions

  • See Training Course Details...

Email us about this courses

Other Bridgnorth Enable Technology Training Courses

Access Bridgnorth Training Courses
VBA - Bridgnorth Excel Training Courses
JavaScript - Bridgnorth JavaScript Training Courses
Power BI - Bridgnorth Microsoft Power BI Training Courses
SSRS - Bridgnorth SQL Server Reporting Services Training Courses
Excel 365 Basic Bridgnorth Training Courses