SQL SERVER ANALYSIS SERVICES TRAINING COURSES BRYN PYDEW
About Enable Technology Bryn Pydew SQL Server Analysis Services Training Courses
Enable Technology SQL Server Analysis Services courses are short, skill focused and hands on. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Each person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials after the training. We offer a post training support service and delegates will have access to a Microsoft expert on SQL Server Analysis Services for as long as they need.
SQL Server Analysis Services courses are taught by a Microsoft Certified Solutions Expert. Enable Technology SQL Server Analysis Services courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. The SQL Server Analysis Services course could also be scheduled at a socially distanced site near you in Bryn Pydew. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite SQL Server Analysis Services course to some extent is bespoke and tailored to your needs.
SQL Server Analysis Services courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Lloyds TSB Bank PLC, Carillion PLC, Capita Group PLC, Loughborough University, Homeserve PLC, Royal & Sun Alliance Group PLC, West Bromwich Building Society and EDF Energy PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Bryn Pydew
- 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 ... Calculations using the Business Intelligence Wizard
- See Training Course Details...
Replace a Table or a Named Query in a Data Source View
Set Partition Storage
Tools and Approaches for Processing
Rename a Multidimensional Database Processing a multidimensional model
Create Remote Partitions
Deployment Requirements and Considerations for Analysis Services Deployment
Define Logical Relationships in a Data Source View
Define Attribute Relationships
Deploy Model Solutions Using the Deployment Wizard
Create a Data Source
Delete a Data Source View Dimensions
Change a Partition Source
Database permissions
Delete a Data Source
Authorizing access to objects and operations
BI Wizard
Set Data Source Properties
Define a Regular Relationship and Regular Relationship Properties
Create a Time Dimension by Generating a Time Table
Define Logical Primary Keys in a Data Source View
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Bryn Pydew
- 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 ... Create and Manage Partitions in the Workspace
- See Training Course Details...
Tabular model designer
Add sample data to DirectQuery models
Create a Calculated Column
Analyze a tabular model in Excel Deploy tabular model solutions
Create and Manage Hierarchies Partitions
Import from Analysis Services
Version comparison
Connect to a tabular model database
Create a Calculated Table
DirectQuery Mode
Understanding DAX in Tabular Models Measures
Manage Roles by using SSMS
Create a New Tabular Model Project
Enable DirectQuery mode in SSDT
Add a table Delete a Table
Data sources supported in SSAS tabular 2016 Create Tabular Models
Process Database, Table, or Partition
Test a model in DirectQuery mode
Create and Manage Tabular Model Partitions
Email us about this courses
Other Bryn Pydew Enable Technology Training Courses
Access Bryn Pydew Training Courses
SSRS - Bryn Pydew SQL Server Reporting Services Training Courses
VBA - Bryn Pydew Excel Training Courses
SSIS Bryn Pydew Training Courses
JQuery - Bryn Pydew JavaScript Training Courses
Excel 365 Advanced - Bryn Pydew Excel Training Courses