SQL SERVER ANALYSIS SERVICES TRAINING COURSES LICHFIELD
About Enable Technology Lichfield SQL Server Analysis Services Training Courses
Enable Technology provides practical SQL Server Analysis Services skills based technology training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Each person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials 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.
Our primary method of delivery is instructor led training coupled with practical hands on activities. We can bring the equipment necessary to deliver SQL Server Analysis Services courses at your site. Alternatively we could schedule a SQL Server Analysis Services course at an alternative training site in Lichfield. 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 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.
We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: Total Telecommunications Limited, Norfolk Police Constabulary, Dollond & Aitchison Limited, Carillion PLC, Cadbury PLC, Aston University, Birmingham City University and Nationwide Building Society Limited.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Lichfield
- 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 ... Document and Script an Analysis Services Database
- See Training Course Details...
Define a Regular Relationship and Regular Relationship Properties
Overview of SSAS Multidimensional Modelling
Define Attribute Relationships
Database permissions
Attach and Detach Analysis Services Databases
Define Logical Relationships in a Data Source View
BI Wizard
Data Source Views
Modify or Delete an Analysis Services Database
Defined Linked Measure Groups Partitions
Configure Measure Group Properties
Processing Options and Settings
Set Impersonation Options for a Data Source Connection
Work with Diagrams in Data Source View Designer
Set Partition Storage
Define a Referenced Relationship and Referenced Relationship Properties
Move an Analysis Services Database
Delete a Data Source View Dimensions
Data Source object permissions
Dimension permissions
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Lichfield
- 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 ... Import from Power View
- See Training Course Details...
Create and Manage Measures KPIs
Create and Manage Partitions in the Workspace
Add a table Delete a Table
Data types supported
Create and Manage Tabular Model Partitions
Data sources supported in tabular 1200 models
Create a Relationship Between Two Tables
Enable DirectQuery mode in SSMS
Rename a Table or Column
Analyze in Excel
Create and Manage Hierarchies Partitions
Restore from Power Pivot
Hide or freeze columns
Import Data
Database Process Partitions in the Workspace Database Perspectives
Change table, column
Create a Calculated Table
Version comparison
Email us about this courses
Other Lichfield Enable Technology Training Courses
Oracle SQL Lichfield Training Courses
JQuery Mobile Lichfield Training Courses
TSQL Lichfield Training Courses
Access - Lichfield Access Training Courses
Excel 365 Intermediate Lichfield Training Courses
Excel 365 Advanced Lichfield Training Courses