SQL SERVER ANALYSIS SERVICES TRAINING COURSES ROCHDALE
About Enable Technology Rochdale SQL Server Analysis Services Training Courses
We are a company that provides short intensive SQL Server Analysis Services training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source 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. 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 training location in Rochdale. We are happy to modify the SQL Server Analysis Services syllabus to match your teams training requirements.
SQL Server Analysis Services courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are South Staffordshire Water PLC, Carillion PLC, Lloyds TSB Bank PLC, Norfolk Police Constabulary, Unipart Group, Capita Group PLC, Wolverhampton City Council and Yell Group PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Rochdale
- 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 ... Define Assignments and Other Script Commands
- See Training Course Details...
Work with Diagrams in Data Source View Designer
KPIs Actions
Deploy Model Solutions Using XMLA
Create Measures and Measure Groups
View the XML for an Analysis Services Project Data Sources
Use Aggregate Functions
Create a Data Source
Attach and Detach Analysis Services Databases
Rename a Multidimensional Database Processing a multidimensional model
Define Logical Primary Keys in a Data Source View
Define a Data Source View
Read Definition permissions
Create Named Sets
Create Remote Partitions
Modify or Delete an Analysis Services Database
Create Local Partitions
Data Source object permissions
Create a Time Dimension by Generating a Time Table
Cube or model permissions Process permissions
Define Logical Relationships in a Data Source View
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Rochdale
- 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 ... Data sources supported in tabular 1200 models
- See Training Course Details...
Tabular model designer
Import from Power Pivot
Row filter mappings
Rename a Table or Column
Define partitions in DirectQuery models
Analyze in Excel
Delete Relationships
DirectQuery Mode
Create and Manage Roles
Create and Manage Perspectives Translations Roles
Create a Relationship Between Two Tables
Data sources supported in SSAS tabular 2016 Create Tabular Models
Import from Analysis Services
Object-level security
Restore from Power Pivot
Impersonation
Data sources supported in SSAS tabular 2017
Import from Power View
Create a Calculated Table
Email us about this courses
Other Rochdale Enable Technology Training Courses
VBA Rochdale Training Courses
SSRS - Rochdale SQL Server Reporting Services Training Courses
Data Warehouse - Rochdale SQL Training Courses
Oracle SQL - Rochdale SQL Training Courses
PL/SQL Rochdale Training Courses
Excel 365 Advanced Rochdale Training Courses