SQL SERVER ANALYSIS SERVICES TRAINING COURSES SWINDON
About Enable Technology Swindon SQL Server Analysis Services Training Courses
Enable Technology specialise in succinct skills based SQL Server Analysis Services training. All Enable Technology tutors are Microsoft certified experts. Each person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials after the training. Course participants are welcome contact the Tutor after the course with specific SQL Server Analysis Services queries. This support is open ended.
Delegates are taught by an experienced Microsoft professional. SQL Server Analysis Services courses are delivered through a mix of practical hands on exercises and walk throughs. 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. If you prefer we can offer an offsite training location in Swindon. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.
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 team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Countrywide Homes Limited, Yell Group PLC, South Staffordshire Water PLC, Barclays Bank PLC, GKN PLC, University of Birmingham, Norwich Union PLC and DHL Express.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Swindon
- 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 ... Add a Standard Action
- See Training Course Details...
Change a Partition Source
Define a Referenced Relationship and Referenced Relationship Properties
Dimension permissions
Ragged Hierarchies
Attach and Detach Analysis Services Databases
Deployment Requirements and Considerations for Analysis Services Deployment
Defined Linked Measure Groups Partitions
Read Definition permissions
Create Measures and Measure Groups
Overview of SSAS Multidimensional Modelling
Create Calculated Members
Partition Writeback Calculations
Create Remote Partitions
Error Configuration Roles and Permissions
Edit or Delete Partitions Merge Partitions
Modify or Delete in Solution Explorer Database Dimensions
Create a Dimension by Using an Existing Table
Explore Data in a Data Source View
BI Wizard
Use a Template to Create an Action Deployment
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Swindon
- 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 ... DirectQuery Mode
- See Training Course Details...
Understanding DAX in Tabular Models Measures
Data sources supported in tabular 1200 models
Version comparison
Enable DirectQuery mode in SSMS
Process Database, Table, or Partition
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Restore from Power Pivot
Create and Manage Measures KPIs
Create a New Tabular Model Project
Bi-directional cross filters Calculations
Import from Analysis Services
Data sources supported in SSAS tabular 2017
Add columns to a table
Connect to a tabular model database
Import Data
Database Process Partitions in the Workspace Database Perspectives
Impersonation
Add a table Delete a Table
Email us about this courses
Other Swindon Enable Technology Training Courses
Excel 365 Intermediate - Swindon Excel Training Courses
SQL Swindon Training Courses
Data Warehouse Swindon Training Courses
JavaScript - Swindon JavaScript Training Courses
Excel 365 Advanced - Swindon Excel Training Courses
Report Builder Swindon Training Courses