SQL SERVER ANALYSIS SERVICES TRAINING COURSES ACCRINGTON
About Enable Technology Accrington 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. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. We provide every candidate with SQL Server Analysis Services training materials which they keep after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Analysis Services queries.
We provide instructor led training coupled with hands on training. 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. We also offer the option of scheduling of SQL Server Analysis Services course at a venue near you in Accrington. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services training 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.
In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Norwich Union PLC, Unipart Group, EDF Energy PLC, National Power PLC, Barclays Bank PLC, Cadbury PLC, Birmingham City Council and Yell Group PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Accrington
- 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 ... Calculations using the Business Intelligence Wizard
- See Training Course Details...
Data Source Views
Define Logical Relationships in a Data Source View
Processing Options and Settings
Multidimensional models
Create a Data Source
Defined Linked Measure Groups Partitions
Define a Fact Relationship and Fact Relationship Properties
Configure Measure Group Properties
Delete a Data Source View Dimensions
Overview of SSAS Multidimensional Modelling
Define Named Calculations in a Data Source View
Partition Writeback Calculations
Set Partition Storage
Create Calculated Members
Processing Databases, Dimensions and Partitions
Create a Dimension by Using an Existing Table
Read Definition permissions
Define Assignments and Other Script Commands
View the XML for an Analysis Services Project Data Sources
Define Semiadditive Behavior
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Accrington
- 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 ... Rename a Table or Column
- See Training Course Details...
Enable DirectQuery mode in SSMS
Create and Manage Tabular Model Partitions
DAX formula compatibility in DirectQuery mode Tables and Columns
Analyze a tabular model in Excel Deploy tabular model solutions
Create and Manage Partitions in the Workspace
Process Database, Table, or Partition
Manage Roles by using SSMS
Add a table Delete a Table
Data sources supported in SSAS tabular 2017
Add columns to a table
Sort Data in a Table
Set the Data Type of a Column
Version comparison
Import from Analysis Services
Row filter mappings
Object-level security
DirectQuery Mode
Import from Power View
Hide or freeze columns
Email us about this courses
Other Accrington Enable Technology Training Courses
Data Warehouse - Accrington SQL Training Courses
Access Accrington Training Courses
JQuery Accrington Training Courses
Excel 365 Basic - Accrington Excel Training Courses
Excel 365 Advanced - Accrington Excel Training Courses
DAX - Accrington Excel Training Courses