SQL SERVER ANALYSIS SERVICES TRAINING COURSES LLANELLI
About Enable Technology Llanelli SQL Server Analysis Services Training Courses
Enable Technology provides practical SQL Server Analysis Services skills based technology training. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Every course participant is given SQL Server Analysis Services courseware which they can refer to 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.
Courses are instructor led and groups sizes small. Enable Technology can provide SQL Server Analysis Services courses onsite at your location. We will bring the necessary laptops with the required software installed. The SQL Server Analysis Services course could also be scheduled at a socially distanced site near you in Llanelli. The SQL Server Analysis Services syllabus can be modified to accommodate your specific training needs.
This instructor led SQL Server Analysis Services training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Capita Group PLC, Queen's Medical Centre Nottingham, National Power PLC, West Bromwich Building Society, Wolverhampton City Council, Royal Air Force, Vodafone Group Services and Nuclear Engineering Services.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Llanelli
- 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 ... Ragged Hierarchies
- See Training Course Details...
Create a Data Source
Supported Data Sources
Define a Referenced Relationship and Referenced Relationship Properties
Change a Partition Source
Define Logical Relationships in a Data Source View
Attach and Detach Analysis Services Databases
Database permissions
Create Calculated Members
Create a Time Dimension by Generating a Time Table
Create an Analysis Services Project
Deployment Requirements and Considerations for Analysis Services Deployment
Set Impersonation Options for a Data Source Connection
Dimension permissions
Set Data Source Properties
Calculations using the Business Intelligence Wizard
Configure Measure Group Properties
Backup Options Restore Options
Create a Dimension by Generating a Non-Time Table in the Data Source
Delete a Data Source
Rename a Multidimensional Database Processing a multidimensional model
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Llanelli
- 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 ... Version comparison
- See Training Course Details...
Create and Manage Hierarchies Partitions
Database Process Partitions in the Workspace Database Perspectives
Object-level security
Data sources supported in SSAS tabular 2017
Set the Data Type of a Column
Row filter mappings
Change table, column
Manage Roles by using SSMS
Analyze in Excel
Data sources supported in tabular 1200 models
Create and Manage Partitions in the Workspace
Create and Manage Roles
Tabular model designer
Delete Relationships
Create and Manage Measures KPIs
Data sources supported in tabular 1400 models
Add columns to a table
Filter Data in a Table Relationships
Create a New Tabular Model Project
Email us about this courses
Other Llanelli Enable Technology Training Courses
SSIS Llanelli Training Courses
Report Builder Llanelli Training Courses
Excel 365 Basic Llanelli Training Courses
SSRS - Llanelli SQL Server Reporting Services Training Courses
JQuery Llanelli Training Courses
VBA - Llanelli Excel Training Courses