SQL SERVER ANALYSIS SERVICES TRAINING COURSES TONYPANDY
About Enable Technology Tonypandy SQL Server Analysis Services Training Courses
Enable Technology specialise in succinct skills based SQL Server Analysis Services training. The tutor delivering the course will be a Microsoft certified expert. All course participants are issued SQL Server Analysis Services training manuals they can refer to after the course. Course participants are welcome contact the Tutor after the course with specific SQL Server Analysis Services queries. This support is open ended.
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 course at a local venue in Tonypandy. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite SQL Server Analysis Services course to some extent is bespoke and tailored to your needs.
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: DHL Express, Barclays Bank PLC, Birmingham City University, TalkTalk Direct Limited, Aston University, Total Telecommunications Limited, Unipart Group and University of Birmingham.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Tonypandy
- 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 Hierarchies Partitions
- See Training Course Details...
Import data by using a native query
Import Data
Analyze a tabular model in Excel Deploy tabular model solutions
Create a Calculated Column
Manage Roles by using SSMS
Impersonation
Enable DirectQuery mode in SSDT
Create a Calculated Table
Create a New Tabular Model Project
Sort Data in a Table
Delete Relationships
Database Process Partitions in the Workspace Database Perspectives
Hide or freeze columns
Understanding DAX in Tabular Models Measures
Create and Manage Partitions in the Workspace
Create and Manage Roles
Delete a Column
Tabular model designer
Create and Manage KPIs Hierarchies
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Tonypandy
- 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 ... Define Assignments and Other Script Commands
- See Training Course Details...
Authorizing access to objects and operations
Multidimensional models
Using SQL Server Data Tools (SSDT)
Define a Fact Relationship and Fact Relationship Properties
Overview of SSAS Multidimensional Modelling
Deploy Analysis Services Projects
Define Named Calculations in a Data Source View
Define Logical Relationships in a Data Source View
Dimension permissions
Document and Script an Analysis Services Database
Define a Referenced Relationship and Referenced Relationship Properties
Define a Data Source View
Edit or Delete Partitions Merge Partitions
Deploy Model Solutions Using XMLA
Create an Analysis Services Project
Supported Data Sources
Designing Aggregations
Calculations using the Business Intelligence Wizard
Add or Remove Tables or Views in a Data Source View
Add a Standard Action
Email us about this courses
Other Tonypandy Enable Technology Training Courses
Excel 365 Basic Tonypandy Training Courses
Oracle SQL - Tonypandy SQL Training Courses
VBA - Tonypandy Excel Training Courses
TSQL Tonypandy Training Courses
Power Query - Tonypandy Excel Training Courses
PL/SQL - Tonypandy SQL Training Courses