yes it is certainly possible. With some template work you can make Tiki look like and behave totally different to this style here on tw.o.
I would suggest downloading and installing locally if possible to learn Tiki, using the many WIKI pages here on tikiwiki.org and the documentation work which is in progress at http://doc.tikiwiki.org
There is no guide on how to make tiki look like that side, that is upto you. We are all here to offer template advice and share our Tiki knowledge. It is upto you to create your templates and personal style. Look through the Tiki Directory located at: http://tikiwiki.org/tiki-directory_browse.php?parent=2 to get a feel of what Tiki is capable of.
You can always post back with more questions