SQL SERVER ANALYSIS SERVICES TRAINING COURSES COLWYN BAY
About Enable Technology Colwyn Bay 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 Professionals. Every course participant will receives course practice files and SQL Server Analysis Services course resources that can be referenced post training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Analysis Services queries.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. 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. We also offer the option of scheduling of SQL Server Analysis Services course at a venue near you in Colwyn Bay. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.
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.
We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: University of Birmingham, Birmingham City University, Cadbury PLC, Vodafone Group Services, Unipart Group, Dollond & Aitchison Limited, Shell UK Oil Products Ltd and Fujistu PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Colwyn Bay
- 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 ... Use Aggregate Functions
- See Training Course Details...
Add or Remove Tables or Views in a Data Source View
Define Named Queries in a Data Source View
Deploy Analysis Services Projects
Replace a Table or a Named Query in a Data Source View
Backup and Restore of Analysis Services Databases
Deployment Requirements and Considerations for Analysis Services Deployment
Define Assignments and Other Script Commands
Configure Measure Group Properties
Read Definition permissions
Define Logical Relationships in a Data Source View
Test an Action
Ragged Hierarchies
Defined Linked Measure Groups Partitions
Create Named Sets
Create a Dimension by Generating a Non-Time Table in the Data Source
Explore Data in a Data Source View
Database permissions
Create a Data Source
Modify or Delete an Analysis Services Database
Dimension permissions
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Colwyn Bay
- 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 ... Delete a Column
- See Training Course Details...
Delete Relationships
Import data by using a native query
Connect to a tabular model database
Understanding DAX in Tabular Models Measures
Create and Manage Tabular Model Partitions
Create and Manage Roles
Analyze a tabular model in Excel Deploy tabular model solutions
Create and Manage KPIs Hierarchies
Object-level security
Create and Manage Perspectives Translations Roles
Database Process Partitions in the Workspace Database Perspectives
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Hide or freeze columns
Bi-directional cross filters Calculations
Row filter mappings
Add sample data to DirectQuery models
Topics include- Overview of SSAS Tabular models
Process Tabular Model Partitions
DirectQuery Mode
Email us about this courses
Other Colwyn Bay Enable Technology Training Courses
JQuery Mobile - Colwyn Bay JavaScript Training Courses
JQuery Colwyn Bay Training Courses
Data Warehouse Colwyn Bay Training Courses
Power Query - Colwyn Bay Excel Training Courses
SQL Colwyn Bay Training Courses
Report Builder - Colwyn Bay SQL Server Reporting Services Training Courses