SQL Server Analysis Server (SSAS) KeyColumn vs NameColumn vs ValueColumn

What is the difference between the KeyColumn, the NameColumn, and the ValueColumn for a dimension attribute in SQL Server Analysis Services? How do they affect the data presented to the end user? When should you use the KeyColumn, the NameColumn, and the ValueColumn for a dimension attribute? Check out this tip to learn more.