Training topics

Basics, Deep dive, DAX, M, R, Visuals, Data modelling, Power Excel...


Anywhere in Europe -  trainers will come right into your conference room. The training language is English.


Data analysts with long training history - authors of these tutorials.


Roughly 1000 - 2000 EUR per day, ask for proposal.


In recent years we provided trainings for companies from pharma (Fresenius, Gilead, GlaxoSmithKline, Johnson & Johnson, Merck, Roche, SpofaDental), automotive (Aisin, Ford Credit, Good Year, Nokian, Pirelli, Skoda Auto), finance (Allianz, Direct, Generali), infrastructure and telco (E-on, Innogy, Strabag, T-mobile) and others (Avast, Decathlon, Jan Becher, Nestlé, Notino, Sportisimo…).  

Recent manuals

Bye bye, Power View. I´ll not miss you. (6.11.2019)

If you try to start Power View today (and find where the add-on is activated, and then find where the…
Pokračovat ve čtení

Power Query and assigning to ranges (merging of tables like VLOOKUP with last argument 1/TRUE)) (2.11.2019)

This article describes, how to use Power Query to connect two tables using range or date interval (like VLOOKUP works…
Pokračovat ve čtení

Group by to merge texts – something like CONCATENATEX, but in queries (27.10.2019)

This article shows, how to merge text strings into groups. Like CONCATENATEX, but in queries - not in DAX. In…
Pokračovat ve čtení