SQL SERVER ANALYSIS SERVICES TRAINING COURSES TEWKESBURY
About Enable Technology Tewkesbury 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. We provide every candidate with SQL Server Analysis Services training materials which they keep after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Analysis Services queries.
Courses are instructor led and groups sizes small. We can deliver at your premises. We can provide the equipment. Alternatively we could schedule a course at a local socially distanced venue in Tewkesbury. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services training 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.
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: EDF Energy PLC, Barclays Bank PLC, Fujistu PLC, Keele University, DHL Express, Canadian High Commission, University of Birmingham and Norwich Union PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Tewkesbury
- 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 ... Object-level security
- See Training Course Details...
Create a Calculated Column
Add columns to a table
Analyze in Excel
Create and Manage Hierarchies Partitions
Hide or freeze columns
Delete a Column
Enable DirectQuery mode in SSDT
Specify Mark as Date Table for use with Time Intelligence
Import from Power Pivot
Add a table Delete a Table
Rename a Table or Column
Version comparison
Create and Manage Measures KPIs
Connect to a tabular model database
Database Process Partitions in the Workspace Database Perspectives
Enable DirectQuery mode in SSMS
Create and Manage Tabular Model Partitions
Create and Manage KPIs Hierarchies
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Tewkesbury
- 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 ... Set Impersonation Options for a Data Source Connection
- See Training Course Details...
Deploy Model Solutions Using XMLA
Define a Referenced Relationship and Referenced Relationship Properties
Tools and Approaches for Processing
Overview of SSAS Multidimensional Modelling
Edit or Delete Partitions Merge Partitions
Define Semiadditive Behavior
Create a Dimension Using the Dimension Wizard
Define Assignments and Other Script Commands
Processing Options and Settings
Create Calculated Members
Document and Script an Analysis Services Database
Deploy Model Solutions Using the Deployment Wizard
Create an Analysis Services Project
Deploy Model Solutions with the Deployment Utility
Dimension permissions
Create a Data Source
Define a Regular Relationship and Regular Relationship Properties
Defined Linked Measure Groups Partitions
Add or Remove Tables or Views in a Data Source View
Backup Options Restore Options
Email us about this courses
Other Tewkesbury Enable Technology Training Courses
Excel 365 Intermediate Tewkesbury Training Courses
Report Builder - Tewkesbury SQL Server Reporting Services Training Courses
Access - Tewkesbury Access Training Courses
Excel 365 Advanced - Tewkesbury Excel Training Courses
JavaScript Tewkesbury Training Courses
Power BI Tewkesbury Training Courses