SQL SERVER ANALYSIS SERVICES TRAINING COURSES SWINDON
About Enable Technology Swindon SQL Server Analysis Services Training Courses
Enable Technology has twenty year track record of providing short intensive SQL Server Analysis Services skills based training courses. We guarantee the training will be delivered by a Microsoft certified expert. We will issue each SQL Server Analysis Services training participant with learning resources which they can refer to post training. 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 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 Swindon. We offer the option of working with you to develop a bespoke SQL Server Analysis Services programme which precisely matches your organisations training 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.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Nationwide Building Society Limited, Norwich Union PLC, Unipart Group, South Staffordshire Water PLC, Capita Group PLC, Aston University, Canadian High Commission and Lloyds TSB Bank PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Swindon
- 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 ... BI Wizard
- See Training Course Details...
Define Assignments and Other Script Commands
Explore Data in a Data Source View
Multidimensional models
Define Named Calculations in a Data Source View
Processing Options and Settings
Data Source Views
Define Time Intelligence
Create a Time Dimension by Generating a Time Table
Edit or Delete Partitions Merge Partitions
Attach and Detach Analysis Services Databases
Partition Writeback Calculations
Deploy Model Solutions Using the Deployment Wizard
Deployment Requirements and Considerations for Analysis Services Deployment
Create a Data Source
Data Source object permissions
Deploy Model Solutions Using XMLA
Replace a Table or a Named Query in a Data Source View
Define a Data Source View
Backup and Restore of Analysis Services Databases
Define a Referenced Relationship and Referenced Relationship Properties
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Swindon
- 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 ... Row filter mappings
- See Training Course Details...
Analyze a tabular model in Excel Deploy tabular model solutions
Add sample data to DirectQuery models
Bi-directional cross filters Calculations
Database Process Partitions in the Workspace Database Perspectives
Version comparison
Create a Calculated Table
Import Data
Data sources supported in tabular 1400 models
Analyze in Excel
Create and Manage KPIs Hierarchies
Create a Calculated Column
Import data by using a native query
Import from Power Pivot
Create and Manage Tabular Model Partitions
Create and Manage Measures KPIs
Object-level security
Process Database, Table, or Partition
Import from Power View
Data sources supported in SSAS tabular 2017
Enable DirectQuery mode in SSDT
Email us about this courses
Other Swindon Enable Technology Training Courses
Excel 365 Advanced Swindon Training Courses
Data Warehouse Swindon Training Courses
Excel 365 Intermediate - Swindon Excel Training Courses
SSRS Swindon Training Courses
JavaScript Swindon Training Courses
Report Builder Swindon Training Courses