Recently I had the pleasure of presenting at the Microsoft Dynamics GP User Group (GPUG) Summit. Being a BI nut, every presentation revolved around Microsoft Power BI in some shape or form.
Microsoft (Dynamics) Program Manager Jared Hall, fellow Microsoft Dynamics GP MVP Mark Polino and I competed in our second “Excel Shootout”. This is a competition for showing “cool and useful” features in Excel. The competition consists of four rounds. The following video shows my round 4. I decided to push the envelope and make a music video. (For trademark reasons, I have silenced the music, so when you watch it hum something fast pace and catchy. I used something about having “Power” followed by the theme song of a crime fighting dog.)
In the video I start by showing a GP feature (if you are not a GP user hang tight, remember the whole video is only 4 minutes long) then I use Power Query to extract data and binary images (BLOB) from SQL Server. I use these data in a Power View dashboard that displays the data and the image.
I hope you enjoy it and learn something as a well. If you are interested in the full version, where I show everything in slow motion while explaining it, you can see that video using the following link.
Belinda Allen, Smith & Allen Consulting, Inc.
Microsoft MVP, MCT