Raw Data By P3 Adaptive

On today’s episode, we sit down with Tristan Davis, Product Manager at Microsoft for the Office Platform. That’s right, the person in charge of the team in charge of extensibility and advancement of the Office Suite of programs shares some insight and exciting news about the current path and the future of the most commonly used platform.  You will hear about security, advancements, and maybe even a secret reveal or two from the upcoming BUILD announcements.  Exciting news is coming for increasing both productivity and security in the new virtual workplace of Office 365. (Here is a hint: Have you seen the new Automate Tab in the Excel web app?) Most importantly, we learn about the future of VBA as Microsoft looks to revamp the process for added security, leaving the good but reducing the opportunity for evil, viral usage. Additionally, during the course of the conversation, Rob and Tristan revisit the Bedlam email as well as the current method of preventing future occurrences.  This episode is full of trivia and innovation. You won’t want to miss it! Also on this episode: James Olenik Dataverse episode Wazzu Virus Brian Jones Episode The Bedlam Email Storm: Microsoft Reply All Storm Fix BUILD Mark of the Web: Macros disabled

Today we welcome the newest member of the P3 Adaptive family, Liz Rogers as she shares her relentless pursuit to find a better way. Liz’s story highlights the rarest hybrid data type yet, those with a self-sufficient mindset who are translators between the process/tech and the customer/user experience. This data type truly focuses on improvement across all segments. Her passion for figuring it out brought about both immediate, visible impact and scalability to every position in her career. Throughout today’s talk, Liz highlights the most persistent of data traits, she has always insisted on having the opportunity (and the ability) to try, fail, and then figure it out. Often, in a business setting, too many people focus only on success and frown upon the failures that are hyper-critical to the learning process. Without the opportunity to fail, however, you end up with people who want to be baby bird-fed data who lose the desire to utilize the most incredible, self-service tools of the Power Platform. These are the opportunities where the puzzle solvers thrive when people like Liz grow and evolve into true Power Platform superheroes. You won’t want to miss this episode! Also in this episode: Donald Farmer Episode Hans Rosling Ted Talk Bubble Chart How I built this Podcast Scree Podcast The Cult of the right Thing

Today we welcome Blythe Morrow, owner of Paper Sword, to the show. She shares her SQL-adjacent/data-adjacent data origin story and the details of her love affair with both language and data. We also get inside insight into Paper Sword’s technical writer onboarding and development with a special shout-out to Tom LaRock’s Solar Winds podcast episode on the Disappearing DBAs. The ability to marry good writing with technical skills can help you clarify your message and build trust with your stakeholders. Even if you aren’t a writer, learning how to talk to and convince people about Data Platform technologies can elevate your skills as a data professional. In addition, Blythe shares the secrets of binging shadow IT into the light through the shared strength of various software, adaptability, and scalability. Her history working with PASS means that she has the knowledge and the network to effect change within the data community. She joins us here to get you pumped about data. Join us today as we learn to write a data adventure!   Also on this episode: P.A.S.S. Data Community Summit Women in Technology STARTOFMONTH– DAX OPENINGBALANCEMONTH -DAX Marco Russo and Alberto Ferrari Cujo Monty Python Rabbit Power BI Sentinel AWS Reinvent Conference Mad Men Carousel Mike Reynolds on Raw Data by P3 Adaptive Solar Winds Podcast: The Disappearing DBA

In this episode, we break down the newest phrase to come out of the Power Platform this year with James Oleinik, Director of Project Management with Microsoft. His team owns the experience for PowerApps, and he joins us to define Dataverse and explain how it is integrated to create a seamless data transfer across all Microsoft products. Using simple language, he provides insight on the low code platform that provides the scaffolding to connect, import, and integrate a wide variety of a company’s data. According to James, all data is Dataverse data, and anyone can be a low code developer! James clarifies that Dataverse is not SQL and could never be just storage. Instead, it is the framework, management and logic you need to create structured access to your data estate and the ability to build much-needed apps on top of it. Don’t worry if you aren’t up on the lingo, Host Rob Collie breaks it down to Power BI comparisons before we learn about exciting developments in Virtual tables and Power Effects. You heard it first on Raw Data by P3 Adaptive, the Excel language and the VBA surface of yesterday is the Dataverse Table Power Effects and Power Apps of tomorrow. Join us today as we go into the Dataverse and beyond! Also in this episode: We’re Hiring! InfoPath Dynamics 365 Donald Farmer Episode FrankenSpark Zara and Zenubia Kahn Episode

Mapping the Road to Innovation, w/ Mike Reynolds On Today’s episode special guest Mike Reynolds defines digital product and the genius behind InnovateMap. Mike explains that businesses must go digital if they touch a consumer or risk losing relevance. While most consumer-facing companies have embraced this tenant, many B2B companies just haven’t accepted this yet and those who have are advancing quicker than ever. Rob and Mike also discuss Covid bonding and the pattern analytics that helped companies ride the storm. Revisiting the past couple of difficult years, the takeaway is clear, Covid19 was a wake-up call for businesses to expand their digital product and their office flexibility. Finally, Mike, Rob, and Tom discuss the great remote work migration and why it works for some and not for others, and the future of remote work. As an added bonus, during the conversation, Rob shares the history of Mullet Man and his connection to Mike and InnovateMap. You too can learn how the great icon of Raw Data by P3 Adaptive was created. Also on this episode: Mad Men: The Wheel Wordle Seinfeld water cooler Buck Rogers robot, Twiki Far Side Thumb wrestler March Data-Ness - The Method Behind the Madness Jack In the Box Commercial

On today’s episode, self-described accountant by trade and a problem solver by passion, Fran Reed of Freedup Data Optics shares how she uses her data bending skills to remove the frustration of working with an on-premises accounting software build. Fran is one of the rare go-betweens of the Power Platform and Intuit’s Quickbooks. She makes easy work of bridging the gap between numbers and decision-makers to design the best solution for both her large and small business clientele. With the ability of Power Query to cleanse and transform data to the perfect format for the transition to QuickBooks, the low/free entry cost and Fran’s recommendation may just tip the scale to bringing more small businesses to the fold. Fran also shares her data origin story. While she has always been a numbers person, Fran developed an early appreciation of software and took the first opportunity to transition away from the antiquated accounting technology of the past like Micro Fiche machines and Exacto knife/scotch tape corrections to computational files and automated calculations. Beware, however, that today’s episode may also result in a few laughs as host, Rob Collie drops the mother of all Dad Jokes. You do not want to miss this episode. Also on this episode: Sit Ubu Sit Stay Thirsty My Friend Mary Fealty Podcast Allison Kennedy Podcast Tim Rodman Podcast  Mr Excel Podcast Chandoo Podcast

On today’s episode of Raw Data by P3 Adaptive, we welcome Allison Kennedy to the show. Allision is a Certified Microsoft trainer and MVP specializing in Excel but, according to her, that just means that she is a puzzle solver, number cruncher, and an Excel aficionado. Allision is one of the rare data gene types who loves teaching others to embrace their data for the good of humanity or for one-upping Australia. A true educator at heart, Allision’s data origin story involves transitioning from Mechanical Engineering into education, first with languages in Spain and then with all things data on the other side of the world in New Zealand proving that with the right data skills, you really can go places. In addition, we hear about her other passion: meditative free diving. Recently certified as a Four Start Advanced Master freediver, Allison can reach depths of 32 meters on a single lung full of air (don’t try this at home).  On the topic of freediving, Rob shares a Pop Collie anecdote, and we have a good laugh at the wiliness of the Collie family in pranking the younger generation. How? No spoilers here. You’ll have to listen to find out this and more on today’s episode. Also on this episode: Pavlova Just-in-Time Training Chalk Dust Torture - Phish George Carlin Joke – Original Version VLOOKUP Power BI Summit Attribution Bias Four Star Freediver Freediving World Record Pop Collie Blog Post Power BI Community Forum Chalk Dust Torture – The Lyrics Lars Schreiber – P3 Adaptive Podcast

On this episode of Raw Data by P3 Adaptive, we set a new record for the number of times the word “Wow” is used in a single episode. What could possibly impress our veteran hosts to the point of leaving them speechless except for single-word answers? We’re glad you asked. Today, we host Zara and Zenubia Kahn, 11-year-old twins on a mission to inspire young girls in STEM and turn the Power Platform world on its head. Hailing from Pakistan and currently residing in Singapore, these sisters have a track record of setting and breaking goals at a young age by earning certifications in both Microsoft Power Platform and in Azure AI by the age of 10. Since becoming Power Platform Superstars, these amazing young ladies have participated in many global events espousing the importance of STEM education and motivating both children and adults alike to learn new skills. As a result of their hard work and dedication, Zara and Zenubia have been awarded the National Youth Award for 2021.  Zara and Zenubia Kahn are grade 6 students who enjoy swimming, cycling, and the exciting wizardry world of Harry Potter. Oh, and also, they are the youngest certified in Microsoft Platform and Azure AI professionals. At age 11 they are already dividing projects, assigning responsibility, building apps, and inspiring young women everywhere. Sit back and listen as our hosts learn the inspiring story behind their success. Also on this episode: Microsoft Learn World Food Organization Face API from Azure Kahn Academy Freakanomics Zara and Zenubia on LinkedIn STEM Lori Rodriguez Raw Data By P3 Adaptive Podcast GitHub

It seems fitting for the week of Saint Patrick’s Day to include some Shamrocks. This week, we welcome to the show, Jeff Lingen from Shamrock Foods Company. Boasting 15+ years of data management and BI development, Jeff is the Director of Business Intelligence and Analytics and a coder of DAX from way back. Today Jeff gives us the inside scoop on his data origin story of escaping the data drudgery behind finance and moving into the analytics field and beyond. Like all carriers of the data gene, there was a moment of realization for Jeff that non-mainstream ideas could enable and empower business users to be more self-sufficient. Naturally, this new age thinking created some friction with the OS I.T. but Jeff persisted until he proved to himself and others that Power Pivot and its successor, Power BI, could enable sophisticated modeling and analytics. Even though this road was more difficult, Jeff was determined to give his users the tools to find joy in data. Through extensive use of the P3 Adaptive Blog, Jeff moved away from flat reporting to Power BI to push his self-service message and further his career. As an exciting plot twist, Jeff even talks through his experience of briefly defecting from Power BI to Tableau before returning to the Microsoft fold. You won’t want to miss this episode. Also on this episode: The Great Football Project Bilbo Baggins Back again Edward Tufte Calvin and Hobbs time machine Eisenhower Matrix Communication Breakdown Baker’s Dozen Kimball data warehouse style Reddit Bananas Entropy and the Arrow of time Roller hockey Kohlrabi juice

Today on Raw Data by P3 Adaptive, we check in with past guest Matt Selig of @Barkeeperfriend to see how post-project implementation is going.  In this visit, Matt brings coworker Christina Roark, Controller and VP of Digital Marketing, to discuss using Power BI to create visual stories to create a social media marketing department and fine-tuning inventory reporting -- in the middle of a pandemic -- to bolster continued growth. While no plan survives its initial implementation both Matt and Chrissy assure us that the Power Platform is more than a match for anything that 2022 can throw at it. Listen in as they discuss the common threads in business growth during a global pandemic: good product and exceptionally agile BI. While other companies were struggling to bubble up insight, the team at Bar Keepers Friend was using rapid prototyping to discover areas of opportunity and to triage existing data processes and management. As Chrissy put it, you must take care of your data before it gets to the software if you want the reporting to be accurate. Dashboards will bring issues to light, internal issues with processes that you must fix for people to rely on reports and dashboards. Want to know more? Read the BKF / P3 Adaptive Case Study Here. #BarKeepersFriend Also in this episode: Bar Keepers Friend commercial Bar Keepers Friend Matt Selig's First Raw Data by P3 Adaptive Podcast Tim Rodman Podcast episode: The Numbers that Didn't Exist, with Tim Rodman John Hancock Podcast episode: Crimefighting with a Data Model, w/ John Hancock Automated Taco Machine Pilot Flying J scandal Monty Python's Life of Brian Kurt Vonnegut's Jailbird Dino Cursor The red stapler