SQL SERVER ANALYSIS SERVICES TRAINING COURSES ACCRINGTON
About Enable Technology Accrington SQL Server Analysis Services Training Courses
Enable Technology provides practical SQL Server Analysis Services skills based technology training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source after the course. 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. We are set up to deliver SQL Server Analysis Services training courses onsite at your premises. If you prefer we can offer an offsite socially distanced training location in Accrington. 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.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Capita Group PLC, Halfords Group PLC, Nationwide Building Society Limited, Carillion PLC, Royal Air Force, Yell Group PLC, Birmingham City University and Vodafone Group Services.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Accrington
- 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 ... Specify Mark as Date Table for use with Time Intelligence
- See Training Course Details...
Topics include- Overview of SSAS Tabular models
Data sources supported in SSAS tabular 2016 Create Tabular Models
Version comparison
Delete Relationships
Impersonation
Create and Manage Roles
Add sample data to DirectQuery models
Enable DirectQuery mode in SSDT
Bi-directional cross filters Calculations
Create and Manage Perspectives Translations Roles
Object-level security
Process Tabular Model Partitions
Hide or freeze columns
Add a table Delete a Table
DirectQuery Mode
Define partitions in DirectQuery models
Create and Manage KPIs Hierarchies
Create and Manage Tabular Model Partitions
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Accrington
- 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 Local Partitions
- See Training Course Details...
Processing Databases, Dimensions and Partitions
Overview of SSAS Multidimensional Modelling
Read Definition permissions
Deploy Model Solutions Using XMLA
Define Assignments and Other Script Commands
Authorizing access to objects and operations
Data Source object permissions
Create an Analysis Services Project
Define Named Queries in a Data Source View
Use Aggregate Functions
Defined Linked Measure Groups Partitions
Define a Fact Relationship and Fact Relationship Properties
Attach and Detach Analysis Services Databases
Delete a Data Source
Deploy Model Solutions with the Deployment Utility
KPIs Actions
BI Wizard
Explore Data in a Data Source View
Create a Dimension by Using an Existing Table
Multidimensional models
Email us about this courses
Other Accrington Enable Technology Training Courses
Access VBA - Accrington Access Training Courses
Power Query - Accrington Excel Training Courses
JQuery Mobile - Accrington JavaScript Training Courses
TSQL - Accrington SQL Training Courses
Excel Power Pivot - Accrington Excel Training Courses
Report Builder Accrington Training Courses