Graphing a series of multiyear forecasts vs. actuals can provide insight into forecast accuracy and methods. This graph looks at a series of revenue per share projections for Apple Note that none of the forecasts showed the exponential growth, but assumed essentially linear growth. (the forecast lines are gray and extend for multiple years. Actuals […]
Monthly Archives: June 2012
PowerPivot is a great free add-in for Excel from Microsoft that enables sophisticated business intelligence solutions and dashboards in three ways: Process millions of records from multiple databases, files, and other data streams Join tables and data in Excel , specify relationships without needing build queries in SQL or Access. Build sophisticated analyses based on […]
Cartogram of the US election in 2004. The size of each box is proportional to electoral votes, color is the candidate, and layout/shape is roughly the same as geographic placement. From this it’s possble to see the West, Northeast and Northern Midwest …
Heat map of soccer field: the soccer field is divided into twenty 5.35m segments. The numbers represent the total number of passes from that section. Colors are correlated with numbers of passes (green — yellow — red are low to high). From Rational Football blog.
How do open source data analysis and visualizations by individuals compare to big data projects by data scientists using cutting edge software and infrastructure? Some clue may lie in looking at the impact of blogging on professional journalism. A few years ago I worked for Lycos and helped launch a blogging tool. Blogging was pretty […]