SQL SERVER ANALYSIS SERVICES TRAINING COURSES MORECAMBE
About Enable Technology Morecambe SQL Server Analysis Services Training Courses
Enable Technology offer short intensive skills based SQL Server Analysis Services training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). We provide every candidate with SQL Server Analysis Services training materials which they keep after the course. We also provide an ongoing support service to people attending our SQL Server Analysis Services courses. Delegates can contact the course tutor with specific SQL Server Analysis Services questions for as long as they need following the course.
Enable Technology offers instructor led training taught by technology specialists. We can deliver at your premises. We can provide the equipment. Another option is we can organise a local training site in Morecambe. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.
SQL Server Analysis Services courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: National Power PLC, Birmingham City University, Shell UK Oil Products Ltd, Norwich Union PLC, South Staffordshire Water PLC, Capita Group PLC, Carillion PLC and Barclays Bank PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Morecambe
- 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 ... Process Database, Table, or Partition
- See Training Course Details...
Understanding DAX in Tabular Models Measures
Import data by using a native query
Add sample data to DirectQuery models
Data sources supported in tabular 1400 models
Create and Manage Partitions in the Workspace
Create a New Tabular Model Project
Database Process Partitions in the Workspace Database Perspectives
Create and Manage Roles
Change table, column
Enable DirectQuery mode in SSDT
Topics include- Overview of SSAS Tabular models
Import Data
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Import from Power Pivot
Create a Calculated Column
Analyze a tabular model in Excel Deploy tabular model solutions
Enable DirectQuery mode in SSMS
Hide or freeze columns
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Morecambe
- 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 ... Ragged Hierarchies
- See Training Course Details...
Multidimensional models
Data Source object permissions
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
BI Wizard
Processing Databases, Dimensions and Partitions
Define Attribute Relationships
Create an Analysis Services Project
Edit or Delete Partitions Merge Partitions
Define Assignments and Other Script Commands
Explore Data in a Data Source View
Add or Remove Tables or Views in a Data Source View
Create a Dimension by Using an Existing Table
Create a Data Source
Read Definition permissions
Replace a Table or a Named Query in a Data Source View
Processing Options and Settings
Authorizing access to objects and operations
Batch Processing Remote Processing
Attach and Detach Analysis Services Databases
Delete a Data Source
Email us about this courses
Other Morecambe Enable Technology Training Courses
Access - Morecambe Access Training Courses
SSRS - Morecambe SQL Server Reporting Services Training Courses
SSIS Morecambe Training Courses
Excel Power Pivot Morecambe Training Courses
PL/SQL - Morecambe SQL Training Courses
Power Query Morecambe Training Courses