Enable Technology

SQL SERVER ANALYSIS SERVICES STOKE ON TRENT TRAINING COURSES 

SQL SERVER ANALYSIS SERVICES TRAINING COURSES STOKE ON TRENT




About Enable Technology Stoke On Trent SQL Server Analysis Services Training Courses

We are company which specialises in short, two and three day intensive SQL Server Analysis Services technology training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source after the course. 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.

SQL Server Analysis Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Our SQL Server Analysis Services training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. If you prefer we can offer an offsite training location in Stoke On Trent. We offer the option of working with you to develop a bespoke SQL Server Analysis Services programme which precisely matches your organisations training requirements.

Taught SQL Server Analysis Services courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.

Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Unipart Group, Lloyds TSB Bank PLC, Countrywide Homes Limited, DHL Express, Wolverhampton City Council, Nuclear Engineering Services, GKN PLC and Boots UK Limited.




Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Stoke On Trent
  • 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 ...
  • Create a New Tabular Model Project
    Import from Analysis Services
    Data sources supported in SSAS  tabular 2016 Create Tabular Models
    Create and Manage Tabular Model Partitions
    Data types supported
    Create a Relationship Between Two Tables
    Deploy from SQL Server Data Tools Manage Tabular Model Databases
    Restore from Power Pivot
    Sort Data in a Table
    Import data by using a native query
    DirectQuery Mode
    Impersonation
    Create and Manage Measures KPIs
    Define partitions in DirectQuery models
    Process Database, Table, or Partition
    Tabular model designer
    Set the Data Type of a Column
    Data sources supported in SSAS tabular 2017
    Row filter mappings
    Process Tabular Model Partitions

  • See Training Course Details...


Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Stoke On Trent
  • 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 ...
  • Move an Analysis Services Database
    Add a Standard Action
    Create a Dimension by Generating a Non-Time Table in the Data Source
    Read Definition permissions
    Configure Measure Group Properties
    Define a Data Source View
    Supported Data Sources
    Modify or Delete in Solution Explorer Database Dimensions
    Data Source object permissions
    BI Wizard
    View the XML for an Analysis Services Project Data Sources
    Cube or model permissions Process permissions
    Define a Referenced Relationship and Referenced Relationship Properties
    Document and Script an Analysis Services Database
    Set Partition Storage
    Deploy Model Solutions Using the Deployment Wizard
    Define a Regular Relationship and Regular Relationship Properties
    Attach and Detach Analysis Services Databases
    Work with Diagrams in Data Source View Designer
    Use a Template to Create an Action Deployment
    Define Logical Primary Keys in a Data Source View

  • See Training Course Details...



Email us about this courses



Other Stoke On Trent Enable Technology Training Courses

Excel Power Pivot - Stoke On Trent Excel Training Courses
JQuery - Stoke On Trent JavaScript Training Courses
Access - Stoke On Trent Access Training Courses
Power BI - Stoke On Trent Microsoft Power BI Training Courses
TSQL Stoke On Trent Training Courses
JavaScript Stoke On Trent Training Courses