SQL SERVER ANALYSIS SERVICES TRAINING COURSES RUNCORN
About Enable Technology Runcorn SQL Server Analysis Services Training Courses
Enable Technology provides practical SQL Server Analysis Services skills based technology training. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. All course participants are issued SQL Server Analysis Services training manuals they can refer to after the course. Course participants are welcome contact the Tutor after the course with specific SQL Server Analysis Services queries. This support is open ended.
Enable Technology SQL Server Analysis Services courses are instructor led and taught by an experienced Microsoft expert. Enable Technology can supply all of the equipment necessary to deliver SQL Server Analysis Services courses onsite at your offices. You simply need to provide a suitable room. We can also deliver the SQL Server Analysis Services course at a local training venue in Runcorn. Every SQL Server Analysis Services course can be modified to meet your bespoke 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.
In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: EDF Energy PLC, Barclays Bank PLC, Aston University, West Bromwich Building Society, Wolverhampton City Council, Norfolk Police Constabulary, DHL Express and University of Birmingham.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Runcorn
- 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 ... DAX formula compatibility in DirectQuery mode Tables and Columns
- See Training Course Details...
Import from Power Pivot
Delete a Column
Create and Manage Tabular Model Partitions
Data sources supported in tabular 1200 models
Connect to a tabular model database
Sort Data in a Table
Add a table Delete a Table
Topics include- Overview of SSAS Tabular models
Test a model in DirectQuery mode
Enable DirectQuery mode in SSDT
Delete Relationships
Import Data
Change table, column
Analyze a tabular model in Excel Deploy tabular model solutions
Create and Manage Measures KPIs
Rename a Table or Column
Define partitions in DirectQuery models
Tabular model designer
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Runcorn
- 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 ... Backup Options Restore Options
- See Training Course Details...
Modify or Delete in Solution Explorer Database Dimensions
Defined Linked Measure Groups Partitions
Define a Referenced Relationship and Referenced Relationship Properties
Create a Dimension by Using an Existing Table
Deploy Model Solutions Using the Deployment Wizard
Deploy Model Solutions Using XMLA
Overview of SSAS Multidimensional Modelling
Delete a Data Source View Dimensions
Ragged Hierarchies
Delete a Data Source
Configure Measure Group Properties
Read Definition permissions
Explore Data in a Data Source View
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Authorizing access to objects and operations
Batch Processing Remote Processing
Define a Regular Relationship and Regular Relationship Properties
Edit or Delete Partitions Merge Partitions
Define a Fact Relationship and Fact Relationship Properties
Create a Data Source
Email us about this courses
Other Runcorn Enable Technology Training Courses
TSQL - Runcorn SQL Training Courses
Excel 365 Intermediate - Runcorn Excel Training Courses
Power BI Runcorn Training Courses
PL/SQL - Runcorn SQL Training Courses
JavaScript - Runcorn JavaScript Training Courses
Excel 365 Advanced - Runcorn Excel Training Courses