SQL SERVER ANALYSIS SERVICES TRAINING COURSES CARMARTHEN
About Enable Technology Carmarthen SQL Server Analysis Services Training Courses
Enable Technology specialise in succinct skills based SQL Server Analysis Services training. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. All candidates receive comprehensive SQL Server Analysis Services training materials and practice files which are theirs to refer to after the course. 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.
We provide instructor led training coupled with hands on training. We are set up to deliver SQL Server Analysis Services training courses onsite at your premises. Another way we could deliver the SQL Server Analysis Services course is at a local training site. We will work with you prior to the course to tailor the SQL Server Analysis Services syllabus to match your 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.
We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Aston University, Unipart Group, Vodafone Group Services, Keele University, South Staffordshire Water PLC, Lloyds TSB Bank PLC, Barclays Bank PLC and Carillion PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Carmarthen
- 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...
Processing Databases, Dimensions and Partitions
Read Definition permissions
Create Measures and Measure Groups
BI Wizard
Batch Processing Remote Processing
Defined Linked Measure Groups Partitions
Add or Remove Tables or Views in a Data Source View
Define Attribute Relationships
Set Partition Storage
Define Logical Relationships in a Data Source View
Use a Template to Create an Action Deployment
Edit or Delete Partitions Merge Partitions
Explore Data in a Data Source View
Test an Action
Define Time Intelligence
Error Configuration Roles and Permissions
Set Data Source Properties
Deploy Model Solutions Using XMLA
Deploy Model Solutions Using the Deployment Wizard
Define a Fact Relationship and Fact Relationship Properties
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Carmarthen
- 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 ... Topics include- Overview of SSAS Tabular models
- See Training Course Details...
Data sources supported in tabular 1400 models
Delete a Column
Bi-directional cross filters Calculations
Data sources supported in tabular 1200 models
Import from Analysis Services
Create and Manage KPIs Hierarchies
Define partitions in DirectQuery models
Process Database, Table, or Partition
Create and Manage Partitions in the Workspace
Sort Data in a Table
Row filter mappings
Import Data
Filter Data in a Table Relationships
Create a Relationship Between Two Tables
Version comparison
Delete Relationships
Hide or freeze columns
Data types supported
Restore from Power Pivot
Email us about this courses
Other Carmarthen Enable Technology Training Courses
JavaScript Carmarthen Training Courses
Power BI Carmarthen Training Courses
SQL - Carmarthen SQL Training Courses
Access Carmarthen Training Courses
SSRS Carmarthen Training Courses
Excel Power Pivot Carmarthen Training Courses