SQL SERVER ANALYSIS SERVICES TRAINING COURSES PRESTWICH
About Enable Technology Prestwich 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. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Each person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials after the training. Course participants are welcome contact the Tutor after the course with specific SQL Server Analysis Services queries. This support is open ended.
SQL Server Analysis Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We are set up to deliver SQL Server Analysis Services training courses onsite at your premises. If delivery onsite is an issue we will organise a socially distanced venue near you in Prestwich. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services training requirements.
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.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are Loughborough University, Birmingham City University, DHL Express, Queen's Medical Centre Nottingham, Homeserve PLC, EDF Energy PLC, Yell Group PLC and Keele University.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Prestwich
- 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 Databases, Dimensions and Partitions
- See Training Course Details...
Data Source object permissions
Deployment Requirements and Considerations for Analysis Services Deployment
Create Named Sets
Deploy Model Solutions Using XMLA
Create User-Defined Hierarchies
Define Assignments and Other Script Commands
BI Wizard
Batch Processing Remote Processing
Rename a Multidimensional Database Processing a multidimensional model
Define Attribute Relationships
Create Local Partitions
Create an Analysis Services Project
Define Named Calculations in a Data Source View
Create Calculated Members
Database permissions
Edit or Delete Partitions Merge Partitions
Configure Analysis Services Project Properties
Designing Aggregations
Add a Standard Action
KPIs Actions
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Prestwich
- 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 ... Topics include- Overview of SSAS Tabular models
- See Training Course Details...
DirectQuery Mode
Connect to a tabular model database
Import data by using a native query
Create and Manage KPIs Hierarchies
Set the Data Type of a Column
Enable DirectQuery mode in SSDT
Specify Mark as Date Table for use with Time Intelligence
Process Database, Table, or Partition
Data sources supported in tabular 1400 models
Version comparison
Add a table Delete a Table
Create and Manage Tabular Model Partitions
Bi-directional cross filters Calculations
Create and Manage Perspectives Translations Roles
Import from Power View
Create a New Tabular Model Project
Create and Manage Roles
Create a Calculated Table
Email us about this courses
Other Prestwich Enable Technology Training Courses
SQL Prestwich Training Courses
Excel Power Pivot Prestwich Training Courses
JQuery Mobile Prestwich Training Courses
Excel 365 Advanced Prestwich Training Courses
VBA - Prestwich Excel Training Courses
SSRS Prestwich Training Courses