SQL SERVER ANALYSIS SERVICES TRAINING COURSES BROMSGROVE
About Enable Technology Bromsgrove 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 Solutions Experts with development backgrounds. Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source after the course. We also provide an ongoing support service to people attending our SQL Server Analysis Services courses. Delegates can contact the course tutor with specific SQL Server Analysis Services questions for as long as they need following the course.
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. We are set up to deliver SQL Server Analysis Services training courses onsite at your premises. If delivery onsite is an issue we will organise a socially distanced venue near you in Bromsgrove. 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.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled SQL Server Analysis Services course, watch the tutor demonstrate tasks, ask questions and share their own screen.
We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Loughborough University, Fujistu PLC, Homeserve PLC, Boots UK Limited, Vodafone Group Services, Aston University, Carillion PLC and University of Birmingham.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Bromsgrove
- 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...
Create and Manage Hierarchies Partitions
Object-level security
Delete Relationships
Import from Power Pivot
Specify Mark as Date Table for use with Time Intelligence
Change table, column
Restore from Power Pivot
Define partitions in DirectQuery models
Data types supported
Import Data
Analyze a tabular model in Excel Deploy tabular model solutions
Delete a Column
Create and Manage Perspectives Translations Roles
Process Database, Table, or Partition
Row filter mappings
Create and Manage Measures KPIs
Data sources supported in tabular 1400 models
Connect to a tabular model database
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Bromsgrove
- 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 ... Attach and Detach Analysis Services Databases
- See Training Course Details...
Create an Analysis Services Project
Define Named Calculations in a Data Source View
Set Data Source Properties
Backup and Restore of Analysis Services Databases
Change a Partition Source
Create Remote Partitions
Authorizing access to objects and operations
Create a Dimension Using the Dimension Wizard
Database permissions
Supported Data Sources
Create Measures and Measure Groups
Create a Time Dimension by Generating a Time Table
Create Local Partitions
Calculations using the Business Intelligence Wizard
Configure Measure Group Properties
Data Source object permissions
Create Calculated Members
Define Attribute Relationships
Defined Linked Measure Groups Partitions
Define a Data Source View
Email us about this courses
Other Bromsgrove Enable Technology Training Courses
SQL - Bromsgrove SQL Training Courses
Access VBA Bromsgrove Training Courses
JavaScript Bromsgrove Training Courses
Access Bromsgrove Training Courses
Power BI - Bromsgrove Microsoft Power BI Training Courses
TSQL Bromsgrove Training Courses