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
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.
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.
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.
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!
Bespoke Cloud Solutions
Explainly offers bespoke cloud-based technology solutions for your specific business needs.
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.
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.
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.
Corporate Training
Explainly offers corporate training through self-paced online courses in addition to designing custom training curriculums for your business, led by experts.
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.
Introduction to PowerQuery Updates
Introductory course receiving light updates for Excel 2019 plus all new audio tracks.