SQL SERVER ANALYSIS SERVICES TRAINING COURSES CHRISTCHURCH
About Enable Technology Christchurch SQL Server Analysis Services Training Courses
We are a company that offers short, practical, SQL Server Analysis Services hands on technology courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source 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. Enable Technology can provide SQL Server Analysis Services courses onsite at your location. We will bring the necessary laptops with the required software installed. The SQL Server Analysis Services course could also be scheduled at a socially distanced site near you in Christchurch. 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. Delegates participate in a virtual SQL Server Analysis Services class and can both talk to and share their screen with the tutor.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are TalkTalk Direct Limited, Cadbury PLC, Royal Air Force, Birmingham City Council, Royal & Sun Alliance Group PLC, Aston University, Carillion PLC and Shell UK Oil Products Ltd.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Christchurch
- 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 a Column
Specify Mark as Date Table for use with Time Intelligence
Understanding DAX in Tabular Models Measures
Sort Data in a Table
Analyze in Excel
Add sample data to DirectQuery models
Define partitions in DirectQuery models
Version comparison
Create and Manage Hierarchies Partitions
Delete Relationships
Create a Calculated Table
Database Process Partitions in the Workspace Database Perspectives
Enable DirectQuery mode in SSDT
Add columns to a table
Import from Analysis Services
Impersonation
Create a Relationship Between Two Tables
Data sources supported in tabular 1200 models
Create and Manage Tabular Model Partitions
Create a Calculated Column
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Christchurch
- 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 ... Partition Writeback Calculations
- See Training Course Details...
Backup Options Restore Options
Configure Measure Group Properties
Explore Data in a Data Source View
Add a Standard Action
Attach and Detach Analysis Services Databases
View the XML for an Analysis Services Project Data Sources
Create a Time Dimension by Generating a Time Table
Deploy Model Solutions Using XMLA
Document and Script an Analysis Services Database
Work with Diagrams in Data Source View Designer
Create Remote Partitions
Create an Analysis Services Project
BI Wizard
Define a Regular Relationship and Regular Relationship Properties
Replace a Table or a Named Query in a Data Source View
Create Measures and Measure Groups
Create a Dimension Using the Dimension Wizard
Set Data Source Properties
Set Partition Storage
Ragged Hierarchies
Email us about this courses
Other Christchurch Enable Technology Training Courses
SSRS - Christchurch SQL Server Reporting Services Training Courses
Access VBA - Christchurch Access Training Courses
Access - Christchurch Access Training Courses
JQuery Christchurch Training Courses
Report Builder - Christchurch SQL Server Reporting Services Training Courses
Power BI - Christchurch Microsoft Power BI Training Courses