SQL SERVER ANALYSIS SERVICES TRAINING COURSES MALVERN
About Enable Technology Malvern SQL Server Analysis Services Training Courses
We have a twenty year history of providing skills based SQL Server Analysis Services industry training. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. All candidates receive comprehensive SQL Server Analysis Services training materials and practice files which are theirs to 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.
Our primary method of delivery is instructor led training coupled with practical hands on activities. We are set up to deliver SQL Server Analysis Services training courses onsite at your premises. The SQL Server Analysis Services course could also be scheduled at a socially distanced site near you in Malvern. Every SQL Server Analysis Services course can be modified to meet your bespoke requirements.
This instructor led SQL Server Analysis Services training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
We have operated primarily in the West Midlands for twenty years. Our clients include: West Bromwich Building Society, Unipart Group, Norwich Union PLC, Loughborough University, Cadbury PLC, Keele University, Fujistu PLC and DHL Express.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Malvern
- 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 ... Dimension permissions
- See Training Course Details...
Processing Databases, Dimensions and Partitions
Create a Dimension by Generating a Non-Time Table in the Data Source
Define a Fact Relationship and Fact Relationship Properties
Set Partition Storage
Define a Data Source View
Backup and Restore of Analysis Services Databases
Create Local Partitions
Deployment Requirements and Considerations for Analysis Services Deployment
Tools and Approaches for Processing
Using SQL Server Data Tools (SSDT)
Ragged Hierarchies
Create Measures and Measure Groups
Create Remote Partitions
Create a Dimension by Using an Existing Table
Create a Time Dimension by Generating a Time Table
Multidimensional models
Define a Regular Relationship and Regular Relationship Properties
Deploy Model Solutions Using XMLA
Define Assignments and Other Script Commands
Define Named Queries in a Data Source View
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Malvern
- 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...
Delete Relationships
Import from Power View
Set the Data Type of a Column
Row filter mappings
Specify Mark as Date Table for use with Time Intelligence
Bi-directional cross filters Calculations
Import Data
Test a model in DirectQuery mode
Create and Manage Tabular Model Partitions
Create a Relationship Between Two Tables
Hide or freeze columns
Create and Manage KPIs Hierarchies
Sort Data in a Table
Restore from Power Pivot
Create and Manage Roles
Understanding DAX in Tabular Models Measures
Database Process Partitions in the Workspace Database Perspectives
Impersonation
Analyze in Excel
Email us about this courses
Other Malvern Enable Technology Training Courses
SSRS - Malvern SQL Server Reporting Services Training Courses
Excel Power Pivot - Malvern Excel Training Courses
Report Builder - Malvern SQL Server Reporting Services Training Courses
Data Warehouse - Malvern SQL Training Courses
PL/SQL Malvern Training Courses
TSQL - Malvern SQL Training Courses