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

When to use ALL as an argument in SAMEPERIODLASTYEAR or similar function (24.11.2019)

This can be confusing for Power BI users. When writing the SAMEPERIODLASTYEAR function (or TOTALYTD or something like this...), them…
Pokračovat ve čtení

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í