Managing Tables by Exceptions (differences in naming conventions)

Hi everyone, I'm willing to bet many of us have run into this before. I am working on building a cross functional report that looks across HR, Finance, Sales, Marketing, etc... The problem is, all of these groups define departments/teams in different ways. For example, HR calls our executive leadership team "Leadership" in all of their data, while sales just calls them "ELT". Additionally, some groups break down departments into various sub groups, while others roll them up. 

I've been searching for a solution to this, and stumbled across this video:

https://www.youtube.com/watch?v=PnPP-46oolc

At the 5:58 mark, he discusses #5 "Not Managing by Exceptions" which seems like it would help in my situation. Problem is, he doesn't go into much detail, so i have no idea how to set up what he's referring to. Does anyone know how do this? How do you solve this issue of naming conventions within your own datasets?

I appreciate any help.

Thank you,

Mike