There are a lot of modules involved in making a fancy user profile. To get just a bare bones profile showing user entered profile data and their recent posts, you need (dependent modules listed under each main module):
Much more functionality can be had by adding more contrib modules. The ones in this list are the ones used in the tutorial but there are many other possibilities out there.