Enable Technology

SQL SERVER ANALYSIS SERVICES TAMWORTH TRAINING COURSES 

SQL SERVER ANALYSIS SERVICES TRAINING COURSES TAMWORTH




About Enable Technology Tamworth SQL Server Analysis Services Training Courses

We are a company that provides short intensive SQL Server Analysis Services training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Analysis Services queries.

Courses are instructor led and groups sizes small. We can set up a training lab at your premises and deliver SQL Server Analysis Services courses onsite at your site. Alternatively we could schedule a course at a local socially distanced venue in Tamworth. We offer the option of working with you to develop a bespoke SQL Server Analysis Services programme which precisely matches your organisations training 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.

Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Yell Group PLC, Wolverhampton City Council, Shell UK Oil Products Ltd, Loughborough University, Total Telecommunications Limited, Dollond & Aitchison Limited, Birmingham City University and Homeserve PLC.




Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Tamworth
  • 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 ...
  • Define Logical Primary Keys in a Data Source View
    Configure Measure Group Properties
    Deploy Analysis Services Projects
    Using SQL Server Data Tools (SSDT)
    Authorizing access to objects and operations
    Delete a Data Source View Dimensions
    Create Calculated Members
    Ragged Hierarchies
    Define a Referenced Relationship and Referenced Relationship Properties
    Create User-Defined Hierarchies
    Define Named Calculations in a Data Source View
    Replace a Table or a Named Query in a Data Source View
    Define a Regular Relationship and Regular Relationship Properties
    Attach and Detach Analysis Services Databases
    Database permissions
    Error Configuration Roles and Permissions
    KPIs Actions
    Calculations using the Business Intelligence Wizard
    Multidimensional models
    Deployment Requirements and Considerations for Analysis Services Deployment
    Dimension permissions

  • See Training Course Details...


Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Tamworth
  • 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 ...
  • Restore from Power Pivot
    Create and Manage Tabular Model Partitions
    Create and Manage Hierarchies Partitions
    Change table, column
    Test a model in DirectQuery mode
    Analyze a tabular model in Excel Deploy tabular model solutions
    Create and Manage KPIs Hierarchies
    Define partitions in DirectQuery models
    Add a table Delete a Table
    Create and Manage Measures KPIs
    Set the Data Type of a Column
    Tabular model designer
    Hide or freeze columns
    Version comparison
    Create a Relationship Between Two Tables
    Rename a Table or Column
    Sort Data in a Table
    DirectQuery Mode
    Database Process Partitions in the Workspace Database Perspectives
    Create a New Tabular Model Project
    Impersonation

  • See Training Course Details...



Email us about this courses



Other Tamworth Enable Technology Training Courses

Report Builder - Tamworth SQL Server Reporting Services Training Courses
SSRS Tamworth Training Courses
Oracle SQL Tamworth Training Courses
Power BI - Tamworth Microsoft Power BI Training Courses
Excel 365 Basic - Tamworth Excel Training Courses
Excel 365 Intermediate Tamworth Training Courses