SQL SERVER ANALYSIS SERVICES TRAINING COURSES PORTHCAWL
About Enable Technology Porthcawl 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. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Each course participant will be issued with training SQL Server Analysis Services resources which they can continue to use after the training. We offer a post training support service and delegates will have access to a Microsoft expert on SQL Server Analysis Services for as long as they need.
SQL Server Analysis Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Analysis Services onsite. Another way we could deliver the SQL Server Analysis Services course is at a local training site. We offer the option of working with you to develop a bespoke SQL Server Analysis Services programme which precisely matches your organisations training requirements.
We also deliver this course online. Delegates participate in a virtual SQL Server Analysis Services class and can both talk to and share their screen with the tutor.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Unipart Group, South Staffordshire Water PLC, National Power PLC, Birmingham City Council, Shell UK Oil Products Ltd, Norwich Union PLC, GKN PLC and Wolverhampton City Council.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Porthcawl
- 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 ... Delete Relationships
- See Training Course Details...
Restore from Power Pivot
Add a table Delete a Table
Data sources supported in SSAS tabular 2017
Data sources supported in SSAS tabular 2016 Create Tabular Models
Define partitions in DirectQuery models
Test a model in DirectQuery mode
Data types supported
Add columns to a table
Create and Manage Roles
Set the Data Type of a Column
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Import from Analysis Services
Add sample data to DirectQuery models
Import from Power Pivot
Change table, column
Understanding DAX in Tabular Models Measures
Process Database, Table, or Partition
Create and Manage Partitions in the Workspace
DAX formula compatibility in DirectQuery mode Tables and Columns
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Porthcawl
- 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 ... Create Calculated Members
- See Training Course Details...
Test an Action
Designing Aggregations
KPIs Actions
Deploy Model Solutions Using XMLA
Define Attribute Relationships
Add or Remove Tables or Views in a Data Source View
Error Configuration Roles and Permissions
View the XML for an Analysis Services Project Data Sources
Deployment Requirements and Considerations for Analysis Services Deployment
Define Time Intelligence
Create a Data Source
Tools and Approaches for Processing
Create Local Partitions
Processing Databases, Dimensions and Partitions
Create a Dimension by Using an Existing Table
Edit or Delete Partitions Merge Partitions
Data Source Views
Work with Diagrams in Data Source View Designer
Define a Regular Relationship and Regular Relationship Properties
Set Data Source Properties
Email us about this courses
Other Porthcawl Enable Technology Training Courses
Report Builder Porthcawl Training Courses
Excel 365 Intermediate Porthcawl Training Courses
Data Warehouse - Porthcawl SQL Training Courses
JQuery - Porthcawl JavaScript Training Courses
Power Query Porthcawl Training Courses
SSRS - Porthcawl SQL Server Reporting Services Training Courses