Philip Trick

Philip Trick

Philip is a practicing property and casualty actuary as an associate of the Casualty Actuarial Society. He attended Boston University and graduated Cum Laude with a MA in Economics.

Philip Trick
Members Public

Present Value, Perpetuities, and You

Almost every part of your financial life involves present values and perpetuity calculations. From your monthly mortgage payment to your credit card balance to your student loans, all of your financial obligations are somehow connected to the imaginative idea of a perpetuity - at least, in terms of valuing that

Philip Trick
Members Public

Quick Tip: Building Measure Tests in Power BI

Incorporate a unit testing framework into your Power BI reports with some simple measures combined with a matrix visualization.

Philip Trick
Members Public

QuickTip: Consolidate Excel Data

Consolidate data from multiple tables within Excel into one table using PowerQuery, a basic function, and a parameters table in under 7 minutes.

Philip Trick
Members Public

The Promise Of PowerQuery Custom Data Types

PowerQuery custom data types offer promise of bold and powerful new features in the future; however, their current implementation is currently limited to simple, non-hierarchical data.

Philip Trick
Members Public

Unit Testing in R, A Silly Mistake

Unit testing in R is straight-forward and easy so long as you remember to appropriately dive into your lists!

Ahad L. Amdani
Members Public

Bespoke Cloud Solutions

Explainly offers bespoke cloud-based technology solutions for your specific business needs.

Philip Trick
Members Public

Quick Tip: Build a Project Management Report

Explainly builds a share-able basic project management data capture and reporting system in 7 minutes. Learn how to build the report yourself and then interact with and add your own project data.

Philip Trick
Members Public

Introducing Microsoft's PowerApps

Microsoft's PowerApps makes web app development as easy as writing Excel formulas while dragging and dropping the pieces across a canvas.

Philip Trick
Members Public

Power BI versus Excel, Dashboarding

Our author Philip takes a year's worth of electricity usage data and builds a Power BI report to compare and contrast different electricity price contracts and gain some insight into his usage.

Philip Trick
Members Public

Corporate Training

Explainly offers corporate training through self-paced online courses in addition to designing custom training curriculums for your business, led by experts.

Philip Trick
Members Public

Quick Tip: Find The Missing (Data) Links

This QuickTip offers a quick use-case for PowerQuery's Merge command to connect data together in order to locate potential missing pieces.

Philip Trick
Members Public

Introduction to PowerQuery Updates

Introductory course receiving light updates for Excel 2019 plus all new audio tracks.