SQL SERVER ANALYSIS SERVICES TRAINING COURSES TAMWORTH
About Enable Technology Tamworth SQL Server Analysis Services Training Courses
We are a company that provides short intensive SQL Server Analysis Services training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Analysis Services queries.
Courses are instructor led and groups sizes small. We can set up a training lab at your premises and deliver SQL Server Analysis Services courses onsite at your site. Alternatively we could schedule a course at a local socially distanced venue in Tamworth. We offer the option of working with you to develop a bespoke SQL Server Analysis Services programme which precisely matches your organisations training requirements.
SQL Server Analysis Services courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Yell Group PLC, Wolverhampton City Council, Shell UK Oil Products Ltd, Loughborough University, Total Telecommunications Limited, Dollond & Aitchison Limited, Birmingham City University and Homeserve PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Tamworth
- 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 Logical Primary Keys in a Data Source View
- See Training Course Details...
Configure Measure Group Properties
Deploy Analysis Services Projects
Using SQL Server Data Tools (SSDT)
Authorizing access to objects and operations
Delete a Data Source View Dimensions
Create Calculated Members
Ragged Hierarchies
Define a Referenced Relationship and Referenced Relationship Properties
Create User-Defined Hierarchies
Define Named Calculations in a Data Source View
Replace a Table or a Named Query in a Data Source View
Define a Regular Relationship and Regular Relationship Properties
Attach and Detach Analysis Services Databases
Database permissions
Error Configuration Roles and Permissions
KPIs Actions
Calculations using the Business Intelligence Wizard
Multidimensional models
Deployment Requirements and Considerations for Analysis Services Deployment
Dimension permissions
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Tamworth
- 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 ... Restore from Power Pivot
- See Training Course Details...
Create and Manage Tabular Model Partitions
Create and Manage Hierarchies Partitions
Change table, column
Test a model in DirectQuery mode
Analyze a tabular model in Excel Deploy tabular model solutions
Create and Manage KPIs Hierarchies
Define partitions in DirectQuery models
Add a table Delete a Table
Create and Manage Measures KPIs
Set the Data Type of a Column
Tabular model designer
Hide or freeze columns
Version comparison
Create a Relationship Between Two Tables
Rename a Table or Column
Sort Data in a Table
DirectQuery Mode
Database Process Partitions in the Workspace Database Perspectives
Create a New Tabular Model Project
Impersonation
Email us about this courses
Other Tamworth Enable Technology Training Courses
Report Builder - Tamworth SQL Server Reporting Services Training Courses
SSRS Tamworth Training Courses
Oracle SQL Tamworth Training Courses
Power BI - Tamworth Microsoft Power BI Training Courses
Excel 365 Basic - Tamworth Excel Training Courses
Excel 365 Intermediate Tamworth Training Courses