SQL SERVER ANALYSIS SERVICES TRAINING COURSES HEREFORD
About Enable Technology Hereford 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. All Enable Technology tutors are Microsoft certified experts. Every course participant will receives course practice files and SQL Server Analysis Services course resources that can be referenced post training. Course participants are welcome contact the Tutor after the course with specific SQL Server Analysis Services queries. This support is open ended.
Enable Technology training courses are delivered as instructor led courses. Our SQL Server Analysis Services training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Another option is we can organise a local socially distanced training site in Hereford. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services training needs.
SQL Server Analysis Services courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can 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: Norfolk Police Constabulary, Dollond & Aitchison Limited, Yell Group PLC, EDF Energy PLC, Norwich Union PLC, Nationwide Building Society Limited, Royal & Sun Alliance Group PLC and Aston University.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Hereford
- 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 ... Database Process Partitions in the Workspace Database Perspectives
- See Training Course Details...
Sort Data in a Table
Create and Manage Perspectives Translations Roles
Enable DirectQuery mode in SSMS
Create a Calculated Table
Data sources supported in tabular 1400 models
Add a table Delete a Table
Process Tabular Model Partitions
Topics include- Overview of SSAS Tabular models
Test a model in DirectQuery mode
DirectQuery Mode
Impersonation
Data sources supported in tabular 1200 models
Row filter mappings
Add columns to a table
Set the Data Type of a Column
Import Data
Create and Manage Tabular Model Partitions
Process Database, Table, or Partition
Filter Data in a Table Relationships
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Hereford
- 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 ... Deploy Analysis Services Projects
- See Training Course Details...
Explore Data in a Data Source View
Define Logical Primary Keys in a Data Source View
Define a Data Source View
Delete a Data Source
Backup and Restore of Analysis Services Databases
Partition Writeback Calculations
Create a Time Dimension by Generating a Time Table
Create Calculated Members
Define Assignments and Other Script Commands
Attach and Detach Analysis Services Databases
Define Logical Relationships in a Data Source View
Dimension permissions
Modify or Delete in Solution Explorer Database Dimensions
Designing Aggregations
Deploy Model Solutions Using XMLA
Batch Processing Remote Processing
Tools and Approaches for Processing
Set Impersonation Options for a Data Source Connection
Create Local Partitions
Define Semiadditive Behavior
Email us about this courses
Other Hereford Enable Technology Training Courses
SSIS Hereford Training Courses
Access - Hereford Access Training Courses
Excel 365 Advanced Hereford Training Courses
Excel 365 Basic - Hereford Excel Training Courses
Power BI - Hereford Microsoft Power BI Training Courses
VBA Hereford Training Courses