SQL SERVER ANALYSIS SERVICES TRAINING COURSES CHADDERTON
About Enable Technology Chadderton SQL Server Analysis Services Training Courses
Enable Technology specialise in succinct skills based SQL Server Analysis Services training. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. All candidates receive comprehensive SQL Server Analysis Services training materials and practice files which are theirs to refer to after the course. Our policy is to provide open ended SQL Server Analysis Services post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
SQL Server Analysis Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We are set up to deliver SQL Server Analysis Services training courses onsite at your premises. We are also more than happy to organise a local course at a socially distanced training location in Chadderton. 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.
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 group of companies has been operating continuously providing IT training since 1998. Some of our clients are Aston University, National Power PLC, EDF Energy PLC, South Staffordshire Water PLC, Yell Group PLC, Fujistu PLC, Lloyds TSB Bank PLC and University of Birmingham.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Chadderton
- 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 a Relationship Between Two Tables
- See Training Course Details...
Set the Data Type of a Column
Import from Power View
Impersonation
Enable DirectQuery mode in SSMS
Data sources supported in tabular 1400 models
Data types supported
Create and Manage Measures KPIs
Add columns to a table
DirectQuery Mode
Add a table Delete a Table
Understanding DAX in Tabular Models Measures
Version comparison
Create and Manage Tabular Model Partitions
Define partitions in DirectQuery models
Manage Roles by using SSMS
Create a Calculated Column
Data sources supported in tabular 1200 models
Test a model in DirectQuery mode
Create and Manage Partitions in the Workspace
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Chadderton
- 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 ... Cube or model permissions Process permissions
- See Training Course Details...
Create a Dimension by Using an Existing Table
Using SQL Server Data Tools (SSDT)
Create a Dimension by Generating a Non-Time Table in the Data Source
Edit or Delete Partitions Merge Partitions
View the XML for an Analysis Services Project Data Sources
Define a Fact Relationship and Fact Relationship Properties
Data Source Views
Overview of SSAS Multidimensional Modelling
Add or Remove Tables or Views in a Data Source View
Ragged Hierarchies
Delete a Data Source View Dimensions
Create Named Sets
Use a Template to Create an Action Deployment
Configure Measure Group Properties
Database permissions
Create Calculated Members
Replace a Table or a Named Query in a Data Source View
Define Time Intelligence
Create Measures and Measure Groups
Work with Diagrams in Data Source View Designer
Email us about this courses
Other Chadderton Enable Technology Training Courses
DAX Chadderton Training Courses
PL/SQL - Chadderton SQL Training Courses
Excel 365 Intermediate Chadderton Training Courses
Excel Power Pivot Chadderton Training Courses
SQL Chadderton Training Courses
SSIS - Chadderton SQL Server Integration Services Training Courses