It's not every day that you can hear a great conversation with the Head of Product of Excel. Brian Jones sits down with us and talks about the past, present, and very promising future of Excel. Rob and Brian go way back, and the stories and laughs abound! Check out this cool World Orca Day Excel template for kids! Episode Timeline: 4:00 - Brian's lofty title is Head of Product at Excel, The importance and magic of Excel, and people's a-ha moments with Excel 20:25 - The difficulty of not seeing y...
Jul 27, 2021•2 hr 31 min
Ashvini Sharma is one terrific human being and he knows a LOT about Robotic Process Automation (RPA). As the Group Program Manager of Power Automate RPA at Microsoft, there is no better source of information about automation than from Ash! If you want real-world examples of what Power Automate can do, this is the episode you need to listen to. Power Automate Desktop Download and Blog Episode Timeline: 2:05 - How could anyone live without air conditioning?!, Maintaining the work/life balance is d...
Jul 20, 2021•1 hr 20 min•Ep. 38
We've not exactly been consistent with our episode releases as of late, and Rob sheds some light as to why. Rollercoaster doesn't even begin to describe the ride we've been on lately... Thank you for listening and supporting Raw Data by P3 Adaptive! We will be releasing new episodes with some really great guests starting July 2oth!
Jul 06, 2021•5 min•Ep. 37
Shishir is as ahead of the technology curve as it gets, some of his ideas have revolutionized the way that tech giants like Microsoft, Google, and YouTube operate. Now, he's innovating again as the founder and CEO of Coda -an amazing integrated system that centers around creating Docs that are as powerful and actionable as Apps. He's also one of the most down to Earth human beings we've ever had the pleasure of sitting down with! References in this episode: Unfrozen Caveman Lawyer SNL Skit Steve...
Jun 15, 2021•1 hr 20 min•Ep. 36
Our guest this week, Vishal Lodha, is Strategic Account Director at Microsoft. A title that comes with huge amounts of pressure and responsibility. Vishal is the primary point of contact between Microsoft and some of their most important customers and has a vast knowledge of the entire Microsoft stack. His story is much like so many other guests on our show-taking quite the circuitous and interesting path to where he is today! References in this episode: Planes, Trains, and Automobiles Taxi Scen...
Jun 02, 2021•1 hr 28 min•Ep. 35
Chris Webb is an OG in the Microsoft data universe, having long-time knowledge of the Microsoft Data Platform...even pre-dating Rob's own experience with the tools! He's a Principal Program Manager on Microsoft's elite Power BI Customer Advisory Team (The CAT Team)! He and Rob have known each other for a long time. Their relationship was, at times, adversarial. Now, though, they are allies that spread the gospel of Power BI and the Microsoft Power Platform! References in this episode: Hitler Hit...
Jun 01, 2021•1 hr 15 min•Ep. 34
Evan Rhodes is one of the three Directors of Client Services here at P3 Adaptive. It is no wonder why he is one of our leaders here. There is very little that can stand in his way when it comes to excellence, he makes everyone around him better, and he wants to win by doing things the right (not only the correct, but the ethical) way. And, to top it all off, he looks a LOT like Keanu Reeves. And he's just as cool as Keanu! References in this episode: Spider-Man Pointing Meme The Balanced Scoreca...
May 25, 2021•1 hr 7 min•Ep. 33
Derek Rickard has a super cool title, he's the Chief Data Officer at Emergency Reporting -their software simplifies Fire & EMS reporting and records management, making a positive difference for first responders everywhere. He's one of the very first people to discover the gamechanger that is PowerPivot back in the day, and it reshaped his entire career. He, like so many other data people, has a want to help others and his story will very likely resonate with a lot of you! References in this epis...
May 04, 2021•1 hr 15 min•Ep. 32
Ken Puls is the epitome of an Excel and Power BI guru by being an incredible guide, a teacher, and "Remover of Darkness" of the secrets of these tools. Born from a fusion of Accounting and IT, Ken's mastery of Excel includes VBA programming and Power Pivot modeling, data cleansing and reshaping, and financial modeling. We highly encourage you to check out Ken's website, Excelguru.ca , if you desire to be enlightened in the ways of Excel and Power BI. References on this episode: Download Rob's Re...
Apr 27, 2021•1 hr 29 min•Ep. 31
It's clear when you listen to Ryan Bergstrom tell his story as to why he is a leader here at P3 Adaptive. His problem-solving ability is incredible, and he loves to teach and help others. That vibe sounds quite familiar, the data community has a such great reputation for altruism! Ryan's drive, tenacity, and resilience have led him on a path to success, and he's just getting warmed up! It's a great story that we hope will inspire the future data rock stars out there. References in this episode: ...
Apr 20, 2021•1 hr 4 min•Ep. 30
Krissy Dyess is a prime example of inspiration and adaptability. She made a decision to better her knowledge of the updated and evolving BI tools through self-teaching, and with help from the amazing data community. She went from being stuck in a cubicle, to being a team leader at one of the best BI consulting firms in the world. And she creates excellent Cat Memes! References in this episode Telling Ain't Training by Harold D. Stolovitch David Churchward's SQL UNPIVOT Makes My Data Skinny blog ...
Apr 13, 2021•1 hr 27 min•Ep. 29
Gordon Rowe III's nickname among his peers is The Gandalf of Data, and for good reason-he's truly a wizard when it comes to the unconventional tools that he uses. What he does with the 2010 version of PowerPivot will blow your mind! He works in the nursery and horticulture space with North Creek Nurseries . Gordon knows his woody plants...and his DAX! References in this episode: The Excel Addict Longwood Gardens Highline Gardens in New York Rob's Scatter Chart Blog Post Episode Timeline: 4:50 - ...
Apr 06, 2021•1 hr 10 min•Ep. 28
Who better to talk about the past, present, and future of BI than Microsoft Corporate Vice President of the Business Intelligence Platform Arun Ulag. We're all excited for the upcoming Microsoft Business Applications Launch Event on April 6th! References in this Episode: Monty Python Camelot Scene Dirty Daxing Tweet Something About Mary 7 Minute Abs Scene The Giant Backlog of Power BI Ideas Episode Timeline: 1:20 - Arun's data journey, and the death of Power BI V1 17:20 - The story behind the ne...
Apr 01, 2021•1 hr 15 min•Ep. 27
Donald Farmer is a data artist and Jedi of sorts. His BI wisdom is unmatched and he shares this knowledge as we cover his early interest in computers (and the power that they gave the user), the history of PowerPivot from one of the former "faces of Microsoft BI", and so much more! It's so very easy to respect this venerable figure of the data world. Here's Donald's website, Treehive Strategy References in this episode: Thomas Davenport's Competing on Analytics Donald's Treehouse Donald As Power...
Mar 30, 2021•1 hr 17 min•Ep. 26
Kasper de Jonge's areas of expertise are many-Business Intelligence, Power BI, DAX, PowerPivot, General BI, Datawarehouse, SSIS, Reporting Services, Analysis Services, SQL Server, and you can include a mean basketball crossover to that list! As Analytics Advisor and Principal Program Manager of Power BI, he knows a great deal about the problems that BI customers face daily. He shares some of these experiences and his expertise, and we have some good laughs along the way as well! Check out Kasper...
Mar 23, 2021•1 hr 29 min•Ep. 25
It was an honor to sit down with two of the creators of Power Query, Sid Jayadevan and Miguel Llopis. You get to hear the history of Power Query from their perspective! These guys are so busy it took quite a bit of coordination to get them together to record this episode. We hope you enjoy it as much as we did! References In This Episode: Reese's Peanut Butter Cups Old School Commercial Office Space Jump To Conclusions Hitler Hits A Breaking Point With Tableau PQ Diagram View (Preview) Episode T...
Mar 16, 2021•1 hr 11 min•Ep. 24
Hugh Millen is a former NFL quarterback and currently a television and radio sports analyst. He's also a data aficionado, whose story is another great example of a unique path that a person with a keen interest in data has taken. He's leveraged that data knowledge and used it to further his NFL career and he applies it daily in his analyst job. Random References In This Episode: Teddy Roosevelt's Man In The Arena Speech The Pale Blue Dot Episode Timeline: 3:10 - The humble Hugh Millen 12:40 - Hu...
Mar 09, 2021•1 hr 18 min•Season 1Ep. 23
Get to know the C-Suite of P3 as we welcome Kellan Danielson to the show! He's President and COO at P3 and is responsible for the development of so many of the essential inner workings that have allowed P3 to grow as successful as it has. His journey from humble introverted data and business intelligence enthusiast to humble company President is wonderful, and his business acumen is unmatched! Episode Transcript: Rob Collie (00:00:00): Hello friends, we're going to do something a little bit diff...
Mar 02, 2021•1 hr 5 min•Ep. 22
Chuck Sterling's journey is another example of the uniqueness of the people in the data field. The short version is that he's a Marine Biologist turned Senior Program Manager at Microsoft. He has intimate knowledge of the entire Power Platform and he shares that knowledge and insight. References made on the show: Power Virtual Agents Revell Model Ships Who Moved My Cheese? By Spencer Johnson, MD Episode Timeline: 3:45 - The remote workplace, it's not going anywhere 15:00 - The Microsoft Power Pl...
Feb 23, 2021•1 hr 20 min•Ep. 21
Data guy by day, crimefighter also by day! John Hancock has revolutionized the Law Enforcement space with his company Hubstream . His team uses advanced data techniques and tools to assist investigators to battle all manner of illegal activity. His story, his data journey, and even his accent are fascinating! Episode Timeline: 1:35 - Project Gemini is how Rob and John met, the evolution of BI tools, and that pesky status quo 13:50 - The story of John Hancock the crimefighter AKA Captain Correlat...
Feb 16, 2021•2 hr 52 min•Ep. 20
Bill Jelen, known to many as Mr. Excel , was one of the first Internet Tech Celebrities. He turned his online resume into a highly recognizable brand and is a legend in the data community. We get his story, in his own words. We hope you'll enjoy this candid conversation with Mr. Excel, Bill Jelen Buy Bill's book Mr.Excel 2021: Unmasking Excel, containing his favorite Excel tips! Stuff We Mentioned: Hipster Ipsum Copy Filler Tool Dax Studio We Report Space-Bill's Other Website! Rob's Wheel Of Inq...
Feb 09, 2021•2 hr 37 min•Ep. 19
Power BI has altered the course of many people's lives for the better, and that is surely the case with our guest Jonathan Perl. Coming from a financial background, he was already well versed in the Business Intelligence tools of the past. But the Power Platform spoke volumes to Jon. So much so that he changed his entire career path in order to share his expertise with these tools with others (and make a few shekels while he's at it). His data journey is as unique as they come! Episode Timeline:...
Feb 02, 2021•1 hr 3 min•Ep. 18
Lori Rodriguez has a unique perspective on business, she's been collecting data about and for C-suite technology leaders as Vice President-Executive Programs at Gartner. In this episode, she shares her knowledge about technology and business as an expert in both fields. Lori is an advocate for women in business and STEM fields and has authored the book due out soon-We Want You To Stay: The Hidden Lives of Twenty Women In Stem. You can preview a chapter of the book and learn more HERE . Episode T...
Jan 26, 2021•2 hr 21 min•Ep. 17
He's just a guy in a cube helping people. That's the simplest way to describe who Adam Saxton is. He turned a childhood fascination for computers into an amazing career at Microsoft (he's currently a member of the elite Power BI CAT Team), he has a hugely successful YouTube channel, Guy In A Cube , with his partner Patrick LeBlanc, and is a respected fixture in the data community. He sits down with the Raw Data Crew and talks about his origin story, the work he puts in for the YouTube channel, P...
Jan 12, 2021•2 hr 48 min•Ep. 16
Matt Selig wears many hats at SerVaas Labs, maker of Bar Keepers Friend (BKF) . When facing pain points to running more efficiently before COVID struck, Matt knew how he wanted the BKF data to look, but he wasn't sure how to get there. Enter his relationship with P3 that began in February 2020. Matt kept the in-demand cleaning product of a post-COVID world top of mind and easily accessible with the help of customized and integrated dashboards to read real-time data for better business decisions....
Jan 05, 2021•1 hr 2 min•Ep. 15
Stephanie Bruno and Shannon Lindsay join Rob for a special holiday giving edition of the podcast. This duo makes up the colorful online world of The Data Witches . Both of these ladies in tech are Power BI User Group Leaders in their respective regions of Pittsburgh and Washington, DC. The witches continue to use their Powers (of BI) for good across many philanthropic efforts: From their early days working together at the Elizabeth Glaser Pediatric AIDS Foundation (EGPAF). Shannon & Stephanie's ...
Dec 22, 2020•1 hr 25 min•Ep. 14
Conor Cunningham is a Microsoft Architect and he knows a great deal about data, storage, and everything Microsoft. He and Rob go way back and were even roommates for a couple of years during Rob's Microsoft days. There's quite a bit of history between Rob, Tom, and Conor. A history that fosters an insightful discussion and a little bit of busting chops! We discuss quite a bit including: What a Microsoft Architect does Organized storage and Data lakes Conor's celebrity status How the Query Store ...
Dec 15, 2020•1 hr 19 min•Ep. 13
Austin Senseman is a former P3 team member who went on to start his own business, Conserv , an internet of things startup company in the conservation space. Conserv does important work to help preserve historical artifacts in museums and private collections by using sensors and analytics. We talk about historical artifacts and the data that is used in preserving them, the infamous P3 Interview Of Death, dealing with Investors, business ethics and so much more. Episode Timeline: 1:45 - Meeting Au...
Dec 08, 2020•2 hr 37 min•Ep. 12
Matt Allington is a Power BI consultant, Trainer, Microsoft MVP, author, and a friend! Matt has worked for many years in the retail and CPG industries, has a very deep knowledge of Business Intelligence and Data Analytics, and currently owns a Power BI consultancy ExceleratorBI in Australia! Here's the link to Matt's book- Supercharge Power BI: Power BI Is Better When You Learn to Write DAX Episode Timeline: 2:00 - Did Matt and Tom the SQL Rockstar previously meet each other? 6:25 - Matt's origi...
Dec 01, 2020•1 hr 21 min•Ep. 11
For Thanksgiving week we think it's only appropriate to discuss the alcohol industry. For this, we welcome P3 principal consultant and alcohol industry veteran Paul Boynton. He and the crew discuss the tremendous amount of data that exists in the alcohol industry, hostages VS volunteers in training sessions, the culture at P3, and some great uncomfortable stories from Rob's days at Microsoft. Any great holiday get-together has to include a few laughs, and that we do. Happy Thanksgiving everyone!...
Nov 24, 2020•1 hr 27 min•Ep. 10
