SQL SERVER ANALYSIS SERVICES TRAINING COURSES MIDDLESBROUGH
About Enable Technology Middlesbrough SQL Server Analysis Services Training Courses
Enable Technology provides practical SQL Server Analysis Services skills based technology training. All Enable Technology tutors are Microsoft certified experts. We provide every candidate with SQL Server Analysis Services training materials which they keep 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.
Enable Technology SQL Server Analysis Services courses are instructor led and taught by an experienced Microsoft expert. We can bring the equipment necessary to deliver SQL Server Analysis Services courses at your site. If delivery onsite is an issue we will organise a venue near you in Middlesbrough. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services training needs.
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.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Unipart Group, Aston University, Total Telecommunications Limited, South Staffordshire Water PLC, West Bromwich Building Society, Homeserve PLC, Lloyds TSB Bank PLC and GKN PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Middlesbrough
- 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 ... Configure Analysis Services Project Properties
- See Training Course Details...
Overview of SSAS Multidimensional Modelling
Set Partition Storage
KPIs Actions
Designing Aggregations
Processing Options and Settings
Processing Databases, Dimensions and Partitions
Backup Options Restore Options
Define Time Intelligence
Define Named Calculations in a Data Source View
Create Local Partitions
Read Definition permissions
Defined Linked Measure Groups Partitions
Define Logical Relationships in a Data Source View
Use Aggregate Functions
Define Assignments and Other Script Commands
Set Data Source Properties
Create a Data Source
Deployment Requirements and Considerations for Analysis Services Deployment
Add a Standard Action
Deploy Model Solutions with the Deployment Utility
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Middlesbrough
- 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 ... Enable DirectQuery mode in SSDT
- See Training Course Details...
Filter Data in a Table Relationships
Enable DirectQuery mode in SSMS
Hide or freeze columns
Create a Relationship Between Two Tables
Row filter mappings
Import from Analysis Services
Data types supported
Data sources supported in SSAS tabular 2016 Create Tabular Models
Database Process Partitions in the Workspace Database Perspectives
Tabular model designer
Create and Manage Partitions in the Workspace
Analyze a tabular model in Excel Deploy tabular model solutions
Create a Calculated Table
Sort Data in a Table
Import Data
Data sources supported in tabular 1400 models
Add columns to a table
Import data by using a native query
Add sample data to DirectQuery models
Create and Manage Perspectives Translations Roles
Email us about this courses
Other Middlesbrough Enable Technology Training Courses
Power BI Middlesbrough Training Courses
PL/SQL - Middlesbrough SQL Training Courses
Report Builder - Middlesbrough SQL Server Reporting Services Training Courses
Oracle SQL Middlesbrough Training Courses
JQuery Mobile - Middlesbrough JavaScript Training Courses
Access - Middlesbrough Access Training Courses