SQL SERVER ANALYSIS SERVICES TRAINING COURSES NORMANTON
About Enable Technology Normanton SQL Server Analysis Services Training Courses
Enable Technology provides practical SQL Server Analysis Services skills based technology training. The training will be delivered by a Microsoft professional with development experience. All course participants are issued SQL Server Analysis Services training manuals they can refer to 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.
Courses are instructor led and groups sizes small. Enable Technology SQL Server Analysis Services training courses can be delivered at your offices. We can supply the necessary software and computers. We are also more than happy to organise a local course at a socially distanced training location in Normanton. Every SQL Server Analysis Services course can be modified to meet your bespoke requirements.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled SQL Server Analysis Services course, watch the tutor demonstrate tasks, ask questions and share their own screen.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Loughborough University, Carillion PLC, Lloyds TSB Bank PLC, University of Birmingham, Royal & Sun Alliance Group PLC, National Power PLC, Countrywide Homes Limited and Unipart Group.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Normanton
- 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 ... Replace a Table or a Named Query in a Data Source View
- See Training Course Details...
Create Local Partitions
Define Assignments and Other Script Commands
Backup Options Restore Options
Batch Processing Remote Processing
Create Named Sets
Ragged Hierarchies
Define Named Calculations in a Data Source View
Define Attribute Relationships
Document and Script an Analysis Services Database
Define a Regular Relationship and Regular Relationship Properties
Delete a Data Source
Backup and Restore of Analysis Services Databases
Rename a Multidimensional Database Processing a multidimensional model
Create a Dimension by Using an Existing Table
Deploy Model Solutions Using XMLA
Partition Writeback Calculations
Define Time Intelligence
Delete a Data Source View Dimensions
View the XML for an Analysis Services Project Data Sources
Configure Measure Group Properties
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Normanton
- 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 ... Rename a Table or Column
- See Training Course Details...
Create and Manage Perspectives Translations Roles
Understanding DAX in Tabular Models Measures
Create and Manage Hierarchies Partitions
Import data by using a native query
Delete Relationships
DAX formula compatibility in DirectQuery mode Tables and Columns
Import from Analysis Services
Data sources supported in SSAS tabular 2016 Create Tabular Models
Add sample data to DirectQuery models
Row filter mappings
Define partitions in DirectQuery models
Create a Relationship Between Two Tables
Impersonation
Analyze in Excel
Create and Manage KPIs Hierarchies
Create and Manage Measures KPIs
Object-level security
Connect to a tabular model database
DirectQuery Mode
Add columns to a table
Email us about this courses
Other Normanton Enable Technology Training Courses
VBA Normanton Training Courses
Power BI - Normanton Microsoft Power BI Training Courses
Report Builder Normanton Training Courses
Access VBA Normanton Training Courses
SSIS Normanton Training Courses
Access - Normanton Access Training Courses