Training topics

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

Where

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

Trainers

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

Prices

Roughly 1000 - 2000 EUR per day, ask info@exceltown.com for proposal.

References

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

Year To Date values in DAX for fiscal year starting from March (ending in February) (30.10.2021)

The sum of values ​​from the beginning of the year is generally quite simple in DAX. For calendar year, we…
Read more

Merging of two ROWs in Power Query (30.10.2021)

A multiline header can be quite annoying. Let´s say you want to process this table in Power Query in Excel…
Read more

Power Query – how to find a nth smallest or largest value in table or group (14.10.2021)

This article describes how to find the second lowest value, the third latest date... in Power Query. Let´s see how…
Read more