SQL SERVER ANALYSIS SERVICES TRAINING COURSES DORCHESTER
About Enable Technology Dorchester SQL Server Analysis Services Training Courses
Enable Technology specialise in succinct skills based SQL Server Analysis Services training. All Enable Technology tutors are Microsoft certified experts. Each person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials after the training. If delegates have have questions about SQL Server Analysis Services after the course they are welcome to contact the course Tutor. This post training support is ongoing.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology can provide SQL Server Analysis Services courses onsite at your location. We will bring the necessary laptops with the required software installed. Alternatively we could schedule a SQL Server Analysis Services course at an alternative training site in Dorchester. We are happy to modify the SQL Server Analysis Services syllabus to match your teams training requirements.
We also deliver this course online through virtual classrooms. Delegates can join scheduled SQL Server Analysis Services classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Carillion PLC, Birmingham City Council, Capita Group PLC, Cadbury PLC, Shell UK Oil Products Ltd, Unipart Group, Halfords Group PLC and Homeserve PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Dorchester
- 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 ... Delete a Column
- See Training Course Details...
Analyze a tabular model in Excel Deploy tabular model solutions
Data sources supported in SSAS tabular 2017
Hide or freeze columns
Database Process Partitions in the Workspace Database Perspectives
Create and Manage KPIs Hierarchies
Add sample data to DirectQuery models
Create and Manage Hierarchies Partitions
Import from Power Pivot
Create a Calculated Table
Add a table Delete a Table
Process Database, Table, or Partition
Create and Manage Perspectives Translations Roles
Row filter mappings
Create a Calculated Column
Data types supported
Manage Roles by using SSMS
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Specify Mark as Date Table for use with Time Intelligence
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Dorchester
- 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 ... Partition Writeback Calculations
- See Training Course Details...
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Create Named Sets
Define Semiadditive Behavior
Document and Script an Analysis Services Database
Tools and Approaches for Processing
Data Source object permissions
Define Time Intelligence
Using SQL Server Data Tools (SSDT)
Deploy Model Solutions Using XMLA
Multidimensional models
Calculations using the Business Intelligence Wizard
Test an Action
Cube or model permissions Process permissions
Attach and Detach Analysis Services Databases
Set Partition Storage
Deploy Model Solutions with the Deployment Utility
Create Local Partitions
Define a Fact Relationship and Fact Relationship Properties
Replace a Table or a Named Query in a Data Source View
Edit or Delete Partitions Merge Partitions
Email us about this courses
Other Dorchester Enable Technology Training Courses
Power Query Dorchester Training Courses
SQL - Dorchester SQL Training Courses
PL/SQL - Dorchester SQL Training Courses
Excel 365 Basic Dorchester Training Courses
Power BI Dorchester Training Courses
Excel Power Pivot - Dorchester Excel Training Courses