SQL SERVER ANALYSIS SERVICES TRAINING COURSES LLANTWIT MAJOR
About Enable Technology Llantwit Major SQL Server Analysis Services Training Courses
Enable Technology SQL Server Analysis Services courses are short, skill focused and hands on. 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. Our policy is to provide open ended SQL Server Analysis Services post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
Courses are instructor led and groups sizes small. 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. Another way we could deliver the SQL Server Analysis Services course is at a local training site. We will work with you prior to the course to tailor the SQL Server Analysis Services syllabus to match your 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: TalkTalk Direct Limited, Nuclear Engineering Services, National Power PLC, Birmingham Heartlands Hospital, Carillion PLC, Nationwide Building Society Limited, Halfords Group PLC and Vodafone Group Services.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Llantwit Major
- 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 ... Version comparison
- See Training Course Details...
Object-level security
Import data by using a native query
Data sources supported in tabular 1400 models
Tabular model designer
Create and Manage Partitions in the Workspace
Add sample data to DirectQuery models
Data types supported
Analyze a tabular model in Excel Deploy tabular model solutions
Set the Data Type of a Column
Delete a Column
Data sources supported in tabular 1200 models
DirectQuery Mode
Rename a Table or Column
Process Tabular Model Partitions
Create a Calculated Column
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Import from Analysis Services
Import from Power Pivot
Create and Manage KPIs Hierarchies
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Llantwit Major
- 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 Fact Relationship and Fact Relationship Properties
- See Training Course Details...
Create a Time Dimension by Generating a Time Table
Move an Analysis Services Database
Create a Dimension by Using an Existing Table
Deploy Model Solutions Using XMLA
Create a Dimension Using the Dimension Wizard
Use Aggregate Functions
Document and Script an Analysis Services Database
Create Remote Partitions
Processing Options and Settings
Backup Options Restore Options
Delete a Data Source View Dimensions
Define Named Queries in a Data Source View
Deployment Requirements and Considerations for Analysis Services Deployment
Delete a Data Source
Rename a Multidimensional Database Processing a multidimensional model
Configure Measure Group Properties
Defined Linked Measure Groups Partitions
Add a Standard Action
Multidimensional models
Work with Diagrams in Data Source View Designer
Email us about this courses
Other Llantwit Major Enable Technology Training Courses
JQuery - Llantwit Major JavaScript Training Courses
JQuery Mobile Llantwit Major Training Courses
DAX Llantwit Major Training Courses
JavaScript - Llantwit Major JavaScript Training Courses
SSIS Llantwit Major Training Courses
Oracle SQL - Llantwit Major SQL Training Courses