I covered using the Query Editor in Get & Transform panel in Excel. We pulled in over 15 report tables from Excel and one database table from SQL, and combined them to create a dashboard that ties everything neatly together.
You should watch the webinar here: Turbo Charging Your Reports with PowerPivot
For the demo, I worked on real data of the companies listed on the Nigerian Stock Exchange. And we created a dashboard that looked like the one below.
Don't forget to watch the webinar recording here: Turbo Charging Your Reports with PowerPivot