SQL SERVER ANALYSIS SERVICES TRAINING COURSES TREHARRIS
About Enable Technology Treharris SQL Server Analysis Services Training Courses
Enable Technology provides practical SQL Server Analysis Services skills based technology 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. Our policy is to provide open ended SQL Server Analysis Services post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology SQL Server Analysis Services courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Another option is we can organise a local training site in Treharris. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.
Taught SQL Server Analysis Services courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
We have operated primarily in the West Midlands for twenty years. Some of our clients are Unipart Group, Nationwide Building Society Limited, Dollond & Aitchison Limited, Lloyds TSB Bank PLC, Nuclear Engineering Services, Wolverhampton City Council, Aston University and Barclays Bank PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Treharris
- 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 ... Define Named Queries in a Data Source View
- See Training Course Details...
Error Configuration Roles and Permissions
Multidimensional models
Test an Action
Define Time Intelligence
Create an Analysis Services Project
Configure Measure Group Properties
Create a Data Source
Define Logical Relationships in a Data Source View
Create Local Partitions
Delete a Data Source
Define a Regular Relationship and Regular Relationship Properties
Use a Template to Create an Action Deployment
Deploy Model Solutions Using the Deployment Wizard
Define Assignments and Other Script Commands
Create Calculated Members
Deployment Requirements and Considerations for Analysis Services Deployment
Database permissions
Defined Linked Measure Groups Partitions
Deploy Model Solutions Using XMLA
Work with Diagrams in Data Source View Designer
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Treharris
- 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 ... Set the Data Type of a Column
- See Training Course Details...
Create and Manage Partitions in the Workspace
Change table, column
Enable DirectQuery mode in SSMS
Understanding DAX in Tabular Models Measures
Create and Manage KPIs Hierarchies
Connect to a tabular model database
Test a model in DirectQuery mode
Process Tabular Model Partitions
Bi-directional cross filters Calculations
Add columns to a table
Create and Manage Perspectives Translations Roles
DirectQuery Mode
Import from Power View
Data types supported
Add sample data to DirectQuery models
Tabular model designer
Import Data
Create and Manage Hierarchies Partitions
Row filter mappings
Email us about this courses
Other Treharris Enable Technology Training Courses
SSRS - Treharris SQL Server Reporting Services Training Courses
Power BI - Treharris Microsoft Power BI Training Courses
Power Query - Treharris Excel Training Courses
Data Warehouse Treharris Training Courses
TSQL Treharris Training Courses
JavaScript Treharris Training Courses