SQL SERVER ANALYSIS SERVICES TRAINING COURSES STRETFORD
About Enable Technology Stretford SQL Server Analysis Services Training Courses
Enable Technology has twenty year track record of providing short intensive SQL Server Analysis Services skills based training courses. All Enable Technology tutors are Microsoft certified experts. We provide every candidate with SQL Server Analysis Services training materials which they keep after the course. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Our SQL Server Analysis Services training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Another option is we can organise a local socially distanced training site in Stretford. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.
SQL Server Analysis Services courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can 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. Some of our clients are Unipart Group, Total Telecommunications Limited, Boots UK Limited, Norfolk Police Constabulary, Nuclear Engineering Services, Homeserve PLC, Birmingham Heartlands Hospital and EDF Energy PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Stretford
- 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 ... Analyze a tabular model in Excel Deploy tabular model solutions
- See Training Course Details...
Specify Mark as Date Table for use with Time Intelligence
DAX formula compatibility in DirectQuery mode Tables and Columns
Create and Manage Hierarchies Partitions
Data sources supported in tabular 1400 models
Row filter mappings
Create and Manage Roles
Import from Analysis Services
Create a Relationship Between Two Tables
Data sources supported in SSAS tabular 2016 Create Tabular Models
Understanding DAX in Tabular Models Measures
Create and Manage Tabular Model Partitions
Create and Manage Partitions in the Workspace
Import from Power Pivot
Create and Manage KPIs Hierarchies
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Create a Calculated Table
Restore from Power Pivot
Filter Data in a Table Relationships
Import from Power View
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Stretford
- 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 ... Explore Data in a Data Source View
- See Training Course Details...
Create Named Sets
Tools and Approaches for Processing
Delete a Data Source View Dimensions
Rename a Multidimensional Database Processing a multidimensional model
Document and Script an Analysis Services Database
Test an Action
Supported Data Sources
Define Assignments and Other Script Commands
Create a Data Source
Set Impersonation Options for a Data Source Connection
Using SQL Server Data Tools (SSDT)
Use Aggregate Functions
Configure Analysis Services Project Properties
Designing Aggregations
Cube or model permissions Process permissions
Define Named Queries in a Data Source View
Dimension permissions
Replace a Table or a Named Query in a Data Source View
Ragged Hierarchies
Attach and Detach Analysis Services Databases
Email us about this courses
Other Stretford Enable Technology Training Courses
Excel Power Pivot Stretford Training Courses
Access VBA Stretford Training Courses
Power Query - Stretford Excel Training Courses
Excel 365 Basic Stretford Training Courses
Data Warehouse - Stretford SQL Training Courses
Excel 365 Advanced - Stretford Excel Training Courses