SQL SERVER ANALYSIS SERVICES TRAINING COURSES SOUTH GLAMORGAN
About Enable Technology South Glamorgan 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 Solutions Experts with development backgrounds. Every course participant will receives course practice files and SQL Server Analysis Services course resources that can be referenced post training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Analysis Services queries.
Enable Technology SQL Server Analysis Services courses are instructor led and taught by an experienced Microsoft expert. Enable Technology SQL Server Analysis Services courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. The SQL Server Analysis Services course could also be scheduled at a socially distanced site near you in South Glamorgan. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services training needs.
We can also deliver SQL Server Analysis Services courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Fujistu PLC, Birmingham Heartlands Hospital, Yell Group PLC, DHL Express, Keele University, Barclays Bank PLC, Nationwide Building Society Limited and National Power PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: South Glamorgan
- 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 ... Add sample data to DirectQuery models
- See Training Course Details...
Test a model in DirectQuery mode
Topics include- Overview of SSAS Tabular models
Import from Power View
Create a Calculated Table
Data sources supported in tabular 1200 models
Import from Analysis Services
Manage Roles by using SSMS
Specify Mark as Date Table for use with Time Intelligence
Create and Manage Roles
Enable DirectQuery mode in SSDT
Database Process Partitions in the Workspace Database Perspectives
Hide or freeze columns
Connect to a tabular model database
Import from Power Pivot
Data sources supported in tabular 1400 models
Import Data
Bi-directional cross filters Calculations
Process Tabular Model Partitions
Row filter mappings
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: South Glamorgan
- 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 ... Document and Script an Analysis Services Database
- See Training Course Details...
Define Named Calculations in a Data Source View
Delete a Data Source View Dimensions
Processing Databases, Dimensions and Partitions
Modify or Delete an Analysis Services Database
Read Definition permissions
Configure Measure Group Properties
Designing Aggregations
Data Source object permissions
Ragged Hierarchies
Cube or model permissions Process permissions
Deploy Model Solutions Using the Deployment Wizard
Backup and Restore of Analysis Services Databases
Deployment Requirements and Considerations for Analysis Services Deployment
Create Remote Partitions
Define Logical Primary Keys in a Data Source View
Using SQL Server Data Tools (SSDT)
Configure Analysis Services Project Properties
Create a Data Source
Dimension permissions
Processing Options and Settings
Email us about this courses
Other South Glamorgan Enable Technology Training Courses
Excel 365 Basic - South Glamorgan Excel Training Courses
Excel 365 Advanced - South Glamorgan Excel Training Courses
VBA South Glamorgan Training Courses
SQL - South Glamorgan SQL Training Courses
Power Query - South Glamorgan Excel Training Courses
Power BI South Glamorgan Training Courses