SQL SERVER ANALYSIS SERVICES TRAINING COURSES CARDIFF
About Enable Technology Cardiff SQL Server Analysis Services Training Courses
We are company which specialises in short, two and three day intensive SQL Server Analysis Services technology training courses. The course will always be taught by a Microsoft Certified Professional (MCP). Each course participant will be issued with training SQL Server Analysis Services resources which they can continue to use after the training. If delegates have have questions about SQL Server Analysis Services after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Our primary method of delivery is instructor led training coupled with practical hands on activities. We can set up a training lab at your premises and deliver SQL Server Analysis Services courses onsite at your site. Another way we could deliver the SQL Server Analysis Services course is at a local training site. 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.
SQL Server Analysis Services courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Yell Group PLC, Halfords Group PLC, Cadbury PLC, DHL Express, Capita Group PLC, Countrywide Homes Limited, Carillion PLC and Birmingham Heartlands Hospital.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Cardiff
- 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 Roles
- See Training Course Details...
Row filter mappings
Delete a Column
Add sample data to DirectQuery models
Process Tabular Model Partitions
Create and Manage Partitions in the Workspace
Process Database, Table, or Partition
Import Data
Hide or freeze columns
Create a New Tabular Model Project
Impersonation
Object-level security
Define partitions in DirectQuery models
Import data by using a native query
Analyze a tabular model in Excel Deploy tabular model solutions
Restore from Power Pivot
Manage Roles by using SSMS
Data types supported
Import from Analysis Services
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Cardiff
- 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 ... Cube or model permissions Process permissions
- See Training Course Details...
Data Source object permissions
Replace a Table or a Named Query in a Data Source View
Create Local Partitions
Using SQL Server Data Tools (SSDT)
Work with Diagrams in Data Source View Designer
Create Remote Partitions
Define Semiadditive Behavior
Edit or Delete Partitions Merge Partitions
Deploy Model Solutions Using XMLA
Tools and Approaches for Processing
Test an Action
Delete a Data Source
Rename a Multidimensional Database Processing a multidimensional model
Overview of SSAS Multidimensional Modelling
Defined Linked Measure Groups Partitions
Deploy Model Solutions with the Deployment Utility
Create a Dimension by Generating a Non-Time Table in the Data Source
Create a Data Source
Processing Options and Settings
Create Named Sets
Email us about this courses
Other Cardiff Enable Technology Training Courses
Excel 365 Advanced Cardiff Training Courses
JQuery Cardiff Training Courses
SSRS Cardiff Training Courses
SSIS Cardiff Training Courses
Power Query Cardiff Training Courses
Excel 365 Intermediate - Cardiff Excel Training Courses