SQL SERVER ANALYSIS SERVICES TRAINING COURSES MOLD
About Enable Technology Mold SQL Server Analysis Services Training Courses
We are a company that offers short, practical, SQL Server Analysis Services hands on technology courses. All Enable Technology tutors are Microsoft certified experts. We provide every candidate with SQL Server Analysis Services training materials which they keep after the course. If delegates have have questions about SQL Server Analysis Services after the course they are welcome to contact the course Tutor. This post training support is ongoing.
SQL Server Analysis Services courses are taught by a Microsoft Certified Solutions Expert. 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. If you prefer we can offer an offsite socially distanced training location in Mold. We offer the option of working with you to develop a bespoke SQL Server Analysis Services programme which precisely matches your organisations training 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 group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Boots UK Limited, Wolverhampton City Council, Royal & Sun Alliance Group PLC, GKN PLC, Fujistu PLC, Canadian High Commission, Carillion PLC and Countrywide Homes Limited.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Mold
- 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 ... Designing Aggregations
- See Training Course Details...
Batch Processing Remote Processing
Set Data Source Properties
Modify or Delete in Solution Explorer Database Dimensions
Define a Referenced Relationship and Referenced Relationship Properties
Deploy Model Solutions Using the Deployment Wizard
Work with Diagrams in Data Source View Designer
Attach and Detach Analysis Services Databases
Processing Options and Settings
Explore Data in a Data Source View
Deploy Model Solutions Using XMLA
Deploy Analysis Services Projects
Define Assignments and Other Script Commands
Use a Template to Create an Action Deployment
Multidimensional models
Document and Script an Analysis Services Database
Create a Dimension Using the Dimension Wizard
Overview of SSAS Multidimensional Modelling
Data Source object permissions
Modify or Delete an Analysis Services Database
Calculations using the Business Intelligence Wizard
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Mold
- 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...
Create and Manage Perspectives Translations Roles
Enable DirectQuery mode in SSDT
Import from Analysis Services
Create a Calculated Table
Data types supported
Add columns to a table
Data sources supported in tabular 1400 models
Create and Manage Measures KPIs
Tabular model designer
Import data by using a native query
Filter Data in a Table Relationships
Set the Data Type of a Column
Object-level security
Data sources supported in tabular 1200 models
Create and Manage Partitions in the Workspace
Enable DirectQuery mode in SSMS
Data sources supported in SSAS tabular 2016 Create Tabular Models
Add a table Delete a Table
Import Data
Data sources supported in SSAS tabular 2017
Email us about this courses
Other Mold Enable Technology Training Courses
TSQL - Mold SQL Training Courses
SSRS Mold Training Courses
SQL Mold Training Courses
VBA - Mold Excel Training Courses
Access Mold Training Courses
Excel 365 Advanced Mold Training Courses