Enable Technology

SQL SERVER ANALYSIS SERVICES ELLESMERE PORT TRAINING COURSES 

SQL SERVER ANALYSIS SERVICES TRAINING COURSES ELLESMERE PORT




About Enable Technology Ellesmere Port SQL Server Analysis Services Training Courses

We are a company that provides short intensive SQL Server Analysis Services training courses. All Enable Technology tutors are Microsoft certified experts. Each person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials after the training. Our policy is to provide open ended SQL Server Analysis Services post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.

We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology SQL Server Analysis Services courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Another way we could deliver the SQL Server Analysis Services course is at a local training site. The SQL Server Analysis Services syllabus can be modified to accommodate your specific training needs.

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. Some of our clients are Total Telecommunications Limited, Nuclear Engineering Services, Yell Group PLC, Vodafone Group Services, Boots UK Limited, EDF Energy PLC, Capita Group PLC and Queen's Medical Centre Nottingham.




Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Ellesmere Port
  • 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 ...
  • Error Configuration Roles and Permissions
    Create Named Sets
    Change a Partition Source
    Delete a Data Source
    Define Time Intelligence
    Supported Data Sources
    Create a Dimension Using the Dimension Wizard
    Explore Data in a Data Source View
    Set Impersonation Options for a Data Source Connection
    Define Attribute Relationships
    Use Aggregate Functions
    Processing Databases, Dimensions and Partitions
    Overview of SSAS Multidimensional Modelling
    Create Remote Partitions
    Define Logical Primary Keys in a Data Source View
    Cube or model permissions Process permissions
    Data Source Views
    Create Calculated Members
    Deployment Requirements and Considerations for Analysis Services Deployment
    Create User-Defined Hierarchies
    Test an Action

  • See Training Course Details...


Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Ellesmere Port
  • 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 ...
  • Tabular model designer
    Connect to a tabular model database
    Create and Manage KPIs Hierarchies
    Add sample data to DirectQuery models
    Import data by using a native query
    Create a Relationship Between Two Tables
    Manage Roles by using SSMS
    Bi-directional cross filters  Calculations
    Analyze in Excel
    Import Data
    Data sources supported in tabular 1400 models
    Hide or freeze columns
    Enable DirectQuery mode in SSDT
    Specify Mark as Date Table for use with Time Intelligence
    Object-level security
    DAX formula compatibility in DirectQuery mode Tables and Columns
    Add a table Delete a Table
    Version comparison
    Rename a Table or Column
    Delete a Column
    Change table, column

  • See Training Course Details...



Email us about this courses



Other Ellesmere Port Enable Technology Training Courses

PL/SQL - Ellesmere Port SQL Training Courses
SSIS - Ellesmere Port SQL Server Integration Services Training Courses
Excel 365 Basic Ellesmere Port Training Courses
Access - Ellesmere Port Access Training Courses
JQuery Ellesmere Port Training Courses
Data Warehouse Ellesmere Port Training Courses