twitter-mono
facebook-mono
linkedin-mono
youtube-mono

SOME OF OUR LATEST THINKING

The accuracy of your IRRs and NPVs depends to a large extent on the quality of the assumptions that go into the financial model. However, there is one element that also affects the accuracy of the calculations.
read more >

Many finance problems inherently involve circular calculations. The most common of them is balancing the balance sheet. So how do we typically solve such kind of modeling problems?
read more >

In his brilliant book Beautiful Evidence, Edward Tufte—nicknamed the Leonardo da Vinci of data by The New York Times—introduced six principles that he calls the fundamental principles of analytical design.
read more >

We've always been fascinated by the concept of “time”. It's probably the most important concept known to mankind and has long been a major subject of study in religion, philosophy, and science.
read more >

DATA VISUALIZATION

FINANCIAL MODELING

BUSINESS MODELING

Adopted public policies affect everyone—they're called public for a reason after all. Nowhere is this truer than in the realm of defense policy.
read more >

The danger of using the wrong metrics for policy making how-accurate-are-your-irrs-and-npvs Avoid circularity in financial models Edward Tufte analytical principles compared with what to find seasonality use cycle plots how accurate are your IRRs and NPVs

It’s useful to distinguish two types of average measures: Simple average (or arithmetic average) and weighted average. Both—simple and weighted averages—are widely used in practice but each type is more appropriate to use than the other for certain purposes and applications.
read more >

Don't average averages. simple average versus weighted average The ecological correlation fallacy

If you ask a group of data analysts and data visualization experts to choose the most important chart type to display data, most probably “The scatterplot” would be the response you’ll get. And they have a point.
read more >

Review of the book The Functional Art by Alberto Cairo

Outside the realm of hard sciences, I generally follow a simple heuristic to identify books worth reading. 1) Read books that have been in print for 15 years or so. 2) Break rule #1 for books written by authors who have in their portfolio at least one book that passes rule #1.
read more >

EXCEL CHARTS

how to create a Fourfold Chart in Excel how to create a Non-ribbon Sankey Diagram in Excel how to create a Waffle Fourfold Chart in Excel using Conditional Formatting how to create a Bar Chart with color ranges in Excel How to create a Dot Plot in Excel How to create a Lollipop Chart in Excel how to create a Horizontal Bar Graph with endpoints How to create a Bivariate Area Chart in Excel how to create a Dumbbell Chart in Excel How to create a Fan Chart in ExcelTufte in Excel - the Bar ChartEdward Tufte in Excel The Box PlotEdward Tufte in Excel the SlopegraphHow to create a Strip Plot in ExcelHow to create a Grid Map in ExcelHow to Create a Grid Map with Sparklines in ExcelHow to create a scatterplot with dynamic reference lines in ExcelHow to create a Heatmap in ExcelThe Ecological Correlation Fallacy Part 2Edward Tufte in Excel The Dot-Dash-PlotHow to create a Grid Map with circles in Excel

When you look at correlation, when you hear correlation you’ve got to be suspicious. Learn how not to be fooled by relationships that are completely spurious.
read more >

How to Create a Bar Chart With Labels Above Bar in Excel

The Data-Ink ratio is a concept first introduced by Edward Tufte—in his book the Visual Display of Quantitative Information. It can be summarized—in Tufte’s own words—by the fundamental principle of statistical graphics: Above all else show the data.
read more >

I pity tables. Most of us demote them to the bottom of the data visualization food chain—all too often for the wrong reasons. This is unfortunate because tables could be—in some instances—better than graphs at presenting information.
read more >

Graphs are essential to good statistical analysis. Both summary statistics and graphs should be studied in any data analysis—since each will contribute to understanding.
read more >

Anscombe QuartetHow to create a scatterplot matrix in ExcelTufte in Excel - Sparklines