Raw Data By P3 Adaptive

Get your popcorn ready and get ready to be entertained by our latest episode! In this episode, our host Rob Collie is joined by our data visualization and reporting specialist, Dave Rivera, who showcases the power of the Power Platform in his recent project to find the answer to a complex data question: "Which movie had the most decorated cast based on having received an Academy Award for acting?" Using Power Query to scrape Wikipedia and Power Automate to gather information from IMDB, Dave created an elegant and accurate solution in under eight hours. He then ranked the actors by nominations and wins, created a ranking system for the movies based on the cast involved, and displayed the data in a user-friendly format using Power BI. In this episode, Dave takes us through his journey of tackling this complex question and showcases the power of the Power Platform in making the solution simple and efficient. So sit back, grab your favorite snack, and tune in to learn more about data visualization, reporting, and the amazing possibilities of the Power Platform! As always, if you enjoyed this episode, be sure to leave us a review on your favorite podcast platform to help new listeners find us. Also in this episode: BestMovieCast.Net IMDB Academy Award Nominees on Wikipedia The Player Glass Onion – Hugh Grant Every Stan Lee Cameo Ever (1989-2018) The Greatest Story Ever Told Charlton Heston – Moses Parts the Sea True Romance

Get ready for an exciting episode of Raw Data by P3 Adaptive!  Our guest today is Mike Nichols, a consumer technology and entertainment leader with a proven track record of building growth businesses and exceptional organizations. He's none other than the former Chief Marketing Officer at Xbox, who played a critical role in turning around the Xbox One release with his customer-centric and innovative marketing campaigns featuring #AaronPaul and #DannyMcBride. But that's not all—our guest also had a significant impact on the development of Microsoft's search engine, Bing, which was originally launched as Microsoft Live. Mike also shares his data journey and some inside information on how he brings people together to drive growth and build iconic brands. He shares his insights on customer-centricity, innovation, diversity, and teamwork, and how these principles have guided his leadership throughout his career. From Xbox to Bing, our guest has left a lasting impact on the tech industry, and as a bonus, we even get to learn the truth about what "BING" stands for and what Mike knows about the naming process. It's not all facts today, though, we do get a little speculation as Rob, Mike, and Tom delve into a fascinating debate about the divorce rate at Microsoft. Tom proposes a theory on the durability of first marriages for the first generation of Microsoft employees, and Rob and Mike weigh in on whether the overall rate is higher than the general public's and, more importantly, whether the rate is higher for Microsoft employees who were closely associated with Rob Collie. Is it the Microsoft Effect or the Rob Collie Effect? Regardless, this interesting discussion sheds light on the impact of work culture on personal relationships and the challenges of maintaining a healthy work-life balance in the tech industry. Join us for an episode that is both entertaining and thought-provoking, as we explore the people behind the tech and the impact of work culture on personal relationships. This is an episode you won't want to miss! And, as always, if you enjoyed this episode, be sure to leave us a review on your favorite podcast platform to help new users find us. Also on this episode: Windows live search – Bing The Software Hall of Fame, w/ Microsoft's Conor Cunningham Microsoft Team Manager Asana Needle Nose Ned Happy Families are all alike: Anna Karenina Aaron Paul Xbox Commercial Danny McBride: More is Better Xbox commercial Bada-Bing: Sopranos DOJ v Microsoft: Antitrust Case summary Malcolm Butler Game Winning Interception! Super Bowl XLIX Anchorman 2: News Team Fighting Words Scene

Get ready to tune in to the next episode of Raw Data by P3 Adaptive, where former P3 Adaptive superstar Fred Kaffenberger will be returning as a guest. Rob and Fred will be reminiscing about old times and geeking out over all things Microsoft. But the real kicker? Fred will be revealing a shocking confession: he once faced Rob's dreaded "Interview of Doom" having only known what V-LOOKUP was for 2 years! What happened next? Well, let's just say Fred didn't let that minor setback hold him back from becoming a data wizard. Before joining P3 Adaptive, Fred worked as a white paper writer, where he was told he didn't have the "voice of the customer." But Rob knew better, recognizing Fred's talent for helping people get the most out of technology and a near clone of his own voice, Rob knew Fred had the talent and the skill to excel at P3 Adaptive. Today, Fred is over at Oracle, where he's transitioned from writing about migrating from Oracle to Power BI to migrating from Power BI to Oracle. Talk about a change of pace! But true to form, Fred is still a tech wizard, constantly expanding his skillset and crushing it in the world of DAX. As for his introduction to the world of data, it began in sales and moved to data and debugging. Eventually, Fred moved on to database work where he learned one of the most important lessons anyone in the tech field can use: the value of being concise when communicating with developers. As he discovered, the more words you use, the more room there is for interpretation, and nobody wants that. As always, we hope you enjoyed this episode. Be sure to share your thoughts by leaving us a review on your favorite podcast platform. Also on this episode: Fred's Data Adventure blog 5 signs you have ADHD and autism by Yo Samdy Sam  William Dodson MD on the Interest-based Nervous System (ICNU)   Fatima the Spinner and the Tent by Idries Shah   Zork online Discrete mathematics Referential integrity Oracle Analytics Cloud Oracle Release 2--the first commercially available relational database to use SQL  Get Out Nope Excel Power Map Diplo Naomi Shehab Nai Pirates of Silicon Valley k-means Clustering

Today, we're doing something a little different. We're going to focus on a true, unfiltered story about people in the tech industry, and more specifically, about one of the most powerful figures in the field - Bill Gates. Some might even say he's one of the most powerful men in the world. This story had a profound impact on Rob, and we're excited to share it with you. You know, when people find themselves in uncomfortable situations, they often develop coping mechanisms. Some people might talk excessively, or tell bad jokes, while others might shut down completely. Unfortunately, there are also those who lash out at others when they feel uneasy, which can create a negative impression of them. As humans, we tend to form our opinions of others based on our interactions with them. If the only time we've seen someone is when they're being a bully, it's not exactly a great first impression. This story was accidentally cut from our episode Good Design is the Cake, Not the Icing, w/Brad Weed, but we felt it was too important to leave out. It's a human interest story that highlights the struggles and challenges we all face, no matter who we are. It might not be a feel-good or funny story, but it's special because it's so relatable. At some point in our lives, we've all found ourselves on the outside looking in, trying to find a seat at the table. And that's what makes this story so universal - it speaks to all of us. Thanks for joining us as we dive into this compelling tale.

Today's guest is Dan Battagin, a former program manager for Microsoft and the genius behind Adventure Taco! Dan has an impressive track record as the former lead developer of Microsoft's Power Query as well as experience with multiple other software programs. We're excited to have him on the show, especially since he only agreed to appear in order to learn about Rob's video background. But once the conversation gets going, you will realize that Dan has a wealth of expertise in data cleansing and transformation that we can all learn from. As the conversation progresses, we also get a glimpse into Microsoft's hiring practices of the past. Remember those brain teasers and psychological questions that used to be all the rage? We discuss how these inane questions often resulted in great candidates being passed up, simply because they didn't fit into the expected answer patterns. Fortunately, times have changed and we get to hear the story of how Rob helped keep Dan on at Microsoft after his initial internship. In addition, Dan brings with him stories of his internship at Microsoft and the stories of programs ending before their time. And, as frequently happens, the conversation takes a turn to DAX and unsurprisingly, Dan is another former Microsoft manager who is not a well-versed DAX user. As Rob points out, DAX is the most accessible language to come out of Microsoft which leads us to question why so few former employees embrace the magic.  All this and a few Lego and Age of Empire references you won’t want to miss. And don’t forget, if you enjoyed this episode be sure to leave us a review on your favorite podcast platform. Also on this episode: Brain Teasers for your next interview prep Age of Empires Ways to Fix Excel Not Recognizing Date Format Adventure Taco Fantasy Football DAX Functions Power Pivot and Power BI: The Excel User's Guide to DAX Soda Machine Brain Teaser 12 Men on an Island Brain Teaser LEGO Modular Buildings

On today’s episode, Charlie Ellis, former Program Manager at Microsoft and expert on the heart of excel, the calc engine, sits down for an amazing conversation. He brings with him stories of the evolution of Office that began with the retooling of Excel 2007. That reboot went on to become a veritable restart of the program that nearly wiped the slate clean by creating what would in essence become a new, more responsive product.  With so many big changes happening at the same time inevitably there was some pushback from the users. Fortunately, for modern users, those changes were pushed through and eventually removed a ton of the frustrations of the original Excel. This recording was unique. Emotions ran high, personality types were broken down, and all parties involved pulled back the curtain on their inner selves. Instead of just focusing on Impostor Syndrome, in this episode we hear more about being neurodivergent and how that can affect the work-life balance as well as the work personality that our coworkers are exposed to through social compassion.  Of course, when things get that real, some conversations have to be taken with a grain of salt and ultimately removed from the episode. Don’t worry, at the end of the day, as with every episode and every topic, we all remain friends and perhaps even grow a little closer because of the conversation. Through thoughtful redirection, everyone involved artfully steers the conversation back to less dangerous but no less interesting waters. While you don’t get to hear it all, you won’t want to miss this episode. As always, if you enjoyed this episode, be sure to leave us a review on your favorite podcast platform and be sure to share it with a friend. After all, friends don’t let friends miss Raw Data by P3 Adaptive. Also on this episode: The Ocean - Led Zeppelin All my Love - Led Zeppelin Leaders Need Not be Flashy, w/ Microsoft VP Dave Gainer La La Land La La Land Jazz Christmas Scene A Single Complete Leader, w/P3 Pres and COO Kellan Danielson What Are ActiveX controls Septic Companions and Breaded Capacitors, w/ Chris Rae Buckaroo Banzai - What is that even? Mike Grant - Ultimate Hall of Fame Furious George vs Condors - Ultimate National Championship Paint.net The Power Ranking Godfather, w/ Jeff Sagarin & Wayne Winston Mark Cuban Crashed my Lecture w/IU's Dr. Wayne Winston Was Excel really originally intended for the MAC? Train Tracks and Chariots . . . really?

Today, special guest, Brad Weed of Interplace waxes philosophical about his and Rob’s shared time at Microsoft and we discover where the seeds of ethical capitalism were planted. He is a former designer at Microsoft who worked on every release of Office from 1992-2007 and played a major role in defining and refining the company's design and user research disciplines. He is an incredible entrepreneur with a passion for innovation who may forever be known as the perfector of the Microsoft Ruler. Brad built upon his work as at Microsoft to become the founder/CEO of Interplace. With the use of the latest IoT technology, Brad's company is committed to developing sustainable transportation solutions that address major global challenges like urban congestion and climate change. He stops in today to chat about the importance of using IoT technology to create sustainable transportation solutions. Brad's vast experience in design and user research makes him a pioneer in the industry, and his passion for addressing global challenges, like urban congestion and climate change, is second to none. As they delve into the topic, Brad shares his unique perspective on how IoT technology can help change the way we think about transportation and the environment. Don't miss out on this insightful conversation between old friends as they explore their history and the choices they made to find a better path for the future.   Also in this episode: Kurt DelBene - Will Microsoft muscle rescue Healthcare.gov Excel is the Most Functional of Programming Languages w/ Simon Peyton Jones Microsoft Ruler Solid State Active Cooling The Cult of the Right Thing - Rob Collie Readily Ticket’s Series of Fortunate Events, w/ David Wood Delft University r/Slow history Guns Germs & Steel

Today, we welcome David Wood, founder of Eventene, to share the story of his exceptional journey through the ever-evolving field of computer technology and the extensive digital transformation it has undergone over the years. David will take us back to his high school days, where his interest in technology was first sparked by the purchase of a scientific calculator with programming capabilities. While nowadays, your cellphone may hold more computing power, back in the day, a programable calculator with 210 programable steps, 21 memories, and a full complement of scientific functions was the bleeding edge of technology . . . and for David, it was his gateway to the world of technology. David shares his journey from that calculator to personal computers and discusses his personal induction into the world of coding through VisiCalc and Unicode. He draws a parallel between the impact of spreadsheets and the digital transformation that is currently taking place in his chosen field of event planning. With the advent of cloud computing and smart mobile devices, event planning is undergoing a transformation, and David, thanks to his work with the Boy Scouts of America, is at the forefront of this change. As a result of the mass quantity of data required to plan a scout event, he became the creator of Eventene, an online software solution that promises to revolutionize event planning. David envisions Eventene to become as essential for event planners as spreadsheets are for working with numbers and data, saving time and effort for years to come, regardless of the scale of the event. This is a story that promises to be insightful and entertaining. After all, you have to enjoy reminiscing about the technology of days gone by. And, as always, if you enjoyed this episode, don’t forget to leave us a review on your favorite podcast platform.   Also in this episode: The Impostor Syndrome World Championships, w/ Jocelyn Collie HP-34C Calculator TRS 80 computer Yoda Chong and the Treehouse of Wonder, w/ Donald Farmer Unicode, in friendly terms: ASCII, UTF-8, code points, character encodings, and more The Great Football Project Rides Again! MoneyBall -- The Art of Winning an Unfair Game Billy Beane Setting Up for Success w/ David McKinnis It’s Time for an Event Planning Moment The Book that started it all:Power Pivot and Power BI - Rob Collie The DAX Draft ChatGPT

Today’s guest, Jocelyn Collie, is the co-founder of P3 Adaptive, and she brings a story or two to share with you on impostor syndrome. But what is impostor syndrome? Have you ever felt like a fake or a fraud despite your accomplishments? That is impostor syndrome.  It's when you don't believe in your own abilities and attribute your success to things like luck or outside help or even view yourself as less accomplished or mediocre. And despite what you might think, it’s surprisingly common, especially among people, like Jocelyn, who are highly successful. Jocelyn’s story is an incredible journey of overcoming barriers through an almost chameleon-like ability to add to her skill set. No matter where she was, she mastered an ever-growing skillset. Waiting tables, playing musical instruments, writing code, and even jamming for a roller derby team, she really has been there and back again. But you must ask yourself, was she blending in, or was she standing out for self-teaching what others could only dream of learning? Find out on today’s episode! And, as always, if you enjoyed this episode, be sure to leave us a review on your favorite podcast platform! Also in this episode: Tinkering is a Way of Life w/Darinee Louvau Why is Everything So Slow w/ Scott Louvau Environmental Engineering Meets the Data Gene, w/ MS MVP Alice Drummond Hello Everybody - Rob's Blog Camelot – The Holy Grail Anchorman: The Legend of Ron Burgundy Art Hellyer The DAX Draft The Sea Gals Grave Danger Roller Derby Grave Danger Group Photo with Natalie Fatality

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