SQL SERVER ANALYSIS SERVICES TRAINING COURSES NEWPORT
About Enable Technology Newport SQL Server Analysis Services Training Courses
We are a company that provides short intensive SQL Server Analysis Services training 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. Enable Technology offer post course help to all delegates. Participants on the SQL Server Analysis Services course can contact the tutor for as long as they like if they encounter SQL Server Analysis Services problems.
Delegates are taught by an experienced Microsoft professional. SQL Server Analysis Services courses are delivered through a mix of practical hands on exercises and walk throughs. Enable Technology SQL Server Analysis Services training courses can be delivered at your offices. We can supply the necessary software and computers. We are also more than happy to organise a local course at a training location in Newport. All SQL Server Analysis Services courses can be customised to meet your particular requirements.
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 Wolverhampton City Council, Norfolk Police Constabulary, Barclays Bank PLC, TalkTalk Direct Limited, Fujistu PLC, University of Birmingham, Yell Group PLC and Birmingham Heartlands Hospital.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Newport
- 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 ... Add a table Delete a Table
- See Training Course Details...
Delete Relationships
Tabular model designer
Create and Manage KPIs Hierarchies
Define partitions in DirectQuery models
Import from Power View
Topics include- Overview of SSAS Tabular models
Create and Manage Tabular Model Partitions
Filter Data in a Table Relationships
Understanding DAX in Tabular Models Measures
Connect to a tabular model database
Create and Manage Roles
Data sources supported in tabular 1200 models
Data types supported
DAX formula compatibility in DirectQuery mode Tables and Columns
Add columns to a table
Create a Calculated Column
Object-level security
Set the Data Type of a Column
Manage Roles by using SSMS
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Newport
- 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 ... Deploy Model Solutions with the Deployment Utility
- See Training Course Details...
Create Local Partitions
Deployment Requirements and Considerations for Analysis Services Deployment
Add or Remove Tables or Views in a Data Source View
Designing Aggregations
Document and Script an Analysis Services Database
Processing Options and Settings
Set Data Source Properties
Create Calculated Members
Dimension permissions
Define a Regular Relationship and Regular Relationship Properties
Partition Writeback Calculations
Use a Template to Create an Action Deployment
Define Named Queries in a Data Source View
Replace a Table or a Named Query in a Data Source View
Modify or Delete in Solution Explorer Database Dimensions
Create a Dimension by Generating a Non-Time Table in the Data Source
Create a Data Source
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Work with Diagrams in Data Source View Designer
Supported Data Sources
Email us about this courses
Other Newport Enable Technology Training Courses
TSQL - Newport SQL Training Courses
Excel 365 Basic - Newport Excel Training Courses
Report Builder Newport Training Courses
VBA Newport Training Courses
Access - Newport Access Training Courses
Excel 365 Advanced Newport Training Courses