Enable Technology

SQL SERVER ANALYSIS SERVICES PRESTON TRAINING COURSES 

SQL SERVER ANALYSIS SERVICES TRAINING COURSES PRESTON




About Enable Technology Preston SQL Server Analysis Services Training Courses

We are a company that provides short intensive SQL Server Analysis Services training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. We provide every candidate with SQL Server Analysis Services training materials which they keep after the course. We also provide an ongoing support service to people attending our SQL Server Analysis Services courses. Delegates can contact the course tutor with specific SQL Server Analysis Services questions for as long as they need following the course.

SQL Server Analysis Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. 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. We are also more than happy to organise a local course at a socially distanced training location in Preston. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services 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: Loughborough University, Norwich Union PLC, Capita Group PLC, Royal Air Force, Yell Group PLC, Boots UK Limited, Nationwide Building Society Limited and Birmingham Heartlands Hospital.




Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Preston
  • 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
    Overview of SSAS Multidimensional Modelling
    Set Partition Storage
    Processing Databases, Dimensions and Partitions
    Define Assignments and Other Script Commands
    Set Data Source Properties
    Cube or model permissions Process permissions
    Defined Linked Measure Groups Partitions
    Create Remote Partitions
    Define a Referenced Relationship and Referenced Relationship Properties
    Define a Regular Relationship and Regular Relationship Properties
    Define Named Queries in a Data Source View
    Create User-Defined Hierarchies
    Set Impersonation Options for a Data Source Connection
    Test an Action
    Partition Writeback Calculations
    Move an Analysis Services Database
    Create a Dimension Using the Dimension Wizard
    Define Logical Primary Keys in a Data Source View
    Deployment Requirements and Considerations for Analysis Services Deployment
    Work with Diagrams in Data Source View Designer

  • See Training Course Details...


Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Preston
  • 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 ...
  • Import from Power Pivot
    Analyze in Excel
    Create a New Tabular Model Project
    Connect to a tabular model database
    Database Process Partitions in the Workspace Database Perspectives
    Import from Power View
    Create and Manage Perspectives Translations Roles
    DAX formula compatibility in DirectQuery mode Tables and Columns
    Deploy from SQL Server Data Tools Manage Tabular Model Databases
    Object-level security
    Version comparison
    Test a model in DirectQuery mode
    Define partitions in DirectQuery models
    Create and Manage Roles
    Analyze a tabular model in Excel Deploy tabular model solutions
    Rename a Table or Column
    Import data by using a native query
    Create a Calculated Column
    Row filter mappings
    Data sources supported in tabular 1200 models

  • See Training Course Details...



Email us about this courses



Other Preston Enable Technology Training Courses

SQL - Preston SQL Training Courses
PL/SQL - Preston SQL Training Courses
Access - Preston Access Training Courses
Report Builder - Preston SQL Server Reporting Services Training Courses
JQuery Mobile Preston Training Courses
SSRS - Preston SQL Server Reporting Services Training Courses