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.
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.