SQL SERVER ANALYSIS SERVICES TRAINING COURSES BARRY
About Enable Technology Barry 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. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Each person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials 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. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Analysis Services onsite. If you prefer we can offer an offsite socially distanced training location in Barry. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services training needs.
SQL Server Analysis Services courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
Our teaching team have over twenty years continuous technical training experience. Our clients include: TalkTalk Direct Limited, Keele University, Capita Group PLC, Canadian High Commission, Nuclear Engineering Services, EDF Energy PLC, Dollond & Aitchison Limited and Birmingham City Council.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Barry
- 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 ... Overview of SSAS Multidimensional Modelling
- See Training Course Details...
Designing Aggregations
Define a Fact Relationship and Fact Relationship Properties
KPIs Actions
Tools and Approaches for Processing
Authorizing access to objects and operations
Attach and Detach Analysis Services Databases
Dimension permissions
Deploy Model Solutions Using the Deployment Wizard
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Deploy Model Solutions with the Deployment Utility
Define Named Calculations in a Data Source View
Set Partition Storage
Deploy Model Solutions Using XMLA
Define a Data Source View
Create Remote Partitions
Read Definition permissions
Edit or Delete Partitions Merge Partitions
Replace a Table or a Named Query in a Data Source View
Create a Time Dimension by Generating a Time Table
Add or Remove Tables or Views in a Data Source View
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Barry
- 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...
Add columns to a table
Specify Mark as Date Table for use with Time Intelligence
Object-level security
Row filter mappings
Enable DirectQuery mode in SSMS
Process Database, Table, or Partition
Create and Manage Measures KPIs
Enable DirectQuery mode in SSDT
Manage Roles by using SSMS
Process Tabular Model Partitions
Import from Analysis Services
Create and Manage Roles
Data sources supported in tabular 1400 models
DirectQuery Mode
Data sources supported in tabular 1200 models
Add sample data to DirectQuery models
Analyze a tabular model in Excel Deploy tabular model solutions
Hide or freeze columns
Delete a Column
Email us about this courses
Other Barry Enable Technology Training Courses
Excel Power Pivot Barry Training Courses
JQuery - Barry JavaScript Training Courses
Oracle SQL Barry Training Courses
SSRS - Barry SQL Server Reporting Services Training Courses
Access - Barry Access Training Courses
JQuery Mobile - Barry JavaScript Training Courses