SQL SERVER ANALYSIS SERVICES TRAINING COURSES LEICESTER
About Enable Technology Leicester SQL Server Analysis Services Training Courses
Enable Technology offer short intensive skills based SQL Server Analysis Services training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). 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.
Enable Technology SQL Server Analysis Services courses are instructor led and taught by an experienced Microsoft expert. We are set up to deliver SQL Server Analysis Services training courses onsite at your premises. Alternatively we could schedule a course at a local socially distanced venue in Leicester. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services training 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.
We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are South Staffordshire Water PLC, Birmingham Heartlands Hospital, Vodafone Group Services, Countrywide Homes Limited, Nuclear Engineering Services, Shell UK Oil Products Ltd, Homeserve PLC and Unipart Group.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Leicester
- 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 ... Supported Data Sources
- See Training Course Details...
Database permissions
Create User-Defined Hierarchies
Modify or Delete an Analysis Services Database
Use a Template to Create an Action Deployment
Document and Script an Analysis Services Database
Create a Dimension by Generating a Non-Time Table in the Data Source
Set Impersonation Options for a Data Source Connection
Using SQL Server Data Tools (SSDT)
Use Aggregate Functions
Attach and Detach Analysis Services Databases
Deployment Requirements and Considerations for Analysis Services Deployment
Define Time Intelligence
Edit or Delete Partitions Merge Partitions
Define Assignments and Other Script Commands
Tools and Approaches for Processing
Backup and Restore of Analysis Services Databases
Create a Dimension by Using an Existing Table
Define Logical Relationships in a Data Source View
Define Attribute Relationships
Create Measures and Measure Groups
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Leicester
- 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 ... Restore from Power Pivot
- See Training Course Details...
Data types supported
Rename a Table or Column
Manage Roles by using SSMS
Create and Manage Roles
Data sources supported in tabular 1400 models
Data sources supported in tabular 1200 models
Create a Calculated Column
Add a table Delete a Table
Import from Power Pivot
Import Data
DirectQuery Mode
Row filter mappings
Import from Analysis Services
Define partitions in DirectQuery models
Delete a Column
Analyze a tabular model in Excel Deploy tabular model solutions
Filter Data in a Table Relationships
Add sample data to DirectQuery models
Tabular model designer
Change table, column
Email us about this courses
Other Leicester Enable Technology Training Courses
Data Warehouse Leicester Training Courses
Report Builder - Leicester SQL Server Reporting Services Training Courses
Excel 365 Advanced Leicester Training Courses
JQuery Leicester Training Courses
Access VBA Leicester Training Courses
PL/SQL - Leicester SQL Training Courses