Enable Technology

SQL SERVER ANALYSIS SERVICES BURY TRAINING COURSES 

SQL SERVER ANALYSIS SERVICES TRAINING COURSES BURY




About Enable Technology Bury SQL Server Analysis Services Training Courses

We offer intensive two and three days SQL Server Analysis Services courses. The tutor delivering the course will be a Microsoft certified expert. We provide every candidate with SQL Server Analysis Services training materials which they keep 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.

We provide instructor led training coupled with hands on training. Enable Technology can supply all of the equipment necessary to deliver SQL Server Analysis Services courses onsite at your offices. You simply need to provide a suitable room. Another option is we can organise a local training site in Bury. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services training needs.

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.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: National Power PLC, Countrywide Homes Limited, Vodafone Group Services, Yell Group PLC, Birmingham City Council, Barclays Bank PLC, Canadian High Commission and Nuclear Engineering Services.




Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Bury
  • 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 ...
  • Process Tabular Model Partitions
    Create and Manage Hierarchies Partitions
    Create a New Tabular Model Project
    DAX formula compatibility in DirectQuery mode Tables and Columns
    Enable DirectQuery mode in SSDT
    Data sources supported in tabular 1200 models
    Row filter mappings
    Data sources supported in SSAS  tabular 2016 Create Tabular Models
    Analyze in Excel
    Change table, column
    Object-level security
    Impersonation
    Create and Manage KPIs Hierarchies
    Add sample data to DirectQuery models
    Delete a Column
    Filter Data in a Table Relationships
    Sort Data in a Table
    Data sources supported in tabular 1400 models

  • See Training Course Details...


Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Bury
  • 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 ...
  • Attach and Detach Analysis Services Databases
    Use a Template to Create an Action Deployment
    Use Aggregate Functions
    Create an Analysis Services Project
    Modify or Delete an Analysis Services Database
    Supported Data Sources
    Create a Dimension by Generating a Non-Time Table in the Data Source
    Data Source Views
    Define Logical Relationships in a Data Source View
    Processing Databases, Dimensions and Partitions
    Error Configuration Roles and Permissions
    Defined Linked Measure Groups Partitions
    Create Measures and Measure Groups
    Define Logical Primary Keys in a Data Source View
    Using SQL Server Data Tools (SSDT)
    Create a Dimension Using the Dimension Wizard
    Calculations using the Business Intelligence Wizard
    KPIs Actions
    Move an Analysis Services Database
    Create a Data Source
    Create Local Partitions

  • See Training Course Details...



Email us about this courses



Other Bury Enable Technology Training Courses

SSIS - Bury SQL Server Integration Services Training Courses
Excel Power Pivot - Bury Excel Training Courses
Data Warehouse - Bury SQL Training Courses
JQuery - Bury JavaScript Training Courses
Power Query Bury Training Courses
SSRS Bury Training Courses