SQL SERVER ANALYSIS SERVICES TRAINING COURSES DEWSBURY
About Enable Technology Dewsbury SQL Server Analysis Services Training Courses
We are a company that provides short intensive SQL Server Analysis Services training courses. The tutor delivering the course will be a Microsoft certified expert. Each course participant will be issued with training SQL Server Analysis Services resources which they can continue to use 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. We can bring the equipment necessary to deliver SQL Server Analysis Services courses at your site. Another way we could deliver the SQL Server Analysis Services course is at a local training site. We are happy to modify the SQL Server Analysis Services syllabus to match your teams training 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.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are GKN PLC, Norfolk Police Constabulary, University of Birmingham, DHL Express, Cadbury PLC, Boots UK Limited, Wolverhampton City Council and Birmingham City Council.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Dewsbury
- 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 ... Data sources supported in tabular 1400 models
- See Training Course Details...
Define partitions in DirectQuery models
Create and Manage Partitions in the Workspace
Add columns to a table
Create and Manage Tabular Model Partitions
Change table, column
Test a model in DirectQuery mode
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Create and Manage Roles
Create and Manage Measures KPIs
Specify Mark as Date Table for use with Time Intelligence
Filter Data in a Table Relationships
Import data by using a native query
Rename a Table or Column
Delete a Column
Version comparison
Process Tabular Model Partitions
Process Database, Table, or Partition
Create a Relationship Between Two Tables
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Dewsbury
- 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 Remote Partitions
- See Training Course Details...
Processing Options and Settings
KPIs Actions
Test an Action
Error Configuration Roles and Permissions
Dimension permissions
Create a Dimension Using the Dimension Wizard
Supported Data Sources
Multidimensional models
Define Logical Relationships in a Data Source View
Add or Remove Tables or Views in a Data Source View
Create Calculated Members
Ragged Hierarchies
Cube or model permissions Process permissions
Using SQL Server Data Tools (SSDT)
Modify or Delete in Solution Explorer Database Dimensions
Create Measures and Measure Groups
Define Named Calculations in a Data Source View
View the XML for an Analysis Services Project Data Sources
Backup and Restore of Analysis Services Databases
Authorizing access to objects and operations
Email us about this courses
Other Dewsbury Enable Technology Training Courses
Excel 365 Intermediate Dewsbury Training Courses
Power BI Dewsbury Training Courses
JavaScript Dewsbury Training Courses
JQuery Mobile - Dewsbury JavaScript Training Courses
VBA Dewsbury Training Courses
PL/SQL Dewsbury Training Courses