SQL SERVER ANALYSIS SERVICES TRAINING COURSES SPLOTT
About Enable Technology Splott SQL Server Analysis Services Training Courses
We are company which specialises in short, two and three day intensive SQL Server Analysis Services technology training courses. 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. We also provide an ongoing support service to people attending our SQL Server Analysis Services courses. Delegates can contact the course tutor with specific SQL Server Analysis Services questions for as long as they need following the course.
We provide instructor led training coupled with hands on training. Enable Technology SQL Server Analysis Services training courses can be delivered at your offices. We can supply the necessary software and computers. If you prefer we can offer an offsite socially distanced training location in Splott. We are happy to modify the SQL Server Analysis Services syllabus to match your teams training requirements.
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.
In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Royal & Sun Alliance Group PLC, Vodafone Group Services, EDF Energy PLC, TalkTalk Direct Limited, Nuclear Engineering Services, Queen's Medical Centre Nottingham, Norwich Union PLC and Birmingham City Council.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Splott
- 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 ... Deployment Requirements and Considerations for Analysis Services Deployment
- See Training Course Details...
Multidimensional models
Add a Standard Action
Create a Time Dimension by Generating a Time Table
Error Configuration Roles and Permissions
Define Assignments and Other Script Commands
Overview of SSAS Multidimensional Modelling
Add or Remove Tables or Views in a Data Source View
Create Calculated Members
Set Partition Storage
Define Time Intelligence
Calculations using the Business Intelligence Wizard
Define a Regular Relationship and Regular Relationship Properties
Attach and Detach Analysis Services Databases
Replace a Table or a Named Query in a Data Source View
Create an Analysis Services Project
Processing Options and Settings
Create a Dimension by Using an Existing Table
Designing Aggregations
Defined Linked Measure Groups Partitions
Rename a Multidimensional Database Processing a multidimensional model
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Splott
- 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 ... Enable DirectQuery mode in SSDT
- See Training Course Details...
Process Tabular Model Partitions
Tabular model designer
Process Database, Table, or Partition
Bi-directional cross filters Calculations
DirectQuery Mode
Restore from Power Pivot
Create and Manage Partitions in the Workspace
Data sources supported in tabular 1200 models
Import from Analysis Services
Understanding DAX in Tabular Models Measures
Analyze a tabular model in Excel Deploy tabular model solutions
Create and Manage Tabular Model Partitions
Import from Power View
Create a Calculated Table
Row filter mappings
Database Process Partitions in the Workspace Database Perspectives
Data sources supported in tabular 1400 models
Change table, column
Impersonation
Email us about this courses
Other Splott Enable Technology Training Courses
Power Query - Splott Excel Training Courses
Excel 365 Advanced Splott Training Courses
SSIS - Splott SQL Server Integration Services Training Courses
Excel 365 Basic - Splott Excel Training Courses
Access VBA Splott Training Courses
VBA - Splott Excel Training Courses