SQL SERVER ANALYSIS SERVICES TRAINING COURSES CWMBRAN
About Enable Technology Cwmbran SQL Server Analysis Services Training Courses
Enable Technology specialise in succinct skills based SQL Server Analysis Services training. The course will always be taught by a Microsoft Certified Professional (MCP). All candidates receive comprehensive SQL Server Analysis Services training materials and practice files which are theirs to refer to after the course. We offer a post training support service and delegates will have access to a Microsoft expert on SQL Server Analysis Services for as long as they need.
SQL Server Analysis Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology can provide SQL Server Analysis Services courses onsite at your location. We will bring the necessary laptops with the required software installed. Alternatively we could schedule a course at a local venue in Cwmbran. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite SQL Server Analysis Services course to some extent is bespoke and tailored to your needs.
We can also deliver SQL Server Analysis Services courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are West Bromwich Building Society, Fujistu PLC, GKN PLC, Vodafone Group Services, Aston University, Yell Group PLC, Homeserve PLC and Keele University.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Cwmbran
- 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 Regular Relationship and Regular Relationship Properties
- See Training Course Details...
Configure Measure Group Properties
Delete a Data Source
Document and Script an Analysis Services Database
Define a Fact Relationship and Fact Relationship Properties
Set Impersonation Options for a Data Source Connection
Modify or Delete an Analysis Services Database
Partition Writeback Calculations
Designing Aggregations
Define a Data Source View
BI Wizard
Edit or Delete Partitions Merge Partitions
Set Data Source Properties
Tools and Approaches for Processing
Deploy Model Solutions Using XMLA
Explore Data in a Data Source View
Create Local Partitions
Create Remote Partitions
Define Semiadditive Behavior
Define a Referenced Relationship and Referenced Relationship Properties
Dimension permissions
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Cwmbran
- 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 from Power View
- See Training Course Details...
Data sources supported in tabular 1400 models
Data sources supported in tabular 1200 models
Manage Roles by using SSMS
Create and Manage Perspectives Translations Roles
Understanding DAX in Tabular Models Measures
Tabular model designer
Enable DirectQuery mode in SSMS
Data types supported
Import from Power Pivot
Data sources supported in SSAS tabular 2017
Create and Manage Partitions in the Workspace
Create and Manage Measures KPIs
Analyze in Excel
Add sample data to DirectQuery models
Version comparison
Add a table Delete a Table
Restore from Power Pivot
DAX formula compatibility in DirectQuery mode Tables and Columns
Email us about this courses
Other Cwmbran Enable Technology Training Courses
JQuery Mobile - Cwmbran JavaScript Training Courses
VBA - Cwmbran Excel Training Courses
Access Cwmbran Training Courses
SSRS - Cwmbran SQL Server Reporting Services Training Courses
JQuery Cwmbran Training Courses
DAX - Cwmbran Excel Training Courses