Wednesday, January 18, 2017

The Recorded Version of Our December Webinar On PowerPivot

On Tuesday we did have the webinar on PowerPivot. For one hour I showed how to combine data from difference sources and easier transform them into ones you can use to create meaningful single page dashboards.

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