SQL SERVER ANALYSIS SERVICES TRAINING COURSES LEICESTERSHIRE
About Enable Technology Leicestershire SQL Server Analysis Services Training Courses
Enable Technology SQL Server Analysis Services courses are short, skill focused and hands on. All Enable Technology tutors are Microsoft certified experts. Each person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials after the training. If delegates have have questions about SQL Server Analysis Services after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Enable Technology training courses are delivered as instructor led courses. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Analysis Services onsite. If you prefer we can offer an offsite socially distanced training location in Leicestershire. We are happy to modify the SQL Server Analysis Services syllabus to match your teams training requirements.
This instructor led SQL Server Analysis Services training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Birmingham City University, GKN PLC, Royal & Sun Alliance Group PLC, Canadian High Commission, Wolverhampton City Council, Royal Air Force, Yell Group PLC and DHL Express.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Leicestershire
- 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 data by using a native query
- See Training Course Details...
Import Data
Process Database, Table, or Partition
Row filter mappings
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Impersonation
DirectQuery Mode
Bi-directional cross filters Calculations
Rename a Table or Column
Data sources supported in SSAS tabular 2017
Connect to a tabular model database
Manage Roles by using SSMS
Create and Manage Measures KPIs
Process Tabular Model Partitions
Create and Manage KPIs Hierarchies
Add sample data to DirectQuery models
Data sources supported in tabular 1200 models
Tabular model designer
Test a model in DirectQuery mode
Understanding DAX in Tabular Models Measures
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Leicestershire
- 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 Fact Relationship and Fact Relationship Properties
- See Training Course Details...
Define a Data Source View
Database permissions
Processing Options and Settings
Work with Diagrams in Data Source View Designer
Multidimensional models
Explore Data in a Data Source View
Define Named Queries in a Data Source View
Replace a Table or a Named Query in a Data Source View
View the XML for an Analysis Services Project Data Sources
Change a Partition Source
Delete a Data Source
Backup and Restore of Analysis Services Databases
Deploy Analysis Services Projects
Create a Dimension by Using an Existing Table
Document and Script an Analysis Services Database
Define Time Intelligence
Define Logical Primary Keys in a Data Source View
Ragged Hierarchies
Configure Measure Group Properties
Designing Aggregations
Email us about this courses
Other Leicestershire Enable Technology Training Courses
Excel 365 Basic - Leicestershire Excel Training Courses
Excel 365 Intermediate Leicestershire Training Courses
JQuery - Leicestershire JavaScript Training Courses
Excel 365 Advanced - Leicestershire Excel Training Courses
DAX - Leicestershire Excel Training Courses
Data Warehouse Leicestershire Training Courses