SQL SERVER ANALYSIS SERVICES TRAINING COURSES AMMANFORD
About Enable Technology Ammanford SQL Server Analysis Services Training Courses
We are a company that provides short intensive SQL Server Analysis Services training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Each person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials after the training. We also provide an ongoing support service to people attending our SQL Server Analysis Services courses. Delegates can contact the course tutor with specific SQL Server Analysis Services questions for as long as they need following the course.
Enable Technology offers instructor led training taught by technology specialists. Enable Technology can supply all of the equipment necessary to deliver SQL Server Analysis Services courses onsite at your offices. You simply need to provide a suitable room. Alternatively we could schedule a SQL Server Analysis Services course at an alternative training site in Ammanford. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services training needs.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: DHL Express, Royal & Sun Alliance Group PLC, Boots UK Limited, Yell Group PLC, Dollond & Aitchison Limited, Loughborough University, TalkTalk Direct Limited and Fujistu PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Ammanford
- 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 ... Process Database, Table, or Partition
- See Training Course Details...
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Analyze a tabular model in Excel Deploy tabular model solutions
Test a model in DirectQuery mode
Add columns to a table
Tabular model designer
Delete Relationships
Change table, column
DirectQuery Mode
Rename a Table or Column
Connect to a tabular model database
Import from Power View
Create and Manage KPIs Hierarchies
Hide or freeze columns
Import from Power Pivot
Import data by using a native query
Create a Relationship Between Two Tables
Create a New Tabular Model Project
Analyze in Excel
Create a Calculated Table
Create and Manage Measures KPIs
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Ammanford
- 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...
Modify or Delete an Analysis Services Database
Define Time Intelligence
Overview of SSAS Multidimensional Modelling
Define Named Calculations in a Data Source View
Define Assignments and Other Script Commands
Rename a Multidimensional Database Processing a multidimensional model
Edit or Delete Partitions Merge Partitions
Configure Analysis Services Project Properties
Set Data Source Properties
Multidimensional models
Configure Measure Group Properties
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Define a Fact Relationship and Fact Relationship Properties
Add or Remove Tables or Views in a Data Source View
Create a Time Dimension by Generating a Time Table
Define Logical Relationships in a Data Source View
Create Local Partitions
Create Named Sets
Create Measures and Measure Groups
Create a Dimension by Using an Existing Table
Email us about this courses
Other Ammanford Enable Technology Training Courses
JQuery Mobile Ammanford Training Courses
Power BI Ammanford Training Courses
Oracle SQL - Ammanford SQL Training Courses
TSQL - Ammanford SQL Training Courses
SSIS - Ammanford SQL Server Integration Services Training Courses
Access - Ammanford Access Training Courses