SQL SERVER ANALYSIS SERVICES TRAINING COURSES GLOUCESTER
About Enable Technology Gloucester SQL Server Analysis Services Training Courses
We are a company that offers short, practical, SQL Server Analysis Services hands on technology courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Each course participant will be issued with training SQL Server Analysis Services resources which they can continue to use after the 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. Enable Technology can provide SQL Server Analysis Services courses onsite at your location. We will bring the necessary laptops with the required software installed. We also offer the option of scheduling of SQL Server Analysis Services course at a venue near you in Gloucester. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.
SQL Server Analysis Services courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Norfolk Police Constabulary, Barclays Bank PLC, DHL Express, Queen's Medical Centre Nottingham, Fujistu PLC, Royal Air Force, Wolverhampton City Council and Keele University.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Gloucester
- 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 and Manage Perspectives Translations Roles
- See Training Course Details...
Process Database, Table, or Partition
Create and Manage Tabular Model Partitions
Create a Calculated Table
Data sources supported in SSAS tabular 2016 Create Tabular Models
Import from Power Pivot
DirectQuery Mode
Create a Relationship Between Two Tables
DAX formula compatibility in DirectQuery mode Tables and Columns
Create and Manage KPIs Hierarchies
Filter Data in a Table Relationships
Create a Calculated Column
Delete Relationships
Analyze in Excel
Connect to a tabular model database
Create and Manage Partitions in the Workspace
Enable DirectQuery mode in SSDT
Object-level security
Row filter mappings
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Gloucester
- 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 ... Processing Databases, Dimensions and Partitions
- See Training Course Details...
Attach and Detach Analysis Services Databases
Designing Aggregations
Calculations using the Business Intelligence Wizard
Cube or model permissions Process permissions
Define Named Queries in a Data Source View
Create Calculated Members
Define a Regular Relationship and Regular Relationship Properties
View the XML for an Analysis Services Project Data Sources
Read Definition permissions
Define a Referenced Relationship and Referenced Relationship Properties
Create a Data Source
Define Attribute Relationships
Create a Dimension by Using an Existing Table
Define Logical Primary Keys in a Data Source View
Create Local Partitions
Define Time Intelligence
Configure Analysis Services Project Properties
Deployment Requirements and Considerations for Analysis Services Deployment
Data Source object permissions
Create User-Defined Hierarchies
Email us about this courses
Other Gloucester Enable Technology Training Courses
Power BI Gloucester Training Courses
Access VBA - Gloucester Access Training Courses
Excel Power Pivot Gloucester Training Courses
Excel 365 Intermediate Gloucester Training Courses
SSIS Gloucester Training Courses
JQuery Gloucester Training Courses