Who should take an MSBI training course?

Analysis Services Tabular training

Also as online training in the virtual classroom
8 participants have attended this seminar so far

Live online training of the highest quality

Thanks to the GFU online training courses, advanced training is easier than ever - and with the usual GFU quality! Expand your knowledge in a quick and uncomplicated way without leaving your home.

  • You save time and money
  • Online access to the learning environment
  • No installations on your own PC necessary
  • IT support for the entire duration of the seminar
  • Textbook for the seminar
  • Monitor, webcam, notebook, ... optionally rent NEW
High performance air purifier demonstration

In-house / company training

  • 1 day - customizable
  • Appointment as desired
  • Price according to offer
  • In your company or at GFU

Individual training

  • 1 day - customizable
  • Appointment as desired
  • Price according to offer
  • In your company or at GFU

description

"Analysis Services / Tabular" is the new in-memory-based analytical product from the SQL Server Product suite. It fits in with the sibling products "Analysis Services / Multidimensional" (also contained in "Analysis Services") (OLAP) and "Analysis Services / Data Mining" added as a third. "SSAS Tabular" is the server counterpart to the desktop version "Excel PowerPivot ", whose models can also be imported into SSAS Tabular. With SSAS Tabular, the top-down development of analysis and reporting solutions is to be promoted. At the beginning of the development there is the PowerUser with his technical requirements and not the reporting -Department. SSAS Tabular is more similar to the line-based calculation logic of Excel and is therefore more intuitive for beginners.
The seminar provides an overview of the architecture of the product, the integration into a reporting landscape and the most important tools for development and query. Simple tabular models are created and displayed in Excel. In addition, an overview of the similarities and differences between SSAS Multidimensional and MDX on the one hand and SSAS Tabular and DAX on the other is given.

Training goal

The participants get to know the most important features of SSAS Tabular and the integration options in a reporting landscape. In addition, a practical introduction is provided that enables productive use.

Who should attend

Analysts, BI specialists, developers, power users with good knowledge of a relational, non-relational or analytical database product.

Your training

Learning method:
A balanced mix of theory and practice
Documents:
Seminar documents or specialist book for the seminar included, which can be selected individually after consultation with the trainer
Workplace:
PC / VMs for each participant
High-quality and high-performance hardware
Large, height-adjustable screens
Access to your company network is allowed
Learning environment:
New systems set up for each course in coordination with the seminar leader.
Working materials:
A4 notepad, notepad, ballpoint pen, USB stick, highlighter, post-its
Certificate of attendance:
Will be handed out at the end of the seminar, including a table of contents

organization

The Hygiene concept was with professional help implemented and coordinated with the responsible authority. We would be happy to provide this to you. In addition, for your safety, we have equipped the training center with a total of 17 Trotec TAC V + high-performance air cleaners. Thanks to the newly developed filter technology (H14 certified according to DIN EN1822), the room air is circulated several times an hour and 99.995% of the infectious aerosols are separated and killed in the HEPA virus filter. In addition, all rooms are equipped with CO2 traffic lights. Lunch will take place in the TÜV casino. The TÜV also has an exemplary hygiene concept.

Number of participants:
min. 1, max. 8 people
Training times:
1 day - customizable, 9:00 a.m. - 4:00 p.m.
Training location:


GFU training center
At the gray stone 27
51105 Cologne-Deutz or online in the Virtual Classroom
or at your premises throughout Europe as in-house training
Premises:
Bright and modern rooms with perfect infrastructure
Catering:
Breakfast, snacks and drinks all day, lunch in our own restaurant, 6 menus daily, including vegetarian options
Accessibility:
The GFU training center (Am Grauen Stein 27) is barrier-free

content

  • Basics
    • Overview of the Microsoft BI stack
    • The new MS strategy: SelfService BI
    • Similarities and differences between SSAS Multidimensional and SSAS Tabular
    • The main tools too administration, Development, query and presentation
  • Create a simple tabular model
    • Loading data, using different types of data sources
    • Managing relationships
    • Creating Computed Columns and Measures
    • Creation of hierarchies
    • Adding charts and slicers
    • Tabular model: manage, connect and distribute
  • Overview: DAX expressions and DAX queries
    • Create simple DAX queries
    • Similarities and differences between SQL, MDX and DAX
  • Architecture and concepts
    • InMemory Computing, xVelocity and DirectQuery
    • Manage user rights
    • Overview: Server Sizing
    • Overview: Automation with XMLA, AMO, PowerShell and SSIS

This is how GFU customers voted

No ratings have yet been submitted for this seminar.

FAQ for in-house training

What does open training and in-house training mean?

In the case of an open training course, the location and date are set in advance. Anyone interested can book an open training course, so participants from different companies meet.

In-house training courses can be tailored to your individual training needs. You determine the group of participants, the date and the training location.

Is in-house training the right choice?

With in-house training, we cater to the individual needs of your company and cover the training needs directly at your company.

This saves time and money and ensures that your employees' knowledge is transferred quickly.

Who takes care of the technology for in-house training?

A complete learning environment in the cloud with remote access is a matter of course for us. You need to worry about anything. Only a functioning PC or notebook with Internet connection should be available for each participant on the day of the training.

Advantages of in-house training

  • Competent seminar advice
  • Lecturers from practice
  • Individual learning material tailored to your needs
  • You can arrange the appointment flexibly, as it suits you best
  • Our in-house training courses can be carried out across Europe
  • The focus is on your training needs, so you save your budget
  • Gaps in your employees' knowledge are quickly closed
CONDUCTED SEMINARS