SQL SERVER ANALYSIS SERVICES TRAINING COURSES PONTYPRIDD
About Enable Technology Pontypridd SQL Server Analysis Services Training Courses
Enable Technology offer short intensive skills based SQL Server Analysis Services training courses. All of our tutors are Microsoft Certified Professionals. 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.
SQL Server Analysis Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Analysis Services onsite. Another way we could deliver the SQL Server Analysis Services course is at a local training site. 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 available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
We have operated primarily in the West Midlands for twenty years. Our clients include: Yell Group PLC, Queen's Medical Centre Nottingham, EDF Energy PLC, Canadian High Commission, Royal & Sun Alliance Group PLC, Capita Group PLC, Cadbury PLC and Unipart Group.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Pontypridd
- 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 ... Test a model in DirectQuery mode
- See Training Course Details...
Create and Manage KPIs Hierarchies
Data sources supported in tabular 1200 models
Create and Manage Perspectives Translations Roles
Row filter mappings
Tabular model designer
Add a table Delete a Table
Hide or freeze columns
Import from Power View
Specify Mark as Date Table for use with Time Intelligence
Import from Analysis Services
DAX formula compatibility in DirectQuery mode Tables and Columns
Data sources supported in SSAS tabular 2016 Create Tabular Models
Enable DirectQuery mode in SSDT
Analyze in Excel
Process Tabular Model Partitions
Create a Relationship Between Two Tables
Delete a Column
Data types supported
Create a Calculated Column
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Pontypridd
- 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 ... Modify or Delete an Analysis Services Database
- See Training Course Details...
Create a Time Dimension by Generating a Time Table
Define Logical Relationships in a Data Source View
Defined Linked Measure Groups Partitions
Set Partition Storage
Processing Options and Settings
Configure Measure Group Properties
Data Source Views
KPIs Actions
Calculations using the Business Intelligence Wizard
Read Definition permissions
Define Named Calculations in a Data Source View
Define a Regular Relationship and Regular Relationship Properties
Create a Dimension by Generating a Non-Time Table in the Data Source
Using SQL Server Data Tools (SSDT)
Deployment Requirements and Considerations for Analysis Services Deployment
Test an Action
Authorizing access to objects and operations
Create Remote Partitions
Document and Script an Analysis Services Database
Use a Template to Create an Action Deployment
Email us about this courses
Other Pontypridd Enable Technology Training Courses
Access VBA - Pontypridd Access Training Courses
Oracle SQL - Pontypridd SQL Training Courses
TSQL Pontypridd Training Courses
Report Builder Pontypridd Training Courses
Excel Power Pivot - Pontypridd Excel Training Courses
Data Warehouse Pontypridd Training Courses