SQL SERVER ANALYSIS SERVICES TRAINING COURSES DEVON
About Enable Technology Devon SQL Server Analysis Services Training Courses
We have a twenty year history of providing skills based SQL Server Analysis Services industry training. All Enable Technology tutors are Microsoft certified experts. Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source after the course. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
Delegates are taught by an experienced Microsoft professional. SQL Server Analysis Services courses are delivered through a mix of practical hands on exercises and walk throughs. Enable Technology SQL Server Analysis Services courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Alternatively we could schedule a SQL Server Analysis Services course at an alternative training site in Devon. Every SQL Server Analysis Services course can be modified to meet your bespoke requirements.
We can also deliver SQL Server Analysis Services courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Wolverhampton City Council, Birmingham City University, Nationwide Building Society Limited, Cadbury PLC, Loughborough University, DHL Express, Vodafone Group Services and Total Telecommunications Limited.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Devon
- 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 ... Define a Referenced Relationship and Referenced Relationship Properties
- See Training Course Details...
Dimension permissions
Create Calculated Members
Define Named Calculations in a Data Source View
Database permissions
Edit or Delete Partitions Merge Partitions
Create a Data Source
Rename a Multidimensional Database Processing a multidimensional model
Deploy Model Solutions Using XMLA
Document and Script an Analysis Services Database
Deployment Requirements and Considerations for Analysis Services Deployment
Define Assignments and Other Script Commands
Deploy Model Solutions with the Deployment Utility
Create a Dimension by Using an Existing Table
Create User-Defined Hierarchies
Replace a Table or a Named Query in a Data Source View
View the XML for an Analysis Services Project Data Sources
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Backup and Restore of Analysis Services Databases
Tools and Approaches for Processing
Define Logical Relationships in a Data Source View
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Devon
- 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 ... Connect to a tabular model database
- See Training Course Details...
Understanding DAX in Tabular Models Measures
Import Data
Data sources supported in tabular 1400 models
Rename a Table or Column
Import from Analysis Services
Data types supported
Analyze a tabular model in Excel Deploy tabular model solutions
Define partitions in DirectQuery models
Restore from Power Pivot
Set the Data Type of a Column
Create and Manage KPIs Hierarchies
Enable DirectQuery mode in SSDT
Hide or freeze columns
Process Tabular Model Partitions
Change table, column
Impersonation
Version comparison
Create and Manage Tabular Model Partitions
Process Database, Table, or Partition
DAX formula compatibility in DirectQuery mode Tables and Columns
Email us about this courses
Other Devon Enable Technology Training Courses
Power Query Devon Training Courses
Access Devon Training Courses
JQuery Mobile - Devon JavaScript Training Courses
Report Builder Devon Training Courses
Oracle SQL - Devon SQL Training Courses
Excel 365 Basic Devon Training Courses