SQL SERVER ANALYSIS SERVICES TRAINING COURSES DEWSBURY
About Enable Technology Dewsbury SQL Server Analysis Services Training Courses
Enable Technology provides practical SQL Server Analysis Services skills based technology training. All of our tutors are Microsoft Certified Professionals. Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source after the course. 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. Enable Technology can provide SQL Server Analysis Services courses onsite at your location. We will bring the necessary laptops with the required software installed. If you prefer we can offer an offsite training location in Dewsbury. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.
We also deliver this course online through virtual classrooms. Delegates can join scheduled SQL Server Analysis Services classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Norwich Union PLC, Canadian High Commission, Unipart Group, Barclays Bank PLC, Cadbury PLC, Countrywide Homes Limited, Halfords Group PLC and Homeserve PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Dewsbury
- 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 ... Backup and Restore of Analysis Services Databases
- See Training Course Details...
Create Remote Partitions
Ragged Hierarchies
Define Named Queries in a Data Source View
Overview of SSAS Multidimensional Modelling
Data Source object permissions
Use Aggregate Functions
Document and Script an Analysis Services Database
Create User-Defined Hierarchies
Dimension permissions
Database permissions
Processing Options and Settings
Error Configuration Roles and Permissions
Test an Action
Create a Time Dimension by Generating a Time Table
Create a Dimension by Generating a Non-Time Table in the Data Source
BI Wizard
Add a Standard Action
Configure Measure Group Properties
Partition Writeback Calculations
Replace a Table or a Named Query in a Data Source View
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Dewsbury
- 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...
Create a Relationship Between Two Tables
Import from Power View
Import from Power Pivot
Create and Manage KPIs Hierarchies
Create and Manage Roles
Create and Manage Measures KPIs
Create a Calculated Column
Delete Relationships
Version comparison
Impersonation
Data sources supported in SSAS tabular 2016 Create Tabular Models
Import data by using a native query
Change table, column
Add a table Delete a Table
Object-level security
Specify Mark as Date Table for use with Time Intelligence
Create a Calculated Table
Test a model in DirectQuery mode
Email us about this courses
Other Dewsbury Enable Technology Training Courses
JQuery - Dewsbury JavaScript Training Courses
SQL Dewsbury Training Courses
SSIS - Dewsbury SQL Server Integration Services Training Courses
Oracle SQL - Dewsbury SQL Training Courses
Power BI - Dewsbury Microsoft Power BI Training Courses
Access - Dewsbury Access Training Courses