SQL SERVER ANALYSIS SERVICES TRAINING COURSES MERTHYR TYDFIL
About Enable Technology Merthyr Tydfil SQL Server Analysis Services Training Courses
We are a company that provides short intensive SQL Server Analysis Services training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Every person attending a SQL Server Analysis Services course will be provided with training materials and practice files to retain after the course. We offer a post training support service and delegates will have access to a Microsoft expert on SQL Server Analysis Services for as long as they need.
Courses are instructor led and groups sizes small. We can bring the equipment necessary to deliver SQL Server Analysis Services courses at your site. If delivery onsite is an issue we will organise a venue near you in Merthyr Tydfil. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.
We can also deliver SQL Server Analysis Services courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
We have operated primarily in the West Midlands for twenty years. Some of our clients are Nationwide Building Society Limited, TalkTalk Direct Limited, DHL Express, Yell Group PLC, Countrywide Homes Limited, Wolverhampton City Council, Aston University and West Bromwich Building Society.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Merthyr Tydfil
- 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 ... Set Data Source Properties
- See Training Course Details...
Configure Measure Group Properties
Work with Diagrams in Data Source View Designer
Dimension permissions
Defined Linked Measure Groups Partitions
Backup and Restore of Analysis Services Databases
Delete a Data Source View Dimensions
Tools and Approaches for Processing
Define a Referenced Relationship and Referenced Relationship Properties
Define Time Intelligence
Rename a Multidimensional Database Processing a multidimensional model
Database permissions
Add or Remove Tables or Views in a Data Source View
Change a Partition Source
Data Source Views
Deploy Model Solutions Using XMLA
Create a Time Dimension by Generating a Time Table
Processing Databases, Dimensions and Partitions
Designing Aggregations
Attach and Detach Analysis Services Databases
Define Named Calculations in a Data Source View
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Merthyr Tydfil
- 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 ... Connect to a tabular model database
- See Training Course Details...
Create and Manage KPIs Hierarchies
Sort Data in a Table
Filter Data in a Table Relationships
Object-level security
Import data by using a native query
Analyze in Excel
Add columns to a table
Import from Power Pivot
Row filter mappings
Delete a Column
Import from Power View
Create and Manage Perspectives Translations Roles
DAX formula compatibility in DirectQuery mode Tables and Columns
Add a table Delete a Table
Create and Manage Measures KPIs
Manage Roles by using SSMS
Create a Calculated Table
Database Process Partitions in the Workspace Database Perspectives
Process Tabular Model Partitions
Email us about this courses
Other Merthyr Tydfil Enable Technology Training Courses
JQuery Merthyr Tydfil Training Courses
TSQL - Merthyr Tydfil SQL Training Courses
SQL - Merthyr Tydfil SQL Training Courses
SSIS Merthyr Tydfil Training Courses
Power BI Merthyr Tydfil Training Courses
JQuery Mobile Merthyr Tydfil Training Courses