SQL SERVER ANALYSIS SERVICES TRAINING COURSES RUNCORN
About Enable Technology Runcorn SQL Server Analysis Services Training Courses
We have a twenty year history of providing skills based SQL Server Analysis Services industry training. 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. Enable Technology offer post course help to all delegates. Participants on the SQL Server Analysis Services course can contact the tutor for as long as they like if they encounter SQL Server Analysis Services problems.
SQL Server Analysis Services courses are taught by a Microsoft Certified Solutions Expert. Enable Technology SQL Server Analysis Services training courses can be delivered at your offices. We can supply the necessary software and computers. Alternatively we could schedule a course at a local venue in Runcorn. Every SQL Server Analysis Services course can be modified to meet your bespoke requirements.
We can also deliver SQL Server Analysis Services courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are Lloyds TSB Bank PLC, Norwich Union PLC, South Staffordshire Water PLC, Norfolk Police Constabulary, Wolverhampton City Council, Shell UK Oil Products Ltd, Dollond & Aitchison Limited and Cadbury PLC.
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 ... Create Measures and Measure Groups
- See Training Course Details...
Calculations using the Business Intelligence Wizard
Designing Aggregations
Partition Writeback Calculations
Processing Databases, Dimensions and Partitions
BI Wizard
Create Remote Partitions
Create a Time Dimension by Generating a Time Table
Batch Processing Remote Processing
Modify or Delete an Analysis Services Database
Configure Measure Group Properties
Use a Template to Create an Action Deployment
Define Assignments and Other Script Commands
Backup and Restore of Analysis Services Databases
Create Local Partitions
Use Aggregate Functions
Attach and Detach Analysis Services Databases
Set Partition Storage
Overview of SSAS Multidimensional Modelling
Create Calculated Members
Dimension permissions
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 ... Enable DirectQuery mode in SSDT
- See Training Course Details...
Version comparison
Create a Calculated Table
Restore from Power Pivot
Tabular model designer
Create a Relationship Between Two Tables
Data types supported
Database Process Partitions in the Workspace Database Perspectives
Delete a Column
Create and Manage Hierarchies Partitions
Create and Manage Partitions in the Workspace
Process Database, Table, or Partition
Data sources supported in SSAS tabular 2017
Row filter mappings
Import Data
Bi-directional cross filters Calculations
Connect to a tabular model database
Object-level security
Set the Data Type of a Column
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Email us about this courses
Other Runcorn Enable Technology Training Courses
Report Builder - Runcorn SQL Server Reporting Services Training Courses
Power Query - Runcorn Excel Training Courses
SSRS Runcorn Training Courses
PL/SQL Runcorn Training Courses
Excel 365 Advanced - Runcorn Excel Training Courses
Oracle SQL Runcorn Training Courses