SQL SERVER ANALYSIS SERVICES TRAINING COURSES PRESTATYN
About Enable Technology Prestatyn 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). All course participants are issued SQL Server Analysis Services training manuals they can refer to after the course. We also provide an ongoing support service to people attending our SQL Server Analysis Services courses. Delegates can contact the course tutor with specific SQL Server Analysis Services questions for as long as they need following the course.
Courses are instructor led and groups sizes small. We can deliver at your premises. We can provide the equipment. If you prefer we can offer an offsite socially distanced training location in Prestatyn. All SQL Server Analysis Services courses can be customised to meet your particular requirements.
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. Some of our clients are Norwich Union PLC, National Power PLC, Royal Air Force, Yell Group PLC, Dollond & Aitchison Limited, Shell UK Oil Products Ltd, South Staffordshire Water PLC and Capita Group PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Prestatyn
- 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 ... Processing Options and Settings
- See Training Course Details...
Set Partition Storage
Defined Linked Measure Groups Partitions
Define a Regular Relationship and Regular Relationship Properties
Create a Dimension Using the Dimension Wizard
Create Calculated Members
Create Local Partitions
Define Assignments and Other Script Commands
Deploy Model Solutions Using XMLA
Define Attribute Relationships
Create User-Defined Hierarchies
Configure Analysis Services Project Properties
Configure Measure Group Properties
Test an Action
Create an Analysis Services Project
Document and Script an Analysis Services Database
Define Named Calculations in a Data Source View
Use Aggregate Functions
Backup Options Restore Options
Batch Processing Remote Processing
Cube or model permissions Process permissions
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Prestatyn
- 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 ... Restore from Power Pivot
- See Training Course Details...
Create and Manage Tabular Model Partitions
Process Tabular Model Partitions
Connect to a tabular model database
Create a Calculated Table
Data sources supported in tabular 1200 models
Row filter mappings
Hide or freeze columns
Create and Manage Perspectives Translations Roles
Set the Data Type of a Column
Create a New Tabular Model Project
Import Data
Understanding DAX in Tabular Models Measures
Add sample data to DirectQuery models
DirectQuery Mode
Rename a Table or Column
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Tabular model designer
Object-level security
Process Database, Table, or Partition
Create and Manage Measures KPIs
Email us about this courses
Other Prestatyn Enable Technology Training Courses
Power BI Prestatyn Training Courses
PL/SQL - Prestatyn SQL Training Courses
Oracle SQL Prestatyn Training Courses
TSQL - Prestatyn SQL Training Courses
Data Warehouse - Prestatyn SQL Training Courses
Excel 365 Intermediate Prestatyn Training Courses