SQL SERVER ANALYSIS SERVICES TRAINING COURSES NORTH EAST
About Enable Technology North East SQL Server Analysis Services Training Courses
We are a company that provides short intensive SQL Server Analysis Services training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. All candidates receive comprehensive SQL Server Analysis Services training materials and practice files which are theirs to refer to after the course. If delegates have have questions about SQL Server Analysis Services after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Our primary method of delivery is instructor led training coupled with practical hands on activities. Enable Technology SQL Server Analysis Services training courses can be delivered at your offices. We can supply the necessary software and computers. If delivery onsite is an issue we will organise a venue near you in North East. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.
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.
We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: Countrywide Homes Limited, Halfords Group PLC, Yell Group PLC, Nuclear Engineering Services, West Bromwich Building Society, Royal Air Force, Aston University and Wolverhampton City Council.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: North East
- 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 ... Row filter mappings
- See Training Course Details...
Process Database, Table, or Partition
Filter Data in a Table Relationships
Understanding DAX in Tabular Models Measures
Add a table Delete a Table
Delete a Column
Set the Data Type of a Column
Create a New Tabular Model Project
Create a Relationship Between Two Tables
Data sources supported in tabular 1200 models
Create a Calculated Table
Database Process Partitions in the Workspace Database Perspectives
Create and Manage Partitions in the Workspace
DirectQuery Mode
Analyze a tabular model in Excel Deploy tabular model solutions
Create and Manage Perspectives Translations Roles
Define partitions in DirectQuery models
Add columns to a table
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: North East
- 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 ... Define a Referenced Relationship and Referenced Relationship Properties
- See Training Course Details...
Create a Dimension by Generating a Non-Time Table in the Data Source
Supported Data Sources
Create a Dimension by Using an Existing Table
Set Impersonation Options for a Data Source Connection
Define a Regular Relationship and Regular Relationship Properties
Attach and Detach Analysis Services Databases
Designing Aggregations
Read Definition permissions
Configure Analysis Services Project Properties
Work with Diagrams in Data Source View Designer
Define a Data Source View
Create a Time Dimension by Generating a Time Table
Calculations using the Business Intelligence Wizard
Use a Template to Create an Action Deployment
Set Data Source Properties
Tools and Approaches for Processing
Use Aggregate Functions
Backup Options Restore Options
Create Measures and Measure Groups
Ragged Hierarchies
Email us about this courses
Other North East Enable Technology Training Courses
Power BI - North East Microsoft Power BI Training Courses
Power Query North East Training Courses
DAX North East Training Courses
Report Builder North East Training Courses
Excel 365 Advanced - North East Excel Training Courses
VBA North East Training Courses