SQL SERVER ANALYSIS SERVICES TRAINING COURSES GLOUCESTER
About Enable Technology Gloucester SQL Server Analysis Services Training Courses
We offer intensive two and three days SQL Server Analysis Services courses. The training will be delivered by a Microsoft professional with development experience. We provide every candidate with SQL Server Analysis Services training materials which they keep after the course. It is our company policy to provide SQL Server Analysis Services training participants with ongoing support from the course Tutor. People who attend a SQL Server Analysis Services course can contact the Tutor for as long as they need assistance after the training.
Enable Technology training courses are delivered as instructor led courses. We can bring the equipment necessary to deliver SQL Server Analysis Services courses at your site. If you prefer we can offer an offsite training location in Gloucester. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.
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
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Fujistu PLC, Barclays Bank PLC, Total Telecommunications Limited, Keele University, Nationwide Building Society Limited, TalkTalk Direct Limited, National Power PLC and GKN PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Gloucester
- 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 Perspectives Translations Roles
- See Training Course Details...
Object-level security
Bi-directional cross filters Calculations
Create and Manage Roles
Delete Relationships
Analyze a tabular model in Excel Deploy tabular model solutions
Row filter mappings
Create and Manage Hierarchies Partitions
Enable DirectQuery mode in SSDT
Data sources supported in SSAS tabular 2017
Filter Data in a Table Relationships
Analyze in Excel
Data sources supported in SSAS tabular 2016 Create Tabular Models
Create and Manage KPIs Hierarchies
Add a table Delete a Table
Create a Calculated Column
Data types supported
Tabular model designer
Create and Manage Partitions in the Workspace
Create and Manage Tabular Model Partitions
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Gloucester
- 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 Named Calculations in a Data Source View
- See Training Course Details...
Delete a Data Source
Designing Aggregations
Data Source object permissions
BI Wizard
Rename a Multidimensional Database Processing a multidimensional model
Set Partition Storage
Tools and Approaches for Processing
Dimension permissions
Attach and Detach Analysis Services Databases
Define Logical Relationships in a Data Source View
Create User-Defined Hierarchies
Define Named Queries in a Data Source View
Database permissions
Read Definition permissions
Defined Linked Measure Groups Partitions
Create a Data Source
Change a Partition Source
Authorizing access to objects and operations
Data Source Views
Supported Data Sources
Email us about this courses
Other Gloucester Enable Technology Training Courses
SSIS Gloucester Training Courses
Excel Power Pivot - Gloucester Excel Training Courses
Oracle SQL - Gloucester SQL Training Courses
VBA Gloucester Training Courses
Excel 365 Basic - Gloucester Excel Training Courses
DAX Gloucester Training Courses