SQL SERVER ANALYSIS SERVICES TRAINING COURSES DERBY
About Enable Technology Derby SQL Server Analysis Services Training Courses
We offer intensive two and three days SQL Server Analysis Services courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Every course participant will receives course practice files and SQL Server Analysis Services course resources that can be referenced post training. It is our company policy to provide SQL Server Analysis Services training participants with ongoing support from the course Tutor. People who attend a SQL Server Analysis Services course can contact the Tutor for as long as they need assistance after the training.
Our primary method of delivery is instructor led training coupled with practical hands on activities. 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. We also offer the option of scheduling of SQL Server Analysis Services course at a venue near you in Derby. We are happy to modify the SQL Server Analysis Services syllabus to match your teams training requirements.
We can also deliver SQL Server Analysis Services courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
Our teaching team have over twenty years continuous technical training experience. Our clients include: Dollond & Aitchison Limited, EDF Energy PLC, Canadian High Commission, Norfolk Police Constabulary, Boots UK Limited, South Staffordshire Water PLC, GKN PLC and Aston University.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Derby
- 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...
Delete a Data Source View Dimensions
Read Definition permissions
Modify or Delete an Analysis Services Database
Database permissions
Dimension permissions
Deploy Model Solutions with the Deployment Utility
Create an Analysis Services Project
Partition Writeback Calculations
Processing Databases, Dimensions and Partitions
Calculations using the Business Intelligence Wizard
Define Attribute Relationships
Defined Linked Measure Groups Partitions
Define a Referenced Relationship and Referenced Relationship Properties
Configure Measure Group Properties
Define Semiadditive Behavior
Using SQL Server Data Tools (SSDT)
Replace a Table or a Named Query in a Data Source View
Authorizing access to objects and operations
Use Aggregate Functions
Create a Data Source
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Derby
- 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 ... Row filter mappings
- See Training Course Details...
Data sources supported in tabular 1400 models
Connect to a tabular model database
Database Process Partitions in the Workspace Database Perspectives
Version comparison
Analyze in Excel
Enable DirectQuery mode in SSMS
DAX formula compatibility in DirectQuery mode Tables and Columns
Define partitions in DirectQuery models
Hide or freeze columns
DirectQuery Mode
Process Tabular Model Partitions
Restore from Power Pivot
Create a New Tabular Model Project
Topics include- Overview of SSAS Tabular models
Import from Analysis Services
Create and Manage KPIs Hierarchies
Create and Manage Roles
Import from Power View
Test a model in DirectQuery mode
Email us about this courses
Other Derby Enable Technology Training Courses
Oracle SQL Derby Training Courses
DAX - Derby Excel Training Courses
Access VBA - Derby Access Training Courses
Data Warehouse Derby Training Courses
Excel 365 Advanced Derby Training Courses
Power Query Derby Training Courses