

Raw Data By P3 Adaptive
P3 Adaptive
Raw Data by P3 Adaptive is a people-centric data podcast hosted by Rob Collie, Founder/CEO of P3 Adaptive, a Premier Microsoft Power Platform Partner. Rob and his guests share entertaining stories as well as insights, expertise, and anecdotal stories about Business Intelligence, the Power platform, and the world of data . . . with the human element. More of a casual conversation, this podcast exemplifies P3 Adaptive/s “mullet” approach: business in the front, party in the back!
Episodes
Mentioned books

Sep 20, 2022 • 1h 5min
Women In Data w/ Sadie St. Lawrence
On this episode, we are bringing in a true leader in workplace diversity, Sadie St. Lawrence from Women in Data! Be prepared to be surprised when you learn that Sadie’s idea of diversity is more of a value-driven balance that benefits all people regardless of gender. Improvements, she points out, made in the workplace under the guise of removing gender disparity enhance the workplace for all employees, not just for a single demographic. Sadie is an incredible person with an incredible story that started in a male-dominated career where she spent her early years working on improvements within the industry. Her persistence and determination to make the industry more diverse led to her becoming the Founder and CEO of Women in Data. Sadie’s career journey centered around providing support and guidance to those around her and she certainly found her calling: empowering and mentoring women to find success in the world of data. This episode is 100% about the human side and, through the recording process, Sadie indirectly contributed to a recent change in P3 Adaptive’s own job descriptions. The conversation highlighted the disproportional labor divide in homes that was exacerbated during the pandemic. This led to a discussion on why so many women left the workforce during the pandemic and didn’t return, often to provide care for children and other family members. It even highlighted how women seeking a job, might see expected travel as a requirement that, due to family responsibilities, might cause them to not apply, even if they are more than qualified for the position. That change has been reflected in our current career opportunities and can be found on the P3 Adaptive Career Page. Here’s a hint, our travel policy has been updated. Thank you, Sadie, for the insight! As always, if you enjoyed the show, be sure to hit the subscribe button below to have new episodes delivered to your inbox. You never know who the next guest will be on the Raw Data by P3 Adaptive podcast! Also in this episode: Scantron tests Web 3.0: decentralized blockchain introduction Data Careers in the Military Dark Dashboards

Sep 13, 2022 • 1h 16min
Pokémon Go Maps are a Green Technology, w/ Mike Ellis
Occasionally described as “Addictive, stupidly addictive,” this episode delves into the insanity that is Pokémon Go and is dedicated to the people and the technology behind mapping and catching Pokémon. Shortly after its 2016 release, Pokémon Go became the most successful game in history and, at one point, surpassed both Tinder and Twitter growth with usage time beating other social media apps. Why does this “Got to Catch Them All!” mentality transcends technology? Is it the nostalgia? The family bonding time? Meeting new people and raiding gyms? Or is it maybe a little bit more? In today’s recording, you get to hear anecdotes on family bonding, date nights, and even meeting complete strangers to talk Pokémon. Most importantly, though, you get to meet the man behind IndyPokemap.com, Mike Ellis, and learn how he turned his Poké-hobby into a greener way to play in a globally supported community! Don’t worry, this episode is teen friendly, no hacking techniques are discussed, just data personalization with gentile manners. After all, no honest mapper wanted to scan another mapper’s territory. And forget server farms, this episode includes all the details of iPhone farming with a shout-out to the suffrage that occurred during the downtime when mappers were forced to switch from Python to cellphones. A few of the Interesting inside data facts on Pokémon you will learn today include: How many Poké Stops in Indy? The logic behind spawn points. The how to on submitting poké spots. And, don’t forget, if you enjoyed this episode, be sure to leave us a review on your favorite podcast platform and share it with a friend. Just like Pokémon Go, Raw Data by P3 Adaptive is better when shared. Also in this episode: Pokémon Go! Pokémon Raids Pokémon Map shut down by Niantic Pokémon Go-tcha! Pokémon Red Ball Niantic Harry Potter and the Wizards Unite Fan Fest IndyPokémap.com Dog Attack Episode: A Mechanical Clutch Isn't a Steampunk Purse, w/Bill Sundwall Traveling Salesperson problem Pivot table sorting The Software Hall of Fame, w/Microsoft's Conor Cunningham Datel Go-tcha Ranger Ingress by Niantic VMWare Explorer Pokémon pronunciation Niantic Wayfarer Fisher’s Nickel Plate Boss Battle

Sep 6, 2022 • 1h 15min
The Cloud is Powered by People w/ Jeff DeVerter
Have you ever been curious about what moving to the cloud really means? Is it a one-and-done move or is it more? Today’s guest, Jeff DeVerter, Chief Technology Evangelist of RackSpace, breaks down the cloud, cloud-based services, and how it can impact your business. From an engineering point of view to the creation of a supply chain for data, Jeff describes the trends and implications facing ingress, egress, and utilization of the ever-growing volume of data that companies curate. He even shines a light on the often hidden or disguised cost of doing business in the cloud, the dreaded egress fees, and shares tips for lowering your cost of data utilization. After all, Jeff considers moving to the cloud as a change of business, not a change of processes. Don’t worry, this episode isn’t just about the cloud. Rob and Jeff share a backstory of server farms and negative scaling that is sure to entertain. Since cloud services didn’t always exist, the original stop-gap method to run models for Power Pivot was on a SharePoint server. We learn from their experience that when you have an issue, it can’t always be solved by throwing hardware at it. While the additional hardware was ineffective, this method did lead to discoveries that were eventually shared through the user experience and directly led to a more robust Power BI Cloud Service. Finally, Jeff, Rob, and Tom discuss the successful evolution of a company’s data strategy and the 4 phases: Data Aware, Data Literate, Data Fluent, and Data Affluent. Discover where your company falls and how to move to the next phase of development. Don’t forget, if you enjoyed this episode, be sure to help others find our show by leaving us a review on your favorite Podcast Platform. Also in this episode: Rackspace Acquires SharePoint911 ML Ops ML & Algorithms Hit the Bigtime, w/DataRobot's Diego Oppenheimer Data Robot FinOps.org CloudReach Seinfeld: Jimmy's Jumps High Silver Fox Advisors Parenthood – TV series Keebler Tato Skins Facts of Life Theme Song Different Strokes Theme Barney Miller Theme A Most Generous Mentor, w/ Microsoft's Dany Hoter Raiders of the Lost Ark – warehouse Crossing the Chasm - book Speak Softly but Pack a Mean Elbow, w/ Jen Stirrup City Slickers - One Thing

Aug 30, 2022 • 1h 15min
Setting Up For Success w/David McKinnis
Today we welcome David McKinnis of Tech DNA to the show. David is Microsoft alumni from the days before the development of Darwin, the software that revolutionized install, uninstall, and repair for Windows-supported programs. Prior to Rob and Dave’s work on Darwin, software installation was a long and cumbersome project that often-included multiple floppy disks and the patience of a saint and Windows uninstall was rarely considered. Post Darwin, those tasks are often taken for granted. While the development process was bug-riddled, the result was reliable performance, seamless integration, and several great stories. This episode isn’t all about software and development though, we already did our first Software Hall of Fame episode. This is about the people behind the process and their trials and tribulations. To understand those stories, we must pull back the curtain on the ever-evolving internal development process of Microsoft and shine a light on what goes on behind the conference room doors. Also today, David and Rob reminisce about how Rob was ambushed in a meeting by a rival development team. That team came prepared with multiple handouts explaining why Rob’s project sucked. Don’t worry, they also share the resolution of the story and how fate (and the Fed) intervened on Rob’s behalf to salvage the program . . . and Rob’s credibility. That is a story you won’t want to miss, and it is only found here, on Raw Data by P3 Adaptive. As always, if you enjoyed this episode, be sure to leave us a review on your favorite podcast platform and subscribe to have new episodes delivered straight to your inbox. Also on this episode: Gartner on the cost of Windows Fed sues Microsoft Mitch Hedberg - Picture when I was younger TEALS Program– Microsoft Technophobes Make Amazing Technologists, w/ Kerry Kolosko A Single Complete Leader, w/ P3 Pres and COO Kellan Danielson Orange Theory Fitness

Aug 16, 2022 • 1h 30min
The Software Hall of Fame, w/ Microsoft's Conor Cunningham
Today, we bring you a little something different, in this episode, we focus not on people, but on the software itself. Today, we create the Software Hall of Fame, set the rules, and get down to building the inaugural class with special guest Coner Cunningham. Coner’s multi-decade software skill set combined with his fun personality makes him a perfect fit to be the final member of the initial tribunal of software critics. This tribunal will step up to fill a long-standing void in an episode that will run the gamut of emotions: Joy, anger, exasperation, and maybe even a little zen. Shockingly, this episode may even set a record for the most words spoken during an episode by co-host Thomas LaRock due to the sheer volatility of the topic at hand. The rules are simple, to be approved the nominees must be a product (can be free but cannot be a protocol), be software, and be judged on three criteria: Novelty, Difficulty, and Impact. To be inducted, the product must achieve an overall score of four points or higher. As a bonus, we have compiled the software and have curated a special website just for this episode. It is a work in progress and you should be able to submit your feedback on our choices by leaving comments, questions, concerns, and/or character assassinations. Since no Hall of Fame episode would be complete without a sports reference (or two) Rob also includes sage wisdom concerning what constitutes a sport . . . or what SHOULD constitute a sport worthy of watching on TV. Some of those choices are sure to be more controversial than the software picks so be sure to listen to the end and see if your favorite sport made the cut and which could make the cut by implementing paintball snipers. It is sure to be surprising! As always, if you enjoy this episode, connect with us on social media to be a part of the conversation and to recommend future guests and topics. Also in this episode: The Software Hall of Fame Toward the Sounds of Chaos: 30 Clerks, The movie Leaders Need Not be Flashy, w/ Microsoft VP Dave Gainer Leisure Suit Larry Red Dead Redemption

Aug 9, 2022 • 1h 29min
A Most Generous Mentor, w/ Microsoft's Dany Hoter
Today, we welcome to the show the most transparent international man of mystery, Dany Hoter. Working on his 5th stint with Microsoft and living his best life in his 8th decade, Dany brings both wisdom and fun to those around him. He brings a passion and joy for teaching to his training sessions and always manages to create a connection between people and technology. Of course, he also has a long-storied past with Rob, and together they share the responsibility for what some view as the most expensive trip billed to Microsoft by non-executives. From luxury accommodations to indulgent automobiles, they expensed it all. It wasn’t all global jet setting, however, as these two comprised the Dream Team that put the polish on Power Pivot and laid the groundwork for Power Query. Their hard work and dedication paid off as Dany and Rob banded together in their shared time at Microsoft to save the world from an error-filled, rushed incarnation of bi-directional relationships. In retrospect, however, the conversation about this brought up a story that many may prefer to never hear. It seems that amidst all the jet setting, our dear host, Rob Collie, was busy launching a cruise missile with the sole purpose of pissing off the advanced pivot table users. What heinous act did he commit? Rob was directly involved in changing the default of pivot tables to compact. While it did enlarge the user base by helping people feel more comfortable with pivot tables, advanced user rage is still alive and well on Twitter. All of this and more on this episode of Raw Data by P3 Adaptive, where data meets the human element. If you enjoyed this episode, be sure to leave a review on your favorite platform to help others find us! Also on this show: Tinkering is a Way of Life w/ Darinee Louvau Yoda Chong and the Treehouse of Wonder, w/ Donald Farmer The Italians – Marco and Alberto Ikigai Venn Diagram Silicon Valley: Movember clip - mustache filter Kusto v SQL KQL - Kusto Query Language Cube Functions in Excel Rob on Twitter – to allow more bashing on the compact view

Aug 2, 2022 • 53min
Technophobes Make Amazing Technologists, w/ Kerry Kolosko
Hello friends! On the show today, we have a special treat for you. Straight from the Outback, recorded past midnight, and punny as hell, Kerry Kolosko, freshly minted, accidental Microsoft Data Platform MVP. An avid fan of JIT learning (Just In Time) and a follower of the teachings of Google, Kerry is a self-professed technophobe whose desire to remove redundancies just won’t let her disconnect. She has a storied past of chasing answers and creating solutions. She truly is living the dream by dabbling in every interesting technology that comes her way. From Array formulas to Deneb, learning on the fly to save time and frustration is Kerry’s superpower. That’s not all! Today, we also dig into the age-old question of what hidden fear do many Power BI users share? That great shared doubt when someone asks for the .PBIX file. The irrational trepidation. The spurt of adrenaline. What one small, inconsequential fear do most OG Dax pros share? BADAXAPHOBIA: The fear of being judged for less attractive DAX coding. Well, friends, we are here to tell you that it is an unfounded fear is. OG DAX was more readable, easily digestible, and inherently more interesting before it was streamlined into mere code. Rob and Kerry agree that bad DAX should enjoy a comeback, and nobody should fear embarrassment for writing human-style DAX. All this and more on today’s episode. Don’t forget, if you enjoyed this episode, send a link to a friend. Friends don’t let friends miss Raw Data by P3 Adaptive where we celebrate data, with the human element. Also on this episode: "MVPness" Doesn't Sound Quite Right w/ MS MVP Ed Hansberry Deneb - Declarative Visualization in Power BI What is Data May Never Die w/ Scree Kerry Kolosko Blog - Visualisations Leaders Need Not Be Flashy, w/ Microsoft VP Dave Gainer LetterKenny: Power BI Workout Abbey Road Paint.net Mullet Man - Dax The Way

Jul 26, 2022 • 1h 13min
Tinkering is a Way of Life w/Darinee Louvau
Today’s guest, Darinee Louvau, is twice retired from Microsoft and one of the few people who admit to an admiration of testing in production. Darinee is an amazingly gifted person. From hosting LAN parties in her Tween and Teen years to designing and building gaming crates for those parties, she is not afraid of getting her hands dirty. A self-proclaimed fan of lowering the cost of iterations, she moved up quickly through the ranks to become program manager for Microsoft on projects such as Answers, Bing, and even the streaming service, Mixer. She is a hands-on thinker, doer, and creator. We can guarantee you will never find anyone else with her can-do attitude. Darinee shares how she personally prepares for inevitable mistakes in one of her hobbies by sewing with thrifted sheets to reduce costs. Using thrifted materials empowers her to make mistakes and continue to iterate. By using cheap materials to power each testing iteration she can lower the overall cost of iteration to get straight to the thing that matters, testing a solution against the actual live circumstance of what you really need to know. (Psst! Darinee . . . your inner developer is showing. 😊) Also in today’s show, we learn the answer to the age-old question of “What happens to the code when Microsoft kills it” as well as the secret behind how search engines return answers. The one thing you won’t find in today’s episode is a binary answer about success. Darinee explains that it doesn’t exist and if you think it does, you are setting yourself up for disappointment. Sage advice for our listeners. If you enjoy this episode, be sure to leave a review on your favorite platform as reviews help new listeners find us. And be sure you subscribe to receive new episodes in your inbox every week. You never know what you will hear when data gets raw! Also in this episode: Command and Conquer Duke Nukem 3D Quake LAN party Mixer – Microsoft streaming shuts down Home School Valedictorian by Adelitas Way Chris Rae Podcast Episode Raspberry Pi The Useless Box Microsoft Bob - Killed by Microsoft Halo Reach in Firefight mode Toyota Century Darinee on P3 Adaptive Blog - A 48 hour case study from Bing - Zero to Sixty :) Lost wax method in 3d printing

Jul 19, 2022 • 1h 23min
"MVPness" Doesn't Sound Quite Right w/ MS MVP Ed Hansberry
With a background in finance and a history of great communication and a passion for problem-solving, Ed Hansberry, an Assistant Director with P3 Adaptive, embodies the spirit of P3 Adaptive. Ed was recently awarded his 13th Microsoft MVP Award so of course, we wanted to know more about his achievement, his passions, his adaptability, and most of all, his insights on change so we invited him to join us today for a chat. Early on, in the conversation, Rob and Ed delve into defining change and that led to a lively discussion on the process of change, the successful process of change, and the difference between them. Here’s a hint, it’s always the people! Knowing that people drive success, Ed extensively volunteers his time in the Microsoft Power BI User Community supporting users around the world with problems and questions around Power BI and, since he has been recognized as a Super User by Microsoft, we really can say that helping people is his superpower. He is leading change one question at a time. This episode isn’t just about change, though, the evolution of technology and software is embedded throughout the conversation from cube functions to the hidden power of the innocuously named OLAP dropdown in Excel. And finally, we get some great insight on formerly cutting-edge technology that has since gone obsolete. We hear a firsthand account of the tragic end of the Microsoft phone. You never know what you will learn when the conversation starts to flow. As always, be sure to leave a review on your favorite podcast platform and tell a friend about Raw Data by P3 Adaptive, where data meets the human element. Also on this episode: iPaQ N NTP Not Necessarily the News NNTNs: All about Sniglets That Tufte book . . . MDX in Excel Cube Functions in Excel Disconnected Slicers with DAX Variables & SELECTEDVALUES Field Parameters in Power Bi Skynet Yoda Chong and the Treehouse of Wonder, w/ Donald Farmer Tabluar Editor DAX Studio A Single Complete Leader, w/ P3 Pres & COO Kellan Danielson Who Moved My Cheese

Jul 12, 2022 • 1h 3min
You’ve Gotta (Bruce) Buffer Your Data w/ Alex Sanabria
As we continue to share the personal stories of the exceptional people who make up P3 Adaptive, today’s guest is a little less visible in the company, not because of his skills or reputation, but because he is not a member of our visible client services team. Alex Sanabria is a member of the GroDiv team here. His team is on the backend, taking care of marketing, digital assets, and all things PR. While he may not be the public face of P3, he perfectly embodies the spirit. He is scrappy, dedicated, determined, and most of all, he has a big heart to bring to any challenge. Today, we are bringing you the story of a man from a humble background who followed his family’s advice and struck out to make his own luck. And make his luck he has. As our Digital Marketing Architect, Alex puts the adaptive in P3 Adaptive. With a long history of just-in-time training and dedication to skills acquisition, he has made it his business to learn whatever skill is necessary to get the job done without waiting around for someone else. He is self-taught and capable of finding outside-the-box solutions and is often finishing the project while others are still spooling up. His motto: Interaction leads to opportunities. While we hope you enjoy this episode, we also hope that these personal stories let you see the people behind the reputation. At P3 Adaptive, we are and always will be people first. If you are looking to make a change and have crazy skills in the Power Platform, take a look at our careers page. Perhaps the next great story we share will be yours! As always, if you enjoyed this episode, feel free to leave us a review on your favorite podcast platform. Also in this episode: Jelly Belly case study Good Will Hunting: Education vs. Intelligence P3 Adaptive name change CoverHawk.app Coverhawk: Hawking Data and Stymying Offenses, w/ Coach Chase Hargis P3 Adaptive Foundations: Power BI course P3 Adaptive Level Up Series: Power Query for Power BI course September by Earth Wind and Fire Shark Tank – training fight The Crazy 88s The Longest Yard