
Raw Data By P3 Adaptive
Let’s Argue About BestMovieCast.net w/ Dave Rivera
Listen Now:Get your popcorn ready and get ready to be entertained by our latest episode! In this episode, our host Rob Collie is joined by our data visualization and reporting specialist, Dave Rivera, who showcases the power of the Power Platform in his recent project to find the answer to a complex data question: “Which movie had the most decorated cast based on having received an Academy Award for acting?”
Using Power Query to scrape Wikipedia and Power Automate to gather information from IMDB, Dave created an elegant and accurate solution in under eight hours. He then ranked the actors by nominations and wins, created a ranking system for the movies based on the cast involved, and displayed the data in a user-friendly format using Power BI.
In this episode, Dave takes us through his journey of tackling this complex question and showcases the power of the Power Platform in making the solution simple and efficient. So sit back, grab your favorite snack, and tune in to learn more about data visualization, reporting, and the amazing possibilities of the Power Platform!
As always, if you enjoyed this episode, be sure to leave us a review on your favorite podcast platform to help new listeners find us.
Also in this episode:
Other Episodes

The Fruit of the Electric Grapevine: Industry-Leading Visibility on Limited Resources, w/ Jack Irby
10.31.23
Stay Away from Guadalcanal, w/ Olivier Travers
MS Data Platform International Man Of Mystery
01.04.22
99% is the New Zero, w/ Microsoft Director Shelly Avery
Director-US Healthcare Specialist, Microsoft
09.14.21
For Those About to DAX, w/ Microsoft’s Greg Beaumont
Senior Business Intelligence Specialist, Microsoft
08.17.21
Spreadsheet Celebrities & Power BI Playdates, w/ Chandoo
Hear from the Mozart of Excel Dashboards: Chandoo
08.10.21
The Data Lakehouse: Brick by Brick, w/ Databricks’ Denny Lee
Sr. Staff Developer Advocate, Databricks
08.03.21
Excel Past/Present/Future, w/ Excel Head of Product Brian Jones
Head of Product, Excel-Microsoft
07.27.21
Robotic Process Automation for All, w/ Microsoft’s Ashvini Sharma
Group Program Manager-Power Automate RPA, Microsoft
07.20.21
COVID Basement Racquetball, w/ Microsoft’s Vishal Lodha
Strategic Account Director, Microsoft
06.03.21
Surfing the Changing Seas of Data, w/ Microsoft’s Chris Webb
Principal Program Manager-Power BI Customer Advisory Team, Microsoft
06.01.21
A Different Kind of Data Emergency, w/ Derek Rickard
Chief Data Officer, Emergency Reporting
05.04.21
Earth’s Only Hope vs. Alien Excel Invaders, w/ Ken Puls
President and Chief Training Officer, Excelguru Consulting Inc.
04.27.21
Intelligence Platform is a Cool Name, w/ Microsoft CVP Arun Ulag
Corporate Vice President of the Business Intelligence Platform at Microsoft
04.01.21
The Dutchman of Data Dunked on Me, w/ Kasper de Jonge
Analytics Advisor and Principal Program Manager-Power BI, Microsoft
03.23.21
Everyone’s in the Middle, w/ Former NFL QB Hugh Millen
Former NFL Quarterback and Data Nerd
03.09.21
Marine Biology Leads to Power Platforming, w/ Chuck Sterling
Senior Program Manager, Microsoft
02.23.21
Data Chefs Can Come From Anywhere, w/ Gartner’s Lori Rodriguez
Vice President Executive Programs at Gartner
01.26.21
Scrubbing Data & Beating COVID, w/ Matt Selig of Bar Keepers Friend
Exec. Vice President, Chief Financial Officer & Chief Human Resources Officer at SerVaas Labs
01.05.21
The Data Witches, w/ Shannon Lindsay & Stephanie Bruno
Shannon Lindsay-Microsoft Certified Data and Analytics Professional &
Stephanie Bruno-Associate Director of Informatics at the Elizabeth Glaser Pediatric AIDS Foundation (EGPAF)
12.22.20

The Query Store’s Open for Biz, w/ Microsoft’s Conor Cunningham
Partner Software Architect, SQL Server Engine-Microsoft
12.15.20One of the World’s Most Amazing Humans, w/ Matt Allington
Power BI Consultant, Trainer, & Microsoft MVP
12.01.20