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•Transcript available on Metacast 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•Transcript available on Metacast 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•Transcript available on Metacast 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•Transcript available on Metacast 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•Transcript available on Metacast 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•Transcript available on Metacast 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•Transcript available on Metacast 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•Transcript available on Metacast 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•Transcript available on Metacast 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•Transcript available on Metacast 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•Ep 23•Transcript available on Metacast 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•Transcript available on Metacast 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•Transcript available on Metacast 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•Transcript available on Metacast 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•Transcript available on Metacast 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•Transcript available on Metacast 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•Transcript available on Metacast 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•Transcript available on Metacast 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•Transcript available on Metacast 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•Transcript available on Metacast 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•Transcript available on Metacast 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•Transcript available on Metacast 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•Transcript available on Metacast 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•Transcript available on Metacast It's a not so technical discussion with tech guru and Microsoft Cloud Solutions Architect Hope Foley! We talk a lot about Microsoft, and a little about Star Wars. Episode Timeline: 1:25 - Meeting Hope 4:15 - The Darth Vader connection 6:45 - Three Letter acronyms and Hope's field work in the Education vertical 12:50 - The Satya Era at Microsoft, how his keynotes are vastly different than other CEO's, and the culture at Microsoft 17:55 - Rob's tenure at Microsoft wasn't all unicorns and rainbows,...
Nov 17, 2020•55 min•Ep 9•Transcript available on Metacast He's known as the Man of a Thousand Jobs and he's done it all. From horse farming and training, to security at Rupp Arena, to using dynamite to blow up mines, to analytical chemistry and everything in between. Kevin currently works at Eli Lilly and Company and his path to Power BI was anything but a typical data journey. He's a fine Southern Gentleman with a mind for data, he's Kevin Overstreet. Episode Timeline: 2:07 - Kevin's Data Salvation, his impressive pedigree, and his amazing career path...
Nov 10, 2020•55 min•Ep 8•Transcript available on Metacast Hello fellow Americans! It's the day after the election, and who better to have on than sports and analytics journalist Michael Salfino from FiveThirtyEight , The Athletic , and The Independent . Data and politics and a little sports mixed in for good measure!...
Nov 05, 2020•43 min•Ep 7•Transcript available on Metacast Every guest on Raw Data By P3 has been top-notch, but we haven't yet had a Doctor on...until now! Dr. Wayne Winston is Professor Emeritus of Decision Sciences at the Kelley School of Business at Indiana University, he's won numerous teaching awards, is a prolific writer, has consulted the NBA's New York Knicks and the Dallas Mavericks, and he's a 2 time Jeopardy winner! He's a highly entertaining and intelligent guest and we're honored to present this episode of Raw Data By P3 with Dr. Wayne Win...
Nov 02, 2020•2 hr 33 min•Ep 6•Transcript available on Metacast Brad Miller and Kai Hankinson from Agree Media were Rob's first clients at P3 before it was even called P3! These guys have been close friends and business partners for a long time, and they know a lot about data. We cover: Their ups and downs in various business ventures How they wrote and used AI software to win at online poker, while living in India Organic farming in Hawaii, also known as WWOOFing Their connection with Snoop Dogg How Agree uses Power BI The Lead Generation Business The diffe...
Oct 27, 2020•2 hr 38 min•Ep 5•Transcript available on Metacast Chris Finlan is a Principal Program Manager on the Microsoft Power BI team, the creator of the popular and incredibly adorable mascot Paginated Report Bear, and a huge Philadelphia sports fan. We try very hard not to hold that last item against him! He's done it all, from the product team to pre-sales, technical training, database administration and sales operations. Tom is off this week, so P3 Senior Principal Consultant Justin Mannhardt steps in to fill the void. The guys cover quite a bit, in...
Oct 20, 2020•1 hr 2 min•Ep 4•Transcript available on Metacast