Enable Technology



About Enable Technology Castleford SQL Server Analysis Services Training Courses

We offer intensive two and three days SQL Server Analysis Services courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source after the course. We offer a post training support service and delegates will have access to a Microsoft expert on SQL Server Analysis Services for as long as they need.

Enable Technology SQL Server Analysis Services courses are instructor led and taught by an experienced Microsoft expert. 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 Castleford. We will work with you prior to the course to tailor the SQL Server Analysis Services syllabus to match your requirements.

SQL Server Analysis Services courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.

The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Queen's Medical Centre Nottingham, Total Telecommunications Limited, Canadian High Commission, Aston University, TalkTalk Direct Limited, Keele University, Birmingham City University and South Staffordshire Water PLC.

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Castleford
  • 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 ...
  • Designing Aggregations
    Create User-Defined Hierarchies
    Backup Options Restore Options
    Processing Databases, Dimensions and Partitions
    Modify or Delete in Solution Explorer Database Dimensions
    Cube or model permissions Process permissions
    Define Named Calculations in a Data Source View
    Define Assignments and Other Script Commands
    BI Wizard
    Overview of SSAS Multidimensional Modelling
    Define Semiadditive Behavior
    Define a Data Source View
    Set Impersonation Options for a Data Source Connection
    Set Partition Storage
    Database permissions
    Set Data Source Properties
    Configure Measure Group Properties
    Define Named Queries in a Data Source View
    Move an Analysis Services Database
    Using SQL Server Data Tools (SSDT)
    KPIs Actions

  • See Training Course Details...

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Castleford
  • 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 ...
  • Deploy from SQL Server Data Tools Manage Tabular Model Databases
    Data sources supported in tabular 1200 models
    Set the Data Type of a Column
    Filter Data in a Table Relationships
    Add sample data to DirectQuery models
    Tabular model designer
    Create and Manage Roles
    Analyze a tabular model in Excel Deploy tabular model solutions
    DirectQuery Mode
    Create and Manage Tabular Model Partitions
    Create and Manage Partitions in the Workspace
    Data types supported
    Topics include- Overview of SSAS Tabular models
    Connect to a tabular model database
    Specify Mark as Date Table for use with Time Intelligence
    Create a Relationship Between Two Tables
    Import from Power Pivot

  • See Training Course Details...

Email us about this courses

Other Castleford Enable Technology Training Courses

TSQL Castleford Training Courses
Report Builder Castleford Training Courses
JQuery Mobile - Castleford JavaScript Training Courses
Power Query - Castleford Excel Training Courses
Excel 365 Advanced - Castleford Excel Training Courses
Power BI Castleford Training Courses