SQL SERVER ANALYSIS SERVICES TRAINING COURSES ABERDARE
About Enable Technology Aberdare SQL Server Analysis Services Training Courses
Enable Technology specialise in succinct skills based SQL Server Analysis Services training. The tutor delivering the course will be a Microsoft certified expert. Each person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials after the training. Enable Technology offer post course help to all delegates. Participants on the SQL Server Analysis Services course can contact the tutor for as long as they like if they encounter SQL Server Analysis Services problems.
Enable Technology training courses are delivered as instructor led courses. We can bring the equipment necessary to deliver SQL Server Analysis Services courses at your site. We can also deliver the SQL Server Analysis Services course at a local training venue in Aberdare. The SQL Server Analysis Services syllabus can be modified to accommodate your specific training needs.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time 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 Nationwide Building Society Limited, Aston University, Nuclear Engineering Services, Total Telecommunications Limited, Dollond & Aitchison Limited, University of Birmingham, Loughborough University and Wolverhampton City Council.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Aberdare
- 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 ... DAX formula compatibility in DirectQuery mode Tables and Columns
- See Training Course Details...
Data sources supported in tabular 1400 models
Add sample data to DirectQuery models
Version comparison
Change table, column
Analyze in Excel
Create and Manage Perspectives Translations Roles
Create and Manage Measures KPIs
Analyze a tabular model in Excel Deploy tabular model solutions
Process Database, Table, or Partition
Rename a Table or Column
Sort Data in a Table
Create a Calculated Column
Create a Relationship Between Two Tables
Row filter mappings
Understanding DAX in Tabular Models Measures
Manage Roles by using SSMS
Topics include- Overview of SSAS Tabular models
Filter Data in a Table Relationships
Restore from Power Pivot
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Aberdare
- 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 ... View the XML for an Analysis Services Project Data Sources
- See Training Course Details...
Overview of SSAS Multidimensional Modelling
KPIs Actions
Create a Time Dimension by Generating a Time Table
Move an Analysis Services Database
Authorizing access to objects and operations
Tools and Approaches for Processing
Replace a Table or a Named Query in a Data Source View
Dimension permissions
Create Named Sets
Add a Standard Action
Data Source Views
Create a Data Source
Change a Partition Source
Error Configuration Roles and Permissions
Define Semiadditive Behavior
Configure Analysis Services Project Properties
Cube or model permissions Process permissions
Modify or Delete an Analysis Services Database
Read Definition permissions
Calculations using the Business Intelligence Wizard
Email us about this courses
Other Aberdare Enable Technology Training Courses
JQuery Mobile - Aberdare JavaScript Training Courses
Excel 365 Basic Aberdare Training Courses
VBA Aberdare Training Courses
Power BI - Aberdare Microsoft Power BI Training Courses
JavaScript Aberdare Training Courses
Access - Aberdare Access Training Courses