SQL SERVER ANALYSIS SERVICES TRAINING COURSES PRESTON
About Enable Technology Preston SQL Server Analysis Services Training Courses
Enable Technology specialise in succinct skills based SQL Server Analysis Services training. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. We provide every candidate with SQL Server Analysis Services training materials which they keep 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.
Enable Technology SQL Server Analysis Services courses are instructor led and taught by an experienced Microsoft expert. Enable Technology SQL Server Analysis Services training courses can be delivered at your offices. We can supply the necessary software and computers. Alternatively we could schedule a course at a local venue in Preston. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services training requirements.
SQL Server Analysis Services courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Nuclear Engineering Services, Aston University, Wolverhampton City Council, Fujistu PLC, Capita Group PLC, Birmingham Heartlands Hospital, Birmingham City Council and Royal Air Force.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Preston
- 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 ... Add a Standard Action
- See Training Course Details...
Use Aggregate Functions
Create an Analysis Services Project
Deploy Model Solutions Using XMLA
View the XML for an Analysis Services Project Data Sources
Create Measures and Measure Groups
Move an Analysis Services Database
KPIs Actions
Add or Remove Tables or Views in a Data Source View
Create Named Sets
Modify or Delete an Analysis Services Database
Create Remote Partitions
Create User-Defined Hierarchies
Delete a Data Source
Error Configuration Roles and Permissions
Ragged Hierarchies
Explore Data in a Data Source View
Create a Dimension by Generating a Non-Time Table in the Data Source
Define a Referenced Relationship and Referenced Relationship Properties
Create a Dimension by Using an Existing Table
Deployment Requirements and Considerations for Analysis Services Deployment
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Preston
- 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 ... Restore from Power Pivot
- See Training Course Details...
Import from Power Pivot
Create a New Tabular Model Project
Version comparison
Change table, column
Analyze in Excel
Create and Manage Measures KPIs
Data sources supported in tabular 1200 models
Create and Manage Roles
Delete a Column
Database Process Partitions in the Workspace Database Perspectives
Object-level security
Test a model in DirectQuery mode
Add columns to a table
Process Tabular Model Partitions
Create and Manage KPIs Hierarchies
Topics include- Overview of SSAS Tabular models
Create a Calculated Column
Import from Power View
Hide or freeze columns
Email us about this courses
Other Preston Enable Technology Training Courses
Excel Power Pivot Preston Training Courses
SQL Preston Training Courses
SSRS - Preston SQL Server Reporting Services Training Courses
Excel 365 Advanced Preston Training Courses
JavaScript - Preston JavaScript Training Courses
Power BI - Preston Microsoft Power BI Training Courses