Author: david.taylor

January 14, 2019 david.taylor

Here’s a tip for Power BI that gives you the ability to get more control over placement of numbers in your charts and tables. TIP: Use filter context within a custom measure. In this example I’m creating a chart using a simple data set of Actual and Forecast values. The trick is to create a…

October 26, 2017 david.taylor

Business is often fast paced and on the move. Your data doesn’t need to be left back at the office. Here’s how to use PowerApps to keep critical information at your fingertips at all time. Step 1 – Establish a connector to your data source Step 2 – Create a PowerApps application for your smartphone…

September 3, 2016 david.taylor

Exploiting business opportunities ahead of the competition relies upon strong analytical tools which are agile yet are also powerful. Analysts within the business need such tools to be useful out of the box but will also need them to support advanced techniques when necessary. Spreadsheets have always been the tool of choice for financial analysis and financial modelling. What about for data…

June 19, 2016 david.taylor

“What-if analysis” goes visual using Power BI Financial models in Excel are usually limited to calculating results for a single scenario at a time.  “What-if analysis” allows financial models to also calculate results for other scenarios; varying the underlying drivers and assumptions. Visually compare many scenarios As a decision maker, why not look at the results for several…

June 19, 2016 david.taylor

World Class Financial Modelling – starts with a simple rule of thumb Financial models underpin so many important business decisions the world over.  Why then are they often such a challenge to get your head around? How can we do better? Firstly, consider the arbitrary nature of spreadsheet layout and style. Financial Models from different developers can be as…