Enable Technology



About Enable Technology Blackburn SQL Server Analysis Services Training Courses

We offer intensive two and three days SQL Server Analysis Services courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). All course participants are issued SQL Server Analysis Services training manuals they can refer to after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Analysis Services queries.

Our primary method of delivery is instructor led training coupled with practical hands on activities. 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 course at a local socially distanced venue in Blackburn. The SQL Server Analysis Services syllabus can be modified to accommodate your specific training 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

The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are GKN PLC, Yell Group PLC, Birmingham City Council, Norfolk Police Constabulary, Nuclear Engineering Services, Loughborough University, Shell UK Oil Products Ltd and Birmingham City University.

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Blackburn
  • 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 ...
  • Cube or model permissions Process permissions
    Authorizing access to objects and operations
    Create Local Partitions
    Set Data Source Properties
    Define a Referenced Relationship and Referenced Relationship Properties
    Create a Time Dimension by Generating a Time Table
    Define Time Intelligence
    Attach and Detach Analysis Services Databases
    BI Wizard
    Replace a Table or a Named Query in a Data Source View
    Backup Options Restore Options
    Create Named Sets
    Edit or Delete Partitions Merge Partitions
    Read Definition permissions
    Explore Data in a Data Source View
    Backup and Restore of Analysis Services Databases
    Create Calculated Members
    Define Logical Primary Keys in a Data Source View
    Create Remote Partitions
    Rename a Multidimensional Database Processing a multidimensional model
    Partition Writeback Calculations

  • See Training Course Details...

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Blackburn
  • 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 ...
  • Filter Data in a Table Relationships
    Connect to a tabular model database
    DAX formula compatibility in DirectQuery mode Tables and Columns
    Bi-directional cross filters  Calculations
    Manage Roles by using SSMS
    Specify Mark as Date Table for use with Time Intelligence
    Create and Manage Partitions in the Workspace
    Import from Power View
    Hide or freeze columns
    Import Data
    Row filter mappings
    Data types supported
    Analyze a tabular model in Excel Deploy tabular model solutions
    Enable DirectQuery mode in SSDT
    Create and Manage KPIs Hierarchies
    Add columns to a table
    Delete Relationships
    Delete a Column

  • See Training Course Details...

Email us about this courses

Other Blackburn Enable Technology Training Courses

JQuery Blackburn Training Courses
PL/SQL - Blackburn SQL Training Courses
VBA - Blackburn Excel Training Courses
Report Builder - Blackburn SQL Server Reporting Services Training Courses
JavaScript - Blackburn JavaScript Training Courses
Power Query Blackburn Training Courses