SharePoint Designer comes with a powerful web part called Data View. Use Data View to show list data from a SharePoint site. Also shown is how to connect multiple lists to create a data management solution.
Video Transcript
Members Only
Please log in in the pane to the right, to view this video tutorial.
If you are not a member of the site, please look into subscription options.

An excellent video on dataview web part. I am able to apply it right away. Thanks Asif
Appreciate the feedback. Hopefully more good stuff coming your way
Very nice! Thanks. Do you also show how to make connections between lists or libraries within SP? Although I suspect it more limited than SP Designer, SharePoint has this ability. Keep up the Excellent work!
Thanks for the kind feedback. Yes, there is another video which shows how to make web part connections through the browser. Here it is: http://www.sharepoint-videos.com/create-a-master-detail-relationship-using-web-part-connections/