SQL SERVER ANALYSIS SERVICES TRAINING COURSES GORSEINON
About Enable Technology Gorseinon 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. Each course participant will be issued with training SQL Server Analysis Services resources which they can continue to use after the training. Anyone attending the course can contact the Tutor for as long as they like after the SQL Server Analysis Services course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Enable Technology offers instructor led training taught by technology specialists. We can set up a training lab at your premises and deliver SQL Server Analysis Services courses onsite at your site. We can also deliver the SQL Server Analysis Services course at a socially distanced local training venue in Gorseinon. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.
SQL Server Analysis Services courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
Our teaching team have over twenty years continuous technical training experience. Our clients include: Norfolk Police Constabulary, Keele University, Boots UK Limited, Cadbury PLC, Barclays Bank PLC, Total Telecommunications Limited, Royal & Sun Alliance Group PLC and Birmingham City Council.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Gorseinon
- 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 ... Hide or freeze columns
- See Training Course Details...
Delete Relationships
Process Database, Table, or Partition
Create and Manage Tabular Model Partitions
Create and Manage Perspectives Translations Roles
Create a Calculated Table
Process Tabular Model Partitions
Add columns to a table
Tabular model designer
Manage Roles by using SSMS
Define partitions in DirectQuery models
Create a New Tabular Model Project
Object-level security
Rename a Table or Column
Sort Data in a Table
Change table, column
Row filter mappings
Analyze in Excel
Add sample data to DirectQuery models
Enable DirectQuery mode in SSMS
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Gorseinon
- 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 ... Test an Action
- See Training Course Details...
Data Source object permissions
BI Wizard
Create User-Defined Hierarchies
Partition Writeback Calculations
Explore Data in a Data Source View
Configure Analysis Services Project Properties
Set Impersonation Options for a Data Source Connection
Define Named Calculations in a Data Source View
KPIs Actions
Work with Diagrams in Data Source View Designer
Define Logical Relationships in a Data Source View
View the XML for an Analysis Services Project Data Sources
Dimension permissions
Add or Remove Tables or Views in a Data Source View
Processing Options and Settings
Create Local Partitions
Define Named Queries in a Data Source View
Create Calculated Members
Overview of SSAS Multidimensional Modelling
Set Data Source Properties
Email us about this courses
Other Gorseinon Enable Technology Training Courses
TSQL Gorseinon Training Courses
SSRS - Gorseinon SQL Server Reporting Services Training Courses
Excel 365 Advanced Gorseinon Training Courses
DAX - Gorseinon Excel Training Courses
Excel Power Pivot - Gorseinon Excel Training Courses
JQuery Mobile - Gorseinon JavaScript Training Courses