Here’s a more practical example than fuzzy-faced Vicky, lol.
The first image is a promo pic from http://www.daz3d.com/vintage-for-west-park-ablutions It’s .great, but I needed something more like what you might see in a mall or government office building.
The second shot is using a marble tile shader from Marieah’s Pimp My Prop tool. It’s just a quick render using default lighting.
If anyone else would like to post some images of what shaders can do, be welcome. Or check out the kit-bashing thread for some cool examples of how people are using shaders http://www.daz3d.com/forums/viewthread/14967/
Click thumbnail to see full-size image