Listen Now

On today’s episode, Chuck Vigeant, founder/CEO of Clearify, entrepreneur, speaker, leadership consultant, golf aficionado, and, the mastermind behind QQube, brings his most interesting stories of XML, ETL, and even some PGA. He discusses the frustration of accessing data in QuickBooks, sometimes a download can take 12+ hours. For many QuickBooks users, workarounds have become too complicated and time-consuming so they have resorted to deleting data yearly to save time. Can you imagine? Deleting data to access data? It’s madness! Don’t worry, though, Chuck explains how Clearify provides an interface to give users a method to bolt QuickBooks up to Power BI through the QQubes ETL engine. Bottom line: he and his team put in the time and energy so that the users can reap the rewards of Power BI. He makes sure the data won’t be locked in. And, as an added bonus, he even throws in some great calculations for good measure (pun intended) as well as access to create custom calculations as needed. It is an interesting visit, for sure, with Chuck asking some very thoughtful questions of our hosts. There may even be a genealogical tie or two that makes him family.  Overall, his data story is more about helping others and making the world a better place. What more can you ask for than a feel-good story of data, positive energy, and contagious happiness. As always, if you enjoyed this episode, be sure to leave us a review on your favorite podcast platform and tune in next week for more Raw Data by P3 Adaptive. Also on this episode: QuickBooks Peachtree Accounting Jack Welch – Cut the bottom 10% The DAX Draft Rob Collie - Women in Data podcast appearance The Power Ranking Godfather, w/Jeff Sagarin & Wayne Winston Ratatouille - Life Lessons Multiplicity - Michael Keaton UnFrozen Caveman Lawyer

On today’s episode, Alice Drummond, co-founder of DiscoverEI gives the inside scoop on transitioning from environmental engineering to Microsoft Power Platform MVP.  She shares her story of building a consultancy firm from the ground(water) up while increasing her own skill set. She and Rob wax poetic on the struggles of taking the plunge into the small business owners’ realm and neither sugarcoats the challenges faced. During the course of the conversation, a common thread emerges on the people who advocate for the firm and seek to move to the Power Platform. Early adopters want revolution while the early majority want evolution. The bottom line, most companies are just getting started. This episode isn’t just about starting a business, though, we get to hear the real, human side of the story. Alice highlights the best parts of the learning process: teaching, sharing knowledge and empowering others. As always, if you enjoyed this episode, be sure to leave us a review on your favorite podcast platform to help others find us. Then, click subscribe for new episodes delivered straight to your inbox! Also in this episode: Fortran Daniel Marsh-Patrick Denali Crossing the Chasm: Book Upright: Season 1

When its winner takes all, it’s the unexpected choice that provides the most impressive results. Who made the bold moves? Three Power BI DAX experts duke it out in a game of "Choose it or Lose it" with 8 cutthroat rounds of DAX Draft! Your competitors: Rob Collie – the founder of P3 Adaptive. He wrote the book on DAX. Ed Hansberry – a 13-time Microsoft MVP with an extensive track record of creating innovative DAX solutions both in the community forums and for his clients. An avid chess player who is always two moves ahead. Leigh Ann Thibadoux - an incredibly skilled DAX P3 Adaptive expert who fuses her specialization in Finance and Accounting skills with her passion for process automation to rapidly create innovative DAX solutions. Bill Sundwall – P3 Adaptive Expert and today’s guest referee, Bill has a passion for expanding the data community via education and mentoring. The Challenge: DAX DRAFT Our host Rob Collie invented the game, chose his competition, and made up the rules... but can he win? The competition will be tough. Most importantly, will Rob’s OG DAX outmaneuver modern refined DAX? The Rules are simple, eight rounds with a total of 24 functions taken off of the list with the remaining functions available to everyone. The remaining, undrafted functions at the end of the exercise are open for use by all. Once the draft has occurred, the question is: can you survive without the functions drafted by the competition? To keep our players honest, guest referee Bill Sundwall will if an actual workaround exists. Bill’s ruling will be final. Can Rob Collie’s Street DAX scrape by? Will 13-time Microsoft MVP Ed Hansberry’s mental compilation of functions and chess moves prevail? Or can scrappy P3 Adaptive newcomer Leigh Ann Thibadoux blindside both? Listen now to find out! Think you have what it takes to take down the DAX Draft winner? Let us know on social media and be sure to check out our career page for current openings! If you enjoyed this episode, be sure to leave us a review on your favorite podcast platform.

In this episode, Brian Knight, founder of Pragmatic Works, describes his accidental entrance into the field of technology. From a chance job offer to being “that guy” who hit the server rebuild button, you won’t want to miss this data origin story.  Only someone like Brian could get such a great start by nuking a database and turning it into a DBA career where he would become both a prolific community member and content creator. While reminiscing with Tom about SQL and the glory days of being a DBA, Brian admits that his focus has recently shifted to Power Apps. When asked why he shares that the lure of building in a couple of days what in the past would have taken several years was just too strong.   It isn’t just about the past, though, as the crew gets into a lively discussion on AI and its future impact on the arts. No spoilers here but it may just be that AI can be a beneficial part of creative society, not by replacing people as artists but by augmenting the existing skillset of current and future artists in a similar way the Power Platform enhanced skills of people in tech to create the Citizen Developers we all know and love. If you enjoyed this episode, be sure to leave us a review on your favorite podcast platform to help others find us.   Also on this episode: SQL Server Central Tom’s blog: Operations Manager and SQL Server Septic Companions and Breaded Capacitors, w/ Chris Rae GitHub Copilot Open AI Two QB Rob Blog Cat in the Hat: Calculatus Eliminatus

Today, Nicole Janeway Bills, community organizer for Data Strategy Professionals, stops by with the inner scoop on data training, cryptocurrency, tokens, scandal, fraud, and the trauma of moving. At the time of recording, Nicole was an employee of FTX. During the podcast, she shared tales of last-minute relocations and the expense of attaining career goals right as an unraveling began. As a full-stack engineer with an exceptional data background, Nicole was able to find the bright side of her incomplete move by utilizing the extra time she discovered to further assist others with their certifications. Among the topics discussed in this episode, Rob and Nicole delve into the perceptions of data people, developers, and engineers. They determine that, historically, having the data gene anecdotally meant you weren’t on the leadership team. Some data professionals were even told to stop talking about data and spreadsheets to move up. Fortunately, times have changed, and a seismic shift has been made to encourage data proficiency for all levels of an organization.   Additionally, just for fun, Nicole shares a subtle meeting tip: Forget Rob’s Scotty Principle on looking busy/important, go with the lunch principle. Eat during the meeting to show that you are working very hard the rest of the day! If that doesn’t work, go with the field principle. Roll up your sleeves for the same effect! If you enjoyed this episode, be sure to click the link below and subscribe for weekly episodes delivered directly to your inbox.  Have a data day! Also on this episode: FTX Bankruptcy Yoda Chong and the Treehouse of Wonder, w/ Donald Farmer Medium – Stay Curious OG I Can Has Cheezburger Meme Coach Mike Tomlin interview Crypto-Fantasy Leftists are an Exclusive Tribe, w/ Davis Mattek Speechless Samuel L Jackson: Hostage Scoop Software Hall of Fame: Raw Data by P3 The Software Hall of Fame Website P3 Adaptive Training P3 Adaptive Careers Pulp Fiction: Jules Winnfield Rob Collie Episode of Data Engineering podcast War Pigs Jonah Hill Glass Onion: A Knives Out Mystery

On today’s episode, we sit down with 11-time Microsoft MVP Belinda Allen as she shares her accidental data origin story. As the co-author of two books and a prolific Power Platform blogger, Belinda has a unique perspective on business intrigue, data discoveries, and reporting solutions. With her penchant for pivot tables, she is a classic example of a citizen developer, and she generously shares her knowledge with the communities at large through her writing, public speaking, and training. In fact, for several years she was a top contender in the Excel Shootout series, and while underappreciated, her sentiment analysis provided food for thought and innovative inspiration for businesses across the size spectrum and helped convert many people to the Power Platform.   Today, she joins Rob in a fascinating recollection of the birth of the Power Platform. From the genius evolution of Power BI through the first incarnation of Power Pivot through the initial attempt at Power BI in SharePoint, they followed Siren’s call of DAX and Power Query to navigate the ever-changing waters of data analytics. Together they recount the challenges of mastering the self-serve data revolution while sharing their appreciation for Power BI. Also on this episode: Data Explorer Power Pivot Distinct Count What happened to Microsoft's Convergence conference? Mariana Gomez: Power Platform Flic buttons Seth Goden's blog Chris Wagner Canvas Apps Microsoft's Sentiment Analysis

Today, we reunite two old friends with a penchant for writing books for people adjacent to tech as we welcome Miguel Escobar to the show. If you use Power Query or Power BI, you might have heard of Miguel. He is the co-author of several books on Power Query, Power BI, Power Pivot, and DAX. He is also part of the expert trifecta that created Skill Wave training and he is now an integral part of Microsoft working to make Power Query better for all users. He and Rob reminisce about book deals, DAX, training, and writing in a voice for the people, instead of for the tech giants. But, most importantly, you get the inside scoop on the data-cleaning drudgery that was Excel and analytics before the DAX and Power Query data revolution.  Miguel and Rob trade entertaining stories of how Excel gives people a competitive edge in the job market but somehow remains a fundamentally underappreciated skill during the educational years. After all, it’s not just about the tool, what matters is what people do with it, how they use it, and how it has changed the trajectory of their careers. After hearing a few of these stories, you’re going to want to send a tweet to Tom to encourage him to finally admit that Power Query deserves a spot in the Software Hall of Fame. This episode isn’t all about Power Query, though as we also learn a little about the eclectic taste in music our hosts share as well as some interesting tidbits regarding songwriting and the musical process. Miguel opens up about his passion for music and composition as he shares some personal insight into the process of collaborating and creating music in the digital world. If you listen closely, you can even hear some of his work spliced into this podcast in a musical first for us. Of course, you can hear Miguel’s song: Someday, Somehow (feat. Chris Cron) in its entirety across multiple musical platforms. Be sure to give it a listen and share it with a friend. As always, if you enjoyed this episode, be sure to leave us a review on your favorite podcast platform to help others find us.   Also in this episode: Good Will Hunting – I don’t understand the piano Jerry was a race car driver Miguel Escobar: Geo Flow using Panama's Census Data DAX formulas for power pivot: A Simple Guide to the Excel Revolution Major Key / Minor Key culturally different Box Office Mojo Mr. Excel M is for (Data) Monkey Bell Biv DeVoe Johnny Cash: Hurt Blues Traveler: Hook Rocksmith Guitar Pro Power Query online Software Hall of Fame Podcast Power Query Saves Christmas w/ Gus Miranda

On today’s episode, we sit down with P3 Adaptive’s own Justin Mannhardt to get the inside scoop on delivering results and backing into data infrastructure, aka the origin story of P3 Adaptive’s Solutions Architect Team and the impact it can have on an analytics project. Justin explains the expanded focus to fulfill analytics needs through a more holistic approach to drive adoption and deliver results. With his own experience, he explains how results must sometimes come first as a proof of concept but once results are verified, more support is often needed to ensure a smooth functioning process. Rob often refers to this as the faucet first analogy, and it has the power to convince the exec team that analytics can be fruitful for businesses of all sizes. We don’t just talk shop, though, we also learn how Justin discovered his affinity for data after an educational background in music. And, for fun, you get to hear Justin’s P3 Adaptive Diabolical Assessment story and how he increased his data skills and learned Power BI because he wanted to work for P3 Adaptive. He gets brutally honest about his interview and shares how he exited the process the first time only to come back and ace the process to become one of P3’s finest solution architects! Additionally, you can hear about the recent P3 Adaptive employee retreat in Miami where many of our team met face to face for the first time and, to sound a little cheesy, it was a lot like coming home. Family pranks and tacos by the pool makes a great feel-good story as we come into the holiday season. Finally, if you enjoyed hearing Justin’s story, be sure to catch him next week presenting at the PASS Data Community Summit. Justin will be on site with the P3 Adaptive team sharing his knowledge and presenting a session on snapshotting your CRM data with Azure Synapse. Be sure to catch him live or on the hybrid video feed. If you are in Seattle, stop by the booth and tell him Mullet Man sent you. He’ll know what you mean! Also on this episode: Why was Ronald McDonald cancelled? Faucets v Plumbing blog Bugs Bunny left turn at Albuquerque Mel Brooks - Space Balls Did Cortez burn his ships in the harbor? P3 Adaptive Advanced DAX training Chumbawamba This is Pop Abba episode Def Leppard – Pyromania Rob P3 Fantasy Football gloat video Meatloaf – Two Out of Three Ain't Bad

Today’s guest, Gustavo Miranda, started his career in a research adjacent Program Evaluation position using Power Pivot Slicers in a non-Power Pivot table before he was introduced and lured by the power of the Power Platform. He shares his story of how reducing friction and creating automation introduced even non-data people to the concept that data quality matters. Most importantly, though, today you will learn the underdog story of how Power Query saved Christmas during the Kronos Hack of 2021. Get the inside scoop from crisis meeting to crisis meeting until the moment when Gus stood up to save the day. While Gus did the heavy lifting, a task force soon formed to collectively finish the project. While other multi-million-dollar companies were paralyzed, shocked, and attempting to ad-hoc calculate payroll and vacations, often incorrectly, Gus’s task force used Power Query to create an effective solution in time to prevent employees from missing Christmas with their families. Even Tom must agree that tales like this really show the power of Power Query’s ETL abilities. Also in today’s episode, we learn the origin story of slicers in Excel, how Rob and Amir were behind their creation by seducing the Excel team, trading resources, and creating the opportunity for Microsoft to back into needing a separate application to maximize the impact of those slicers. That application? Power BI desktop. In an exciting tale of what could have been, we also hear the story of the Power BI canvas in Excel that was never meant to be as well as the lessons learned: never try to add truly new capabilities to Excel or you end up with Power View. As our friend Scott Esti used to say there are two kinds of people in the world, people who hate Power View and those who haven't used it! All this and more on today’s episode! Be sure to leave us a review on your favorite podcast platform to help new listeners find us. Also on this episode: Nash Equilibrium / Prisoner's Delimma The truth behind recycling Program evaluation He may only need his eyes checked ... Calculation Groups in Power BI Microsoft's Power View Gilligan’s Island theme song Zeno's paradox Gus's P3 Blog - Using Power Query to Transform and Combine Online Statscan Data Matt Masson - Deep Dive Into the Power From the Language Active v Inactive Relationships Kronos hack disrupts payroll Live action How the Grinch Stole Christmas Live action Cat in the Hat Abyss - Bomb at the bottom of the sea (Don't look Tom!) Rumble in the Jungle George Foreman - Muhammad Ali Guns and Roses – It’s so easy Blown Away – Tommy Lee Jones Tommy Lee Jones Montage Sankey (Diagram) Fight Club - Corn Flower Blue G Rated Fight Club

Today we welcome to the show Scott Louvau, twice retired from Microsoft and now focused on his Relentless Optimizer blog, he is our second twice retired from Microsoft guest. If his last name sounds familiar, it should be. Several weeks back, his partner, Darinee Louvau was our guest. Her absolute enthusiasm caused us to seek out the other half of the equation and invite Scott to share his take on life at and after Microsoft as well as his data origin story. How exactly did Scott go from a small vineyard in North California to being twice retired from Microsoft and what set him on the technological path? Like Darinee, games were Scott’s gateway drug to technology. While growing up in a home with software programming parents, Scott was exposed to how programs work and most importantly, granted access to tinker with the hardware side as well. Frustration with slow gameplay or loading freezes led to the educational process as Scott learned to free up resources, jettison drives, and optimize the remaining parts to make the gameplay better, faster, and longer.  In a time when there was no internet full of resources available, debugging issues was both more challenging and more intense. Back in the day, if you wanted to play, you had to make it work on the system you had. Scott used these hard-earned skills between high school and college as he started working as an internal software developer before switching to a programming track at college, falling in love, and joining the dream team at Microsoft. He found joy in automation both for Microsoft’s clients and for his team, going on to reduce frustration in debugging while increasing optimization in the process.  It isn’t all programming and coding today though, as we also delve into Starbucks Cold Brew Refill Hacks and using AI to dominate game levels.  Stuck on a level of Kingdom Rush? You can find a solution for that and more, in this episode. As always, if you enjoyed this podcast, be sure to leave us a review on your favorite podcast platform to help others find us. And, be sure to subscribe below for new episodes delivered directly to your inbox. Also on this episode: Tinkering is a way of life w/ Darinee Louvau Apple IIGS Luggable Computer Power Builder Paper Games of Kids in the 90s Terminator gets squashed STUXNET: The Virus that Almost Started WW3 Visual Studio Visual Slick Editor Inverted word index A most generous mentor w/ Microsofts' Dany Hoter Ballmer's Peak Google eats RAM cookies Scott’s Relentless Optimizer Blog Try xForm Kingdom Rush Kingdom Rush AI Boom Beach World of Warcraft Subscription Fees Vanguard ownership/profits

On today’s episode P3 Adaptive Principal Consultant extraordinaire, Narayana Windenberger sits down for a chat on data, travel, and the ethics of the financial markets. Nar is a 5-year veteran of P3 with an unforgettable name and a penchant for being a digital nomad. Whether he is working from the Midwest, Germany, or enjoying hang gliding in San Diego, Nar puts the remote in remote work and regardless of his location, still creates epic analytic masterpieces.  Nar also has the distinction of being the author of a P3 Adaptive blog that shook the Power BI world to its core in 2020 and earned him the title of Power BI Super Villain. His blog on the DAX function invented to optimize other DAX made such an impact that a disclaimer had to be placed to temper the responses. It isn’t all fun and games, though, Nar, Rob, and Tom also delve into the inner workings of financial markets and hedge funds and attempt to differentiate between the evils of a hedge fund and the potential benevolence of a hedge fund manager. When are losses a gain and gains a loss? Listen to today’s episode to find out! Don’t forget to leave us a review on your favorite podcast platform to help new listeners find our show. Also on this episode: Where in the World is Carmen Sandiego Tandem hang gliding Why do Hawks Circle Myth Busters: Bubble Trouble P3 Blog: Distinct count in PowerPivot V2 is Much Faster Ray Dalio: Principles Former Facebook Executive Eminem I'm Still Standing Wall Street: Money Never Sleeps Far Side comic: Wolves/Neighbors P3 Blog: OPTIMIZEDAX Good Will Hunting The Software Hall of Fame, w/ Microsoft’s Conor Cunningham What is Data May Never Die, w/ Scree Chess online

On today’s episode, we sit down with educator, researcher, and all-around information guru Simon Peyton Jones to learn all about programming languages and their impact on hardware, software, and research/development. Simon also brings some professional insight into Excel as a programing language. Oddly enough, around the time Rob met Simon, Rob began to think of Excel as a programming language. In order to be a language, the formulas have to deal with both space and time, so Excel formula language absolutely fits the bill. Just be careful how you code. On older systems, if you perform a VLOOKUP at the same time as a nested IF, it might disrupt the space-time continuum and bring about the blue screen of death! As an engineering fellow at Epic Games, a researcher for Microsoft Research Cambridge, and a professor at Glasgow University, Simon also brings a unique perspective on changing the educational system to include base learning on computer science as part of general education. Not only did Simon step up and suggest change, but he also followed through and created a coalition to guide the program and ensure future expansion as needed. When Simon talks about research, people listen! As always, if you enjoyed this episode, be sure to leave us a review on your favorite podcast platform to help others find the Raw Data by P3 Adaptive Podcast Also in this episode: Simon Peyton Jones’s bookmarks! Alonzo Church – Lambda Calculus Touring machine Automata Theory LAMBDA: The Ultimate Excel worksheet function. (Andy Gordon, Simon Peyton Jones) LISP functional language Microsoft Research – Cambridge Arthur Norman – functional programming John Backus Turing Award Setting up for Success w/David McKinnis Declarative Programing Immutability Changes Everything Computing at School – CAS Scratch - Computer Programming Logo - Apple Estimating the value of Pi using Monte Carlo Code.org Tesla One-Way Valve Turing Tumble Robo Rally Board Game Unreal Engine Joe Duffy on Transactional Memory Haskell Language

Today we bring in the big guns, a Microsoft MVP and Power Platform advocacy team lead, and a true Power Platform aficionado: April Dunnam. In the realm of social media, April is known as the Woman who Codes, the SharePoint Siren, and the Karaoke Queen with a passion for all things Power: Power BI, Power Apps, Power Automate, Power Virtual Agents, and Power Pages. In this episode we get April’s origin story, starting with the moment she was the intern tossed into the deep end of the SharePoint pool, all the way to her personal discovery of the better way. April shares her philosophy on bringing people to the dark side of app building: First, find someone who has a certain level of curiosity and knows there has to be a better way. Those are the future Power Apps Citizen Developers. Hook those people with the polished side by showing them a functional app, then reel them in through the backend drag and drop, no code, low code magic that is the Power Platform. April explains that people tend to have a short attention span; they need the finished product before you show them how simple the build process can be. Later on, Rob and April discuss the biggest opportunity for improvement in the Power Platform, the lack of a consistent programming language. With the build-by-example function in Power Apps, the technology is growing and, April suggests that one day there may be a unified Power language. Until then, Rob will continue to hate M and use his phone-a-friend card for help in Power Query. All this and more in this episode. And don’t forget, if you enjoyed this episode, be sure to leave us a review on your favorite podcast platform to help others find our people-centric data podcast. Also in this Episode: April Dunnam’s Youtube Paul Giamatti Le Café de Balzac The Evolution of SharePoint w Denise Traboona and Adam Harmetz The Man of a Thousand Jobs w/ Kevin Overstreet Lego Mindstorms InfoPath Into the Dataverse w/ James Oleinik Power Virtual Agents GitHub CoPilot and GPT-3 Power Users Microsoft Site April O’Neil - TMNT

In today’s episode, we welcome Eric Vigesaa of Microsoft to the show. This special guest has a decades-long relationship with our host.  According to Rob, Eric can always be counted on as a partner in cynical observations. Rob describes Eric as one of the rare breeds that enjoy the excitement of building an emergency solution. Someone who prefers a shorter distance between the software and the problem. The closer he is to impact, the more satisfying the solution becomes to him. Sardonically, Eric is also like the groundhog of Microsoft, emerging from IT, looking around, seeing the shadow, and returning back to IT: empowered, passionate, and skilled. Eric describes his non-IT time as an evolutionary course that allowed him to explore and grow his aptitude. Also in today’s episode, Rob and Eric describe the beginning phase of Microsoft’s shift to computing in the cloud and the project carnage in its wake. Promising projects suddenly found themselves on the road to nowhere and are now, nowhere to be found . . . with one popular exception: streamlined conditional formatting. That simplistic innovation not only made it out of the darkness to see the light of day but also became Rob’s gateway drug to audience participation. Other innovations weren’t so lucky. Eric and Rob describe what happened to a multitude of promising projects that were sliced, diced, julienned, and unable to survive cloud modernization at Microsoft. The history might pull you in, but it’s the dry wit that will keep you through the end. As a bonus, today you also get at least one bad Star Wars joke . . . and don’t forget, if you enjoyed this episode or the joke, please leave us a review on your favorite podcast platform and be sure to subscribe to get new episodes delivered to your inbox. Also in this Episode: The Software Hall of Fame, w/ Microsoft's Conor Cunningham Queen’s Gambit Mike Tomlin Interview - Your teaching is failing Kill Bill Relief or Regret Power Pivot and Power BI: The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016 - by Rob Collie The Cloud is Powered by People w/Jeff DeVerter The Evolution of SharePoint w/ Denise Trabona and Adam Harmetz Winchester Mystery House A Most Generous Mentor w/ Microsoft's Dany Hoter Skynet becomes Self-Aware Blade Runner - Tears in Rain

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

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

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

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

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

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