SQL SERVER ANALYSIS SERVICES TRAINING COURSES EAST MIDLANDS
About Enable Technology East Midlands SQL Server Analysis Services Training Courses
Enable Technology SQL Server Analysis Services courses are short, skill focused and hands on. All of our tutors are Microsoft Certified Professionals. Every course participant will receives course practice files and SQL Server Analysis Services course resources that can be referenced post training. Enable Technology offer post course help to all delegates. Participants on the SQL Server Analysis Services course can contact the tutor for as long as they like if they encounter SQL Server Analysis Services problems.
Delegates are taught by an experienced Microsoft professional. SQL Server Analysis Services courses are delivered through a mix of practical hands on exercises and walk throughs. Enable Technology SQL Server Analysis Services training courses can be delivered at your offices. We can supply the necessary software and computers. If you prefer we can offer an offsite socially distanced training location in East Midlands. We are happy to modify the SQL Server Analysis Services syllabus to match your teams 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 over twenty years continuous technical training experience. Our clients include: Aston University, Barclays Bank PLC, Birmingham City University, West Bromwich Building Society, Loughborough University, Boots UK Limited, National Power PLC and Halfords Group PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: East Midlands
- 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 ... Supported Data Sources
- See Training Course Details...
Deployment Requirements and Considerations for Analysis Services Deployment
Backup Options Restore Options
KPIs Actions
Create Remote Partitions
Define Logical Relationships in a Data Source View
Use Aggregate Functions
Deploy Model Solutions Using XMLA
Rename a Multidimensional Database Processing a multidimensional model
Multidimensional models
Configure Measure Group Properties
Create a Dimension Using the Dimension Wizard
Modify or Delete in Solution Explorer Database Dimensions
Move an Analysis Services Database
Test an Action
Create Named Sets
Define Logical Primary Keys in a Data Source View
Delete a Data Source
Edit or Delete Partitions Merge Partitions
Backup and Restore of Analysis Services Databases
Define Attribute Relationships
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: East Midlands
- 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 ... Create and Manage Partitions in the Workspace
- See Training Course Details...
Restore from Power Pivot
Create a Relationship Between Two Tables
Define partitions in DirectQuery models
Create and Manage Roles
Process Tabular Model Partitions
Create and Manage Perspectives Translations Roles
Sort Data in a Table
Create a New Tabular Model Project
Delete a Column
Create and Manage KPIs Hierarchies
Understanding DAX in Tabular Models Measures
Enable DirectQuery mode in SSDT
Database Process Partitions in the Workspace Database Perspectives
Create and Manage Tabular Model Partitions
Create a Calculated Column
Import from Power View
Import data by using a native query
Version comparison
Add a table Delete a Table
Email us about this courses
Other East Midlands Enable Technology Training Courses
Report Builder - East Midlands SQL Server Reporting Services Training Courses
Excel Power Pivot - East Midlands Excel Training Courses
Excel 365 Basic East Midlands Training Courses
JQuery Mobile East Midlands Training Courses
VBA - East Midlands Excel Training Courses
SSRS - East Midlands SQL Server Reporting Services Training Courses