SQL SERVER ANALYSIS SERVICES TRAINING COURSES ROTHERHAM
About Enable Technology Rotherham SQL Server Analysis Services Training Courses
Enable Technology has twenty year track record of providing short intensive SQL Server Analysis Services skills based training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every course participant will receives course practice files and SQL Server Analysis Services course resources that can be referenced post training. Our policy is to provide open ended SQL Server Analysis Services post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
Enable Technology training courses are delivered as instructor led courses. Our SQL Server Analysis Services training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Alternatively we could schedule a course at a local socially distanced venue in Rotherham. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Fujistu PLC, Royal Air Force, Norwich Union PLC, Queen's Medical Centre Nottingham, National Power PLC, Birmingham City University, Aston University and Birmingham City Council.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Rotherham
- 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 Time Dimension by Generating a Time Table
Authorizing access to objects and operations
Create Remote Partitions
Batch Processing Remote Processing
View the XML for an Analysis Services Project Data Sources
Replace a Table or a Named Query in a Data Source View
Set Impersonation Options for a Data Source Connection
BI Wizard
Define a Data Source View
Calculations using the Business Intelligence Wizard
Define Logical Primary Keys in a Data Source View
Using SQL Server Data Tools (SSDT)
Define a Fact Relationship and Fact Relationship Properties
Define a Regular Relationship and Regular Relationship Properties
Define Named Calculations in a Data Source View
Document and Script an Analysis Services Database
Delete a Data Source
Error Configuration Roles and Permissions
Tools and Approaches for Processing
Backup and Restore of Analysis Services Databases
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Rotherham
- 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 sample data to DirectQuery models
- See Training Course Details...
DAX formula compatibility in DirectQuery mode Tables and Columns
Specify Mark as Date Table for use with Time Intelligence
Create and Manage Measures KPIs
Create and Manage KPIs Hierarchies
Tabular model designer
Create and Manage Tabular Model Partitions
Hide or freeze columns
Manage Roles by using SSMS
Create a Calculated Table
Process Tabular Model Partitions
Row filter mappings
Understanding DAX in Tabular Models Measures
Import from Power View
Connect to a tabular model database
Analyze a tabular model in Excel Deploy tabular model solutions
Data sources supported in tabular 1400 models
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Create a Relationship Between Two Tables
Email us about this courses
Other Rotherham Enable Technology Training Courses
Report Builder - Rotherham SQL Server Reporting Services Training Courses
SQL - Rotherham SQL Training Courses
VBA Rotherham Training Courses
Power BI - Rotherham Microsoft Power BI Training Courses
Excel 365 Basic - Rotherham Excel Training Courses
JQuery Rotherham Training Courses