SQL SERVER ANALYSIS SERVICES TRAINING COURSES DUDLEY
About Enable Technology Dudley SQL Server Analysis Services Training Courses
Enable Technology has twenty year track record of providing short intensive SQL Server Analysis Services skills based training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every course participant will receives course practice files and SQL Server Analysis Services course resources that can be referenced post training. We also provide an ongoing support service to people attending our SQL Server Analysis Services courses. Delegates can contact the course tutor with specific SQL Server Analysis Services questions for as long as they need following the course.
SQL Server Analysis Services courses are taught by a Microsoft Certified Solutions Expert. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Analysis Services onsite. We also offer the option of scheduling of SQL Server Analysis Services course at a venue near you in Dudley. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services training requirements.
We also deliver this course online. Delegates participate in a virtual SQL Server Analysis Services class and can both talk to and share their screen with the tutor.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Birmingham City Council, Carillion PLC, Shell UK Oil Products Ltd, Loughborough University, South Staffordshire Water PLC, Aston University, Homeserve PLC and Norfolk Police Constabulary.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Dudley
- 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 ... Set Impersonation Options for a Data Source Connection
- See Training Course Details...
Define Time Intelligence
Define a Regular Relationship and Regular Relationship Properties
Edit or Delete Partitions Merge Partitions
Backup Options Restore Options
Create a Dimension Using the Dimension Wizard
Define Named Queries in a Data Source View
Create Measures and Measure Groups
Modify or Delete in Solution Explorer Database Dimensions
Read Definition permissions
Database permissions
Move an Analysis Services Database
Create Remote Partitions
Deploy Model Solutions with the Deployment Utility
Define Named Calculations in a Data Source View
Replace a Table or a Named Query in a Data Source View
Create a Data Source
Error Configuration Roles and Permissions
Cube or model permissions Process permissions
Partition Writeback Calculations
Processing Options and Settings
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Dudley
- 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 columns to a table
- See Training Course Details...
Enable DirectQuery mode in SSDT
Create a New Tabular Model Project
Sort Data in a Table
Delete a Column
Create a Calculated Table
Impersonation
Database Process Partitions in the Workspace Database Perspectives
Delete Relationships
Version comparison
DAX formula compatibility in DirectQuery mode Tables and Columns
Bi-directional cross filters Calculations
Restore from Power Pivot
Row filter mappings
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Change table, column
Understanding DAX in Tabular Models Measures
Process Tabular Model Partitions
Import from Power View
Email us about this courses
Other Dudley Enable Technology Training Courses
Power BI Dudley Training Courses
Report Builder - Dudley SQL Server Reporting Services Training Courses
Access - Dudley Access Training Courses
SSIS Dudley Training Courses
Oracle SQL Dudley Training Courses
Excel Power Pivot - Dudley Excel Training Courses