SQL SERVER ANALYSIS SERVICES TRAINING COURSES NEWCASTLE UNDER LYME
About Enable Technology Newcastle Under Lyme SQL Server Analysis Services Training Courses
Enable Technology provides practical SQL Server Analysis Services skills based technology training. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. We provide every candidate with SQL Server Analysis Services training materials which they keep after the course. If delegates have have questions about SQL Server Analysis Services after the course they are welcome to contact the course Tutor. This post training support is ongoing.
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. We can deliver at your premises. We can provide the equipment. Another option is we can organise a local training site in Newcastle Under Lyme. We will work with you prior to the course to tailor the SQL Server Analysis Services syllabus to match your requirements.
SQL Server Analysis Services courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Norfolk Police Constabulary, National Power PLC, Birmingham City Council, Yell Group PLC, Nationwide Building Society Limited, DHL Express, Countrywide Homes Limited and Capita Group PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Newcastle Under Lyme
- 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 ... Understanding DAX in Tabular Models Measures
- See Training Course Details...
Create and Manage Tabular Model Partitions
Add sample data to DirectQuery models
Import from Power View
Create and Manage Measures KPIs
Create and Manage Roles
Data sources supported in tabular 1200 models
Row filter mappings
Process Tabular Model Partitions
Create and Manage Partitions in the Workspace
Add a table Delete a Table
Create a New Tabular Model Project
Sort Data in a Table
Add columns to a table
Connect to a tabular model database
Delete Relationships
Topics include- Overview of SSAS Tabular models
DAX formula compatibility in DirectQuery mode Tables and Columns
Import data by using a native query
Define partitions in DirectQuery models
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Newcastle Under Lyme
- 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 ... Define a Referenced Relationship and Referenced Relationship Properties
- See Training Course Details...
Modify or Delete in Solution Explorer Database Dimensions
Backup Options Restore Options
Create a Dimension by Generating a Non-Time Table in the Data Source
Batch Processing Remote Processing
Deploy Model Solutions Using XMLA
Processing Databases, Dimensions and Partitions
Data Source Views
Create Measures and Measure Groups
Change a Partition Source
Defined Linked Measure Groups Partitions
Define a Data Source View
Database permissions
Use a Template to Create an Action Deployment
Create Remote Partitions
Create a Data Source
Define Named Queries in a Data Source View
KPIs Actions
Deploy Model Solutions Using the Deployment Wizard
Processing Options and Settings
Error Configuration Roles and Permissions
Email us about this courses
Other Newcastle Under Lyme Enable Technology Training Courses
JavaScript - Newcastle Under Lyme JavaScript Training Courses
SSIS Newcastle Under Lyme Training Courses
Access - Newcastle Under Lyme Access Training Courses
Excel Power Pivot Newcastle Under Lyme Training Courses
PL/SQL - Newcastle Under Lyme SQL Training Courses
Power BI - Newcastle Under Lyme Microsoft Power BI Training Courses