SQL SERVER ANALYSIS SERVICES TRAINING COURSES FARNWORTH
About Enable Technology Farnworth SQL Server Analysis Services Training Courses
We offer intensive two and three days SQL Server Analysis Services courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Each course participant will be issued with training SQL Server Analysis Services resources which they can continue to use 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.
We provide instructor led training coupled with hands on training. We are set up to deliver SQL Server Analysis Services training courses onsite at your premises. If delivery onsite is an issue we will organise a socially distanced venue near you in Farnworth. Every SQL Server Analysis Services course can be modified to meet your bespoke requirements.
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 have operated primarily in the West Midlands for twenty years. Some of our clients are Homeserve PLC, Cadbury PLC, DHL Express, Total Telecommunications Limited, Fujistu PLC, Canadian High Commission, Dollond & Aitchison Limited and Royal Air Force.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Farnworth
- 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 ... Import data by using a native query
- See Training Course Details...
Impersonation
Import from Analysis Services
Create and Manage Measures KPIs
Delete a Column
Add a table Delete a Table
Bi-directional cross filters Calculations
Understanding DAX in Tabular Models Measures
Set the Data Type of a Column
Tabular model designer
Process Tabular Model Partitions
Database Process Partitions in the Workspace Database Perspectives
Define partitions in DirectQuery models
Data types supported
Data sources supported in tabular 1200 models
Restore from Power Pivot
Create a Relationship Between Two Tables
DAX formula compatibility in DirectQuery mode Tables and Columns
Specify Mark as Date Table for use with Time Intelligence
Create a New Tabular Model Project
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Farnworth
- 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 ... Calculations using the Business Intelligence Wizard
- See Training Course Details...
Define Assignments and Other Script Commands
Ragged Hierarchies
Create an Analysis Services Project
Create a Time Dimension by Generating a Time Table
Create Local Partitions
Multidimensional models
Create Measures and Measure Groups
Create a Dimension by Generating a Non-Time Table in the Data Source
Create a Dimension Using the Dimension Wizard
Processing Options and Settings
Define Time Intelligence
Configure Measure Group Properties
Modify or Delete in Solution Explorer Database Dimensions
Use a Template to Create an Action Deployment
Define a Data Source View
Rename a Multidimensional Database Processing a multidimensional model
Define Logical Relationships in a Data Source View
Set Partition Storage
Set Data Source Properties
Create Remote Partitions
Email us about this courses
Other Farnworth Enable Technology Training Courses
SSIS - Farnworth SQL Server Integration Services Training Courses
Excel Power Pivot Farnworth Training Courses
TSQL - Farnworth SQL Training Courses
JQuery Mobile - Farnworth JavaScript Training Courses
DAX - Farnworth Excel Training Courses
Power Query Farnworth Training Courses