Raw Data with Rob Collie

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