Category: Accounting and Finance

Reducing DSO using Power Pivot

One of the many things which amazes me about Power Pivot time after time is its ability to effortlessly convert raw data into crucial information as soon as it happens.

Written by on November 13, 2018

Coffee Talk: The PowerON Pros

Welcome to the latest P3 Adaptive Coffee Talk, where members of the community discuss various topics related to Power BI, Power Pivot, and Analytics/BI in general.

Written by on November 30, 2017

Quickbooks Analysis via QQube!

For a couple years now, we’ve been quite a bit bigger than the two-person operation of our early days.  Like I mentioned in a previous post, there are now somewhere between 15 and 20 people who work for us in some capacity ranging from full-time to part-time.

Written by on December 16, 2015

Commission Calculations using DAX Part 2

You may recall in my last post, COMMISSION CALCULATIONS IN POWERPIVOT, we got to the point where we could dynamically calculate the sales value and attributable commission rate that should be applied based on time, value and team parameters, reading from a Rates table.

Written by on May 15, 2012

Aged Debtors–Dynamic Banding in DAX

Guest post by David Churchward [Twitter] Having hit the P&L and Cash Flow in previous posts, it seems only reasonable to move on to Balance Sheet aspects.  The die-hard “non-accountant” Excel […]

Written by on April 17, 2012

Moore’s Law and Inflation

SQL Rockstar, aka Tom LaRock (Blog | Twitter) sent me a fascinating data set the other day:  a table of different computing devices over the years, their “horsepower” in calculations per second

Written by on March 13, 2012

  • 1
  • 2