SQL SERVER ANALYSIS SERVICES TRAINING COURSES NEATH
About Enable Technology Neath SQL Server Analysis Services Training Courses
Enable Technology SQL Server Analysis Services courses are short, skill focused and hands on. All of our tutors are Microsoft Certified Professionals. We provide every candidate with SQL Server Analysis Services training materials which they keep 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.
Enable Technology offers instructor led training taught by technology specialists. Enable Technology can supply all of the equipment necessary to deliver SQL Server Analysis Services courses onsite at your offices. You simply need to provide a suitable room. Another option is we can organise a local training site in Neath. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite SQL Server Analysis Services course to some extent is bespoke and tailored to your 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.
In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Queen's Medical Centre Nottingham, West Bromwich Building Society, DHL Express, Wolverhampton City Council, Vodafone Group Services, Birmingham City University, Boots UK Limited and Total Telecommunications Limited.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Neath
- 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 ... Delete Relationships
- See Training Course Details...
Add columns to a table
Bi-directional cross filters Calculations
Create and Manage Perspectives Translations Roles
Define partitions in DirectQuery models
Create and Manage Tabular Model Partitions
Restore from Power Pivot
Set the Data Type of a Column
Impersonation
Hide or freeze columns
Understanding DAX in Tabular Models Measures
Data sources supported in SSAS tabular 2017
Import from Analysis Services
Data sources supported in tabular 1400 models
Connect to a tabular model database
Create a Calculated Column
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Analyze in Excel
Version comparison
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Neath
- 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 Options and Settings
- See Training Course Details...
Define Attribute Relationships
Cube or model permissions Process permissions
Calculations using the Business Intelligence Wizard
Defined Linked Measure Groups Partitions
Work with Diagrams in Data Source View Designer
Attach and Detach Analysis Services Databases
Define Named Calculations in a Data Source View
Change a Partition Source
Supported Data Sources
Replace a Table or a Named Query in a Data Source View
Define Semiadditive Behavior
Set Impersonation Options for a Data Source Connection
Deploy Model Solutions Using XMLA
Designing Aggregations
Create a Dimension by Using an Existing Table
Edit or Delete Partitions Merge Partitions
Authorizing access to objects and operations
Define a Fact Relationship and Fact Relationship Properties
Modify or Delete an Analysis Services Database
Create a Dimension Using the Dimension Wizard
Email us about this courses
Other Neath Enable Technology Training Courses
Data Warehouse - Neath SQL Training Courses
Oracle SQL - Neath SQL Training Courses
JavaScript Neath Training Courses
DAX - Neath Excel Training Courses
Excel 365 Advanced - Neath Excel Training Courses
Excel 365 Intermediate - Neath Excel Training Courses