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

1 comment:

  1. Wow, this rose tea chiffon cake recipe is an absolute game-changer! 🌹💕 I tried it last weekend for a friend's bridal shower, and it was a hit! The delicate floral notes from the rose tea infused perfectly into the light and airy chiffon cake, creating a truly indulgent treat. Plus, it's surprisingly easy to make! Definitely adding this to my go-to recipe list. And hey, if you're as obsessed with baking as I am, why not treat yourself and Buy dissertation online uk? It's a win-win – you get your cake and your academic success too! 🍰📚