SQL SERVER ANALYSIS SERVICES TRAINING COURSES MID GLAMORGAN
About Enable Technology Mid Glamorgan SQL Server Analysis Services Training Courses
Enable Technology SQL Server Analysis Services courses are short, skill focused and hands on. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every course participant will receives course practice files and SQL Server Analysis Services course resources that can be referenced post training. 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. Enable Technology can provide SQL Server Analysis Services courses onsite at your location. We will bring the necessary laptops with the required software installed. The SQL Server Analysis Services course could also be scheduled at a socially distanced site near you in Mid Glamorgan. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Norfolk Police Constabulary, Cadbury PLC, Barclays Bank PLC, West Bromwich Building Society, Unipart Group, Norwich Union PLC, Birmingham Heartlands Hospital and Aston University.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Mid Glamorgan
- 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 ... Restore from Power Pivot
- See Training Course Details...
Import data by using a native query
Enable DirectQuery mode in SSMS
Add columns to a table
Test a model in DirectQuery mode
Add sample data to DirectQuery models
Row filter mappings
Version comparison
Data types supported
Tabular model designer
Analyze in Excel
DirectQuery Mode
Data sources supported in tabular 1200 models
Create and Manage Roles
Delete a Column
Specify Mark as Date Table for use with Time Intelligence
Create and Manage KPIs Hierarchies
Define partitions in DirectQuery models
Data sources supported in SSAS tabular 2016 Create Tabular Models
Process Database, Table, or Partition
Set the Data Type of a Column
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Mid Glamorgan
- 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 Model Solutions Using the Deployment Wizard
- See Training Course Details...
Multidimensional models
Read Definition permissions
Define Logical Relationships in a Data Source View
Tools and Approaches for Processing
Deploy Model Solutions Using XMLA
Add or Remove Tables or Views in a Data Source View
Explore Data in a Data Source View
Delete a Data Source
Create Local Partitions
Supported Data Sources
Define Time Intelligence
Data Source Views
Set Data Source Properties
Define a Regular Relationship and Regular Relationship Properties
KPIs Actions
Error Configuration Roles and Permissions
Use Aggregate Functions
Configure Measure Group Properties
Create a Dimension by Using an Existing Table
Overview of SSAS Multidimensional Modelling
Email us about this courses
Other Mid Glamorgan Enable Technology Training Courses
SSIS Mid Glamorgan Training Courses
JavaScript Mid Glamorgan Training Courses
VBA Mid Glamorgan Training Courses
DAX Mid Glamorgan Training Courses
JQuery Mobile - Mid Glamorgan JavaScript Training Courses
Report Builder - Mid Glamorgan SQL Server Reporting Services Training Courses