Enable Technology



About Enable Technology Kidderminster SQL Server Analysis Services Training Courses

Enable Technology has twenty year track record of providing short intensive SQL Server Analysis Services skills based training courses. The tutor delivering the course will be a Microsoft certified expert. Every course participant will receives course practice files and SQL Server Analysis Services course resources that can be referenced post 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.

SQL Server Analysis Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We are set up to deliver SQL Server Analysis Services training courses onsite at your premises. Alternatively we could schedule a SQL Server Analysis Services course at an alternative training site in Kidderminster. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services training requirements.

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 Birmingham Heartlands Hospital, Canadian High Commission, Nuclear Engineering Services, TalkTalk Direct Limited, National Power PLC, Lloyds TSB Bank PLC, Shell UK Oil Products Ltd and Royal & Sun Alliance Group PLC.

Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Kidderminster
  • 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 ...
  • Enable DirectQuery mode in SSMS
    Data types supported
    Create a Calculated Table
    Analyze a tabular model in Excel Deploy tabular model solutions
    DirectQuery Mode
    Understanding DAX in Tabular Models Measures
    Import from Analysis Services
    Import Data
    Import from Power View
    Deploy from SQL Server Data Tools Manage Tabular Model Databases
    Restore from Power Pivot
    Connect to a tabular model database
    Delete a Column
    Create and Manage Measures KPIs
    Create and Manage KPIs Hierarchies
    Data sources supported in SSAS tabular 2017
    Row filter mappings
    Test a model in DirectQuery mode
    Data sources supported in tabular 1200 models
    Add a table Delete a Table

  • See Training Course Details...

Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Kidderminster
  • 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 ...
  • Attach and Detach Analysis Services Databases
    Deploy Model Solutions with the Deployment Utility
    Define a Data Source View
    Using SQL Server Data Tools (SSDT)
    Define Assignments and Other Script Commands
    Delete a Data Source
    Edit or Delete Partitions Merge Partitions
    Create User-Defined Hierarchies
    Processing Options and Settings
    Set Impersonation Options for a Data Source Connection
    Set Data Source Properties
    Multidimensional models
    Define Semiadditive Behavior
    Create a Dimension by Using an Existing Table
    Create Measures and Measure Groups
    Configure Analysis Services Project Properties
    Define Attribute Relationships
    Data Source Views
    Define Named Queries in a Data Source View
    Create a Dimension Using the Dimension Wizard
    Designing Aggregations

  • See Training Course Details...

Email us about this courses

Other Kidderminster Enable Technology Training Courses

Excel 365 Basic Kidderminster Training Courses
Access - Kidderminster Access Training Courses
SQL Kidderminster Training Courses
Data Warehouse - Kidderminster SQL Training Courses
JQuery - Kidderminster JavaScript Training Courses
Excel 365 Intermediate - Kidderminster Excel Training Courses