SQL SERVER ANALYSIS SERVICES TRAINING COURSES LEEK
About Enable Technology Leek SQL Server Analysis Services Training Courses
We are a company that provides short intensive SQL Server Analysis Services training courses. The tutor delivering the course will be a Microsoft certified expert. We will issue each SQL Server Analysis Services training participant with learning resources which they can refer to post training. Course participants are welcome contact the Tutor after the course with specific SQL Server Analysis Services queries. This support is open ended.
We provide instructor led training coupled with hands on training. Enable Technology SQL Server Analysis Services courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. If delivery onsite is an issue we will organise a venue near you in Leek. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services training needs.
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 have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Boots UK Limited, Carillion PLC, Nationwide Building Society Limited, Lloyds TSB Bank PLC, Canadian High Commission, Dollond & Aitchison Limited, Nuclear Engineering Services and TalkTalk Direct Limited.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Leek
- 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 Logical Relationships in a Data Source View
- See Training Course Details...
View the XML for an Analysis Services Project Data Sources
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
KPIs Actions
Define Named Calculations in a Data Source View
Add a Standard Action
Backup and Restore of Analysis Services Databases
Create User-Defined Hierarchies
Deploy Analysis Services Projects
Designing Aggregations
Defined Linked Measure Groups Partitions
Edit or Delete Partitions Merge Partitions
Deploy Model Solutions with the Deployment Utility
Database permissions
Rename a Multidimensional Database Processing a multidimensional model
Test an Action
Processing Databases, Dimensions and Partitions
Using SQL Server Data Tools (SSDT)
Modify or Delete an Analysis Services Database
Create Named Sets
Define Named Queries in a Data Source View
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Leek
- 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 ... Create a New Tabular Model Project
- See Training Course Details...
Topics include- Overview of SSAS Tabular models
Data sources supported in tabular 1400 models
Manage Roles by using SSMS
Add columns to a table
Add sample data to DirectQuery models
Import Data
Database Process Partitions in the Workspace Database Perspectives
Create and Manage Roles
Create and Manage Partitions in the Workspace
DirectQuery Mode
Create and Manage Tabular Model Partitions
Object-level security
Specify Mark as Date Table for use with Time Intelligence
Create and Manage Perspectives Translations Roles
Connect to a tabular model database
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Restore from Power Pivot
Import from Power View
Understanding DAX in Tabular Models Measures
Email us about this courses
Other Leek Enable Technology Training Courses
Data Warehouse - Leek SQL Training Courses
SSRS - Leek SQL Server Reporting Services Training Courses
Oracle SQL - Leek SQL Training Courses
Excel 365 Basic Leek Training Courses
PL/SQL - Leek SQL Training Courses
Access VBA - Leek Access Training Courses