Have you ever wondered what an actuary is? If so, you are not alone. Over the past several years, the actuary programs at universities nationwide have seen exponential growth, thanks in part to an outreach program called Be An Actuary supported by P3 Adaptive’s Principal Consultant and today’s special guest, Philip Trick. Philip is a rarity in the data world. He found his data gene all the way back in high school and has continued to add additional skills as software has evolved to reduce or remove monotonous tasks such as data cleansing and repetitive calculations. While he came to Power BI and Power Query late in the game, he has become an ardent supporter of the Power Platform’s ability to handle complex data and calculations. He is also one of the few people to publicly admit to possessing an inherent love of the DAX iterators.

Today’s conversation gets technical and covers multiple advanced iterators as well as some interesting statistical problems that get even more complex when you change the variables. While we don’t often talk shop on the show, that isn’t the case today. In an interesting twist, we also learn why some keyboards are missing the F1 key. Here’s a hint, when speed is of the essence, nobody wants Office to open the help pane.

All this and more on today’s episode! Be sure to leave us a review on your favorite podcast platform and subscribe today to have new episodes sent straight to your inbox.

Also on this episode:

Blade Runner

Star Wars- Episode IV

Do androids dream of electric sheep

Laurence Kotlikoff

Minecraft

Modeloff Financial Modeling Competitiion

A mechanical clutch isn't a steampunk purse w/ Bill Sundwall

Mary Poppins -Song compilation

Shared birthday probability

P3 Adaptive Blog: Product X

Casualty Actuarial Society

Wolf of Wall Street

Along Came Polly

Fight Club Insurance Claim Scene

Epistemic Path Dependency, w/ Adam Harstad

Tom Brady un-retirement

Rookie Pay Lacks Negotiation

Edgeworth Box Diagram

Prisoner’s Dilemma

Nash Equilibrium

The Great Football Project Rides Again (In Power BI)

Power BI Brain Candy: Value Above Replacement