Enable Technology

SQL SERVER ANALYSIS SERVICES CHESHIRE TRAINING COURSES 

SQL SERVER ANALYSIS SERVICES TRAINING COURSES CHESHIRE




About Enable Technology Cheshire SQL Server Analysis Services Training Courses

Enable Technology specialise in succinct skills based SQL Server Analysis Services training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source after the course. Course participants are welcome contact the Tutor after the course with specific SQL Server Analysis Services queries. This support is open ended.

SQL Server Analysis Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology SQL Server Analysis Services training courses can be delivered at your offices. We can supply the necessary software and computers. We are also more than happy to organise a local course at a training location in Cheshire. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services training needs.

We can also deliver SQL Server Analysis Services courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Wolverhampton City Council, Norwich Union PLC, Canadian High Commission, TalkTalk Direct Limited, Unipart Group, Barclays Bank PLC, Birmingham Heartlands Hospital and Carillion PLC.




Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Cheshire
  • 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 ...
  • Data types supported
    DAX formula compatibility in DirectQuery mode Tables and Columns
    Enable DirectQuery mode in SSDT
    Understanding DAX in Tabular Models Measures
    DirectQuery Mode
    Connect to a tabular model database
    Analyze a tabular model in Excel Deploy tabular model solutions
    Hide or freeze columns
    Data sources supported in tabular 1400 models
    Delete Relationships
    Data sources supported in tabular 1200 models
    Enable DirectQuery mode in SSMS
    Change table, column
    Create and Manage Measures KPIs
    Manage Roles by using SSMS
    Deploy from SQL Server Data Tools Manage Tabular Model Databases
    Sort Data in a Table
    Rename a Table or Column
    Specify Mark as Date Table for use with Time Intelligence

  • See Training Course Details...


Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Cheshire
  • 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 ...
  • Define Assignments and Other Script Commands
    Define Semiadditive Behavior
    KPIs Actions
    Define Logical Primary Keys in a Data Source View
    Create Measures and Measure Groups
    Create Local Partitions
    Define a Fact Relationship and Fact Relationship Properties
    Batch Processing Remote Processing
    Move an Analysis Services Database
    Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
    Add a Standard Action
    Data Source Views
    Deploy Model Solutions Using XMLA
    Attach and Detach Analysis Services Databases
    Configure Analysis Services Project Properties
    Partition Writeback Calculations
    Set Partition Storage
    Set Impersonation Options for a Data Source Connection
    Overview of SSAS Multidimensional Modelling
    Define Named Queries in a Data Source View
    Calculations using the Business Intelligence Wizard

  • See Training Course Details...



Email us about this courses



Other Cheshire Enable Technology Training Courses

VBA Cheshire Training Courses
Report Builder - Cheshire SQL Server Reporting Services Training Courses
Excel 365 Advanced Cheshire Training Courses
SSIS - Cheshire SQL Server Integration Services Training Courses
Access Cheshire Training Courses
SQL Cheshire Training Courses