SQL SERVER ANALYSIS SERVICES TRAINING COURSES SOUTHPORT
About Enable Technology Southport SQL Server Analysis Services Training Courses
Enable Technology offer short intensive skills based SQL Server Analysis Services training courses. The training will be delivered by a Microsoft professional with development experience. We provide every candidate with SQL Server Analysis Services training materials which they keep after the course. Enable Technology offer post course help to all delegates. Participants on the SQL Server Analysis Services course can contact the tutor for as long as they like if they encounter SQL Server Analysis Services problems.
Enable Technology offers instructor led training taught by technology specialists. We are set up to deliver SQL Server Analysis Services training courses onsite at your premises. If you prefer we can offer an offsite training location in Southport. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services training needs.
We also deliver this course online through virtual classrooms. Delegates can join scheduled SQL Server Analysis Services classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Total Telecommunications Limited, Carillion PLC, Birmingham City Council, Birmingham City University, Canadian High Commission, University of Birmingham, Dollond & Aitchison Limited and South Staffordshire Water PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Southport
- 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...
Backup Options Restore Options
Configure Analysis Services Project Properties
Batch Processing Remote Processing
Create a Dimension Using the Dimension Wizard
Rename a Multidimensional Database Processing a multidimensional model
Set Partition Storage
KPIs Actions
Deployment Requirements and Considerations for Analysis Services Deployment
Defined Linked Measure Groups Partitions
Attach and Detach Analysis Services Databases
Create Measures and Measure Groups
Partition Writeback Calculations
Define a Referenced Relationship and Referenced Relationship Properties
Processing Databases, Dimensions and Partitions
Use Aggregate Functions
Calculations using the Business Intelligence Wizard
Modify or Delete an Analysis Services Database
Create Local Partitions
Define Logical Relationships in a Data Source View
Create Remote Partitions
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Southport
- 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 ... Change table, column
- See Training Course Details...
Tabular model designer
Delete a Column
DAX formula compatibility in DirectQuery mode Tables and Columns
Create a Calculated Table
Data sources supported in SSAS tabular 2017
Topics include- Overview of SSAS Tabular models
Create and Manage Tabular Model Partitions
Create a Relationship Between Two Tables
Row filter mappings
Filter Data in a Table Relationships
Connect to a tabular model database
Impersonation
Understanding DAX in Tabular Models Measures
Create and Manage Hierarchies Partitions
Data sources supported in tabular 1400 models
Test a model in DirectQuery mode
Import Data
Analyze a tabular model in Excel Deploy tabular model solutions
Create and Manage Partitions in the Workspace
Email us about this courses
Other Southport Enable Technology Training Courses
DAX Southport Training Courses
SQL - Southport SQL Training Courses
Data Warehouse - Southport SQL Training Courses
Oracle SQL Southport Training Courses
Power BI Southport Training Courses
TSQL - Southport SQL Training Courses