SQL SERVER ANALYSIS SERVICES TRAINING COURSES SOLIHULL
About Enable Technology Solihull SQL Server Analysis Services Training Courses
We are company which specialises in short, two and three day intensive SQL Server Analysis Services technology training courses. All Enable Technology tutors are Microsoft certified experts. Each course participant will be issued with training SQL Server Analysis Services resources which they can continue to use after the training. We offer a post training support service and delegates will have access to a Microsoft expert on SQL Server Analysis Services for as long as they need.
Enable Technology offers instructor led training taught by technology specialists. We can bring the equipment necessary to deliver SQL Server Analysis Services courses at your site. If you prefer we can offer an offsite socially distanced training location in Solihull. All SQL Server Analysis Services courses can be customised to meet your particular requirements.
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.
We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: Queen's Medical Centre Nottingham, South Staffordshire Water PLC, Cadbury PLC, EDF Energy PLC, Nuclear Engineering Services, Loughborough University, Lloyds TSB Bank PLC and Barclays Bank PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Solihull
- 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 ... Use Aggregate Functions
- See Training Course Details...
Delete a Data Source View Dimensions
Move an Analysis Services Database
Deploy Model Solutions with the Deployment Utility
Define Named Calculations in a Data Source View
Create a Data Source
Use a Template to Create an Action Deployment
Edit or Delete Partitions Merge Partitions
Dimension permissions
Create a Dimension by Generating a Non-Time Table in the Data Source
Attach and Detach Analysis Services Databases
Defined Linked Measure Groups Partitions
Calculations using the Business Intelligence Wizard
Test an Action
Create an Analysis Services Project
Create Measures and Measure Groups
Define Logical Relationships in a Data Source View
Deploy Analysis Services Projects
Backup Options Restore Options
Authorizing access to objects and operations
Define Assignments and Other Script Commands
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Solihull
- 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 ... Enable DirectQuery mode in SSMS
- See Training Course Details...
Understanding DAX in Tabular Models Measures
Set the Data Type of a Column
Add columns to a table
Data types supported
Analyze in Excel
Sort Data in a Table
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Data sources supported in tabular 1400 models
Rename a Table or Column
Filter Data in a Table Relationships
Import from Power View
Data sources supported in tabular 1200 models
Hide or freeze columns
Import from Power Pivot
Test a model in DirectQuery mode
Version comparison
Process Database, Table, or Partition
Database Process Partitions in the Workspace Database Perspectives
Define partitions in DirectQuery models
Email us about this courses
Other Solihull Enable Technology Training Courses
Access VBA Solihull Training Courses
VBA Solihull Training Courses
Excel 365 Intermediate - Solihull Excel Training Courses
Report Builder - Solihull SQL Server Reporting Services Training Courses
DAX Solihull Training Courses
Power BI Solihull Training Courses