Enable Technology

SQL SERVER ANALYSIS SERVICES MANCHESTER TRAINING COURSES 

SQL SERVER ANALYSIS SERVICES TRAINING COURSES MANCHESTER




About Enable Technology Manchester SQL Server Analysis Services Training Courses

Enable Technology has twenty year track record of providing short intensive SQL Server Analysis Services skills based training courses. We guarantee the training will be delivered by a Microsoft certified expert. Every course participant is given SQL Server Analysis Services courseware which they can refer to after the training. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.

Enable Technology training courses are delivered as instructor led courses. Enable Technology SQL Server Analysis Services courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Alternatively we could schedule a course at a local venue in Manchester. We will work with you prior to the course to tailor the SQL Server Analysis Services syllabus to match your requirements.

This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to 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. Some of our clients are Canadian High Commission, Birmingham City Council, Unipart Group, Royal Air Force, GKN PLC, EDF Energy PLC, DHL Express and Cadbury PLC.




Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Manchester
  • 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 ...
  • Create Calculated Members
    KPIs Actions
    Define a Regular Relationship and Regular Relationship Properties
    Create a Time Dimension by Generating a Time Table
    Explore Data in a Data Source View
    Define Named Queries in a Data Source View
    Set Data Source Properties
    Edit or Delete Partitions Merge Partitions
    Define Attribute Relationships
    Set Partition Storage
    Designing Aggregations
    Dimension permissions
    Define Named Calculations in a Data Source View
    Create Named Sets
    Deploy Model Solutions with the Deployment Utility
    Rename a Multidimensional Database Processing a multidimensional model
    Create User-Defined Hierarchies
    Cube or model permissions Process permissions
    Authorizing access to objects and operations
    Data Source object permissions
    Tools and Approaches for Processing

  • See Training Course Details...


Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Manchester
  • 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 ...
  • Object-level security
    Import from Analysis Services
    Specify Mark as Date Table for use with Time Intelligence
    Hide or freeze columns
    Bi-directional cross filters  Calculations
    Define partitions in DirectQuery models
    DirectQuery Mode
    Change table, column
    Topics include- Overview of SSAS Tabular models
    Create a New Tabular Model Project
    Import Data
    Create a Relationship Between Two Tables
    Process Tabular Model Partitions
    DAX formula compatibility in DirectQuery mode Tables and Columns
    Enable DirectQuery mode in SSMS
    Data sources supported in SSAS tabular 2017
    Delete a Column
    Enable DirectQuery mode in SSDT
    Import from Power Pivot
    Create a Calculated Table

  • See Training Course Details...



Email us about this courses



Other Manchester Enable Technology Training Courses

VBA Manchester Training Courses
SSIS Manchester Training Courses
DAX - Manchester Excel Training Courses
TSQL Manchester Training Courses
Access - Manchester Access Training Courses
Power Query - Manchester Excel Training Courses