SQL SERVER ANALYSIS SERVICES TRAINING COURSES GWENT
About Enable Technology Gwent SQL Server Analysis Services Training Courses
We offer intensive two and three days SQL Server Analysis Services courses. All of our tutors are Microsoft Certified Professionals. Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source 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.
We provide instructor led training coupled with hands on training. Enable Technology SQL Server Analysis Services courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. The SQL Server Analysis Services course could also be scheduled at a socially distanced site near you in Gwent. We will work with you prior to the course to tailor the SQL Server Analysis Services syllabus to match your requirements.
SQL Server Analysis Services courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
Our teaching team have over twenty years continuous technical training experience. Our clients include: GKN PLC, Shell UK Oil Products Ltd, TalkTalk Direct Limited, Capita Group PLC, Birmingham City University, Nuclear Engineering Services, Boots UK Limited and University of Birmingham.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Gwent
- 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 ... Understanding DAX in Tabular Models Measures
- See Training Course Details...
Set the Data Type of a Column
Rename a Table or Column
Database Process Partitions in the Workspace Database Perspectives
DAX formula compatibility in DirectQuery mode Tables and Columns
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Hide or freeze columns
Change table, column
Create and Manage Tabular Model Partitions
Enable DirectQuery mode in SSDT
Test a model in DirectQuery mode
Create and Manage Perspectives Translations Roles
Data sources supported in tabular 1400 models
Bi-directional cross filters Calculations
Add sample data to DirectQuery models
Import from Power Pivot
Delete a Column
Manage Roles by using SSMS
Specify Mark as Date Table for use with Time Intelligence
Row filter mappings
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Gwent
- 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 ... Configure Measure Group Properties
- See Training Course Details...
Create a Dimension by Generating a Non-Time Table in the Data Source
Create Calculated Members
Use a Template to Create an Action Deployment
Processing Databases, Dimensions and Partitions
Define a Fact Relationship and Fact Relationship Properties
Multidimensional models
Define a Regular Relationship and Regular Relationship Properties
Create Remote Partitions
Replace a Table or a Named Query in a Data Source View
Set Impersonation Options for a Data Source Connection
Delete a Data Source
Add or Remove Tables or Views in a Data Source View
Calculations using the Business Intelligence Wizard
Edit or Delete Partitions Merge Partitions
Rename a Multidimensional Database Processing a multidimensional model
Define Logical Relationships in a Data Source View
Tools and Approaches for Processing
Define Assignments and Other Script Commands
Document and Script an Analysis Services Database
Data Source object permissions
Email us about this courses
Other Gwent Enable Technology Training Courses
VBA Gwent Training Courses
Excel Power Pivot Gwent Training Courses
Power BI Gwent Training Courses
JavaScript Gwent Training Courses
Report Builder - Gwent SQL Server Reporting Services Training Courses
Oracle SQL - Gwent SQL Training Courses