SQL SERVER ANALYSIS SERVICES TRAINING COURSES WREXHAM
About Enable Technology Wrexham SQL Server Analysis Services Training Courses
We are a company that provides short intensive SQL Server Analysis Services training courses. The course will always be taught by a Microsoft Certified Professional (MCP). Each course participant will be issued with training SQL Server Analysis Services resources which they can continue to use after the training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Analysis Services queries.
SQL Server Analysis Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. 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 SQL Server Analysis Services course at an alternative training site in Wrexham. 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.
We have operated primarily in the West Midlands for twenty years. Some of our clients are Royal Air Force, Queen's Medical Centre Nottingham, Aston University, Keele University, Lloyds TSB Bank PLC, Nationwide Building Society Limited, Norfolk Police Constabulary and South Staffordshire Water PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Wrexham
- 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
- See Training Course Details...
Enable DirectQuery mode in SSDT
Create a Relationship Between Two Tables
Test a model in DirectQuery mode
Filter Data in a Table Relationships
Rename a Table or Column
Understanding DAX in Tabular Models Measures
Add sample data to DirectQuery models
Enable DirectQuery mode in SSMS
Restore from Power Pivot
Create a New Tabular Model Project
Create a Calculated Table
Create and Manage Measures KPIs
Analyze a tabular model in Excel Deploy tabular model solutions
Define partitions in DirectQuery models
Add a table Delete a Table
Import from Power Pivot
DirectQuery Mode
Create a Calculated Column
Delete a Column
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Wrexham
- 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 ... Overview of SSAS Multidimensional Modelling
- See Training Course Details...
Tools and Approaches for Processing
Defined Linked Measure Groups Partitions
Deploy Model Solutions Using XMLA
Partition Writeback Calculations
Edit or Delete Partitions Merge Partitions
Create Calculated Members
Define Named Queries in a Data Source View
Define a Regular Relationship and Regular Relationship Properties
Deployment Requirements and Considerations for Analysis Services Deployment
Error Configuration Roles and Permissions
Backup and Restore of Analysis Services Databases
Multidimensional models
Using SQL Server Data Tools (SSDT)
Set Partition Storage
Attach and Detach Analysis Services Databases
Define Logical Primary Keys in a Data Source View
Delete a Data Source
Processing Databases, Dimensions and Partitions
Create a Dimension by Using an Existing Table
View the XML for an Analysis Services Project Data Sources
Email us about this courses
Other Wrexham Enable Technology Training Courses
Power BI - Wrexham Microsoft Power BI Training Courses
JQuery Mobile Wrexham Training Courses
Oracle SQL Wrexham Training Courses
DAX - Wrexham Excel Training Courses
PL/SQL Wrexham Training Courses
SSRS Wrexham Training Courses