<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0"
	xmlns:content="http://purl.org/rss/1.0/modules/content/"
	xmlns:wfw="http://wellformedweb.org/CommentAPI/"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
	xmlns:atom="http://www.w3.org/2005/Atom"
	xmlns:sy="http://purl.org/rss/1.0/modules/syndication/"
	xmlns:slash="http://purl.org/rss/1.0/modules/slash/"
	>

<channel>
	<title>The Data Cornerstone Blog &#187; Time Series</title>
	<atom:link href="http://www.datacornerstone.com/blog/?cat=8&#038;feed=rss2" rel="self" type="application/rss+xml" />
	<link>http://www.datacornerstone.com/blog</link>
	<description>Make our data the cornerstone of your business</description>
	<lastBuildDate>Tue, 26 Aug 2014 18:22:53 +0000</lastBuildDate>
	<language>en-US</language>
		<sy:updatePeriod>hourly</sy:updatePeriod>
		<sy:updateFrequency>1</sy:updateFrequency>
	<generator>http://wordpress.org/?v=3.8.4</generator>
	<item>
		<title>A New &#8220;Index&#8221; for The AEC Stock Market</title>
		<link>http://www.datacornerstone.com/blog/?p=354</link>
		<comments>http://www.datacornerstone.com/blog/?p=354#comments</comments>
		<pubDate>Tue, 26 Aug 2014 18:22:53 +0000</pubDate>
		<dc:creator><![CDATA[Doug Santo]]></dc:creator>
				<category><![CDATA[Data Analysis]]></category>
		<category><![CDATA[Prediction/Forecasting]]></category>
		<category><![CDATA[Time Series]]></category>

		<guid isPermaLink="false">http://www.datacornerstone.com/blog/?p=354</guid>
		<description><![CDATA[After scouring the web for AEC market data we got tired of coming up empty and decided to roll our own.]]></description>
				<content:encoded><![CDATA[<p><img src="http://www.datacornerstone.com/blog/wp-content/uploads/2014/08/Stock-History.svg" alt="Data Cornerstone AEC Stock Index" class="aligncenter size-full wp-image-369" /><br />
The graph you’re looking at is a fictional stock index made up of real stock data. After scouring the web for AEC market data we got tired of coming up empty and decided to roll our own.</p>
<p>We ended up pulling together 12 different stocks from companies that in one way or another practice architecture, engineering, and/or construction. If you know how much of this market is privately owned you are probably as surprised as we were that there were even 12 of these companies to find.</p>
<p>The results are pretty interesting and it’s too bad this isn’t a real stock. If you invested $1,000 back in January of 2006 you would have more than doubled your money by August of 2014 which seriously outperforms the general market. 2010, &#8217;11, and &#8217;12 all show what appear to be seasonal dips while 2013 was nothing but gains. The jury is still out on 2014 but our money says that the market is ripe for another small dip.</p>
<p>In the coming weeks we’ll be looking to automate the construction of this index which will enable us to deliver a daily market indicator to our readers. Stay tuned.</p>
]]></content:encoded>
			<wfw:commentRss>http://www.datacornerstone.com/blog/?feed=rss2&#038;p=354</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>ENR Top 500 Update</title>
		<link>http://www.datacornerstone.com/blog/?p=328</link>
		<comments>http://www.datacornerstone.com/blog/?p=328#comments</comments>
		<pubDate>Tue, 29 Apr 2014 17:42:33 +0000</pubDate>
		<dc:creator><![CDATA[Doug Santo]]></dc:creator>
				<category><![CDATA[ENR]]></category>
		<category><![CDATA[revenue]]></category>
		<category><![CDATA[Time Series]]></category>

		<guid isPermaLink="false">http://www.datacornerstone.com/blog/?p=328</guid>
		<description><![CDATA[The latest ENR 500 came out on April 15th so it’s time we said something about it.]]></description>
				<content:encoded><![CDATA[<p style="text-align: right;"><strong>ENR Top 500 Revenue Distribution</strong></p>
<p><iframe src="http://www.datacornerstone.com/blog/wp-content/uploads/2014/04/area1-2013.html" width="546" height="373" class="alignright" scrolling="no" frameborder="0"></iframe><br />
The latest ENR 500 came out on April 15th so it’s time we said something about it.<span id="more-328"></span> For better or for worse, there isn&#8217;t much to say. We re-ran the last analysis looking for major changes. The largest gains were seen by companies in the $1-$2.5B segment with a total growth of 40%. The second largest change in the market was followed by firms in the $25-$50MM segment with a total of $14.6% growth. The market overall grew approximately 3.5% in 2013 which is much better than the 1.9% growth in US GDP for 2013. The small overall growth percentage may be disappointing to some. It is characteristic however of a steady growth in the market that is likely to be more dependable then the erratic ~12% growth seen in 2008 that quickly deflated.</p>
<p style="text-align: right;"><strong>ENR Top 500 Combined Revenue</strong></p>
<p><iframe src="http://www.datacornerstone.com/blog/wp-content/uploads/2014/04/area2-2013.html" width="546" height="373" class="alignright" scrolling="no" frameborder="0"></iframe></p>
]]></content:encoded>
			<wfw:commentRss>http://www.datacornerstone.com/blog/?feed=rss2&#038;p=328</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Taking A Look Back At The Past 10 Years</title>
		<link>http://www.datacornerstone.com/blog/?p=174</link>
		<comments>http://www.datacornerstone.com/blog/?p=174#comments</comments>
		<pubDate>Tue, 08 Apr 2014 14:35:24 +0000</pubDate>
		<dc:creator><![CDATA[Doug Santo]]></dc:creator>
				<category><![CDATA[ENR]]></category>
		<category><![CDATA[revenue]]></category>
		<category><![CDATA[Time Series]]></category>

		<guid isPermaLink="false">http://www.datacornerstone.com/blog/?p=174</guid>
		<description><![CDATA[<p><img src="http://www.datacornerstone.com/blog/wp-content/uploads/2014/04/Post-2-Hidden-Image.png" alt="ENR Top 500 Combined Revenue" width="549" height="402" class="alignright size-full" /></p>
<p>Last week we looked at the ENR 500 and tried to pull out whatever interesting information we could find.&#8230;</p>]]></description>
				<content:encoded><![CDATA[<p><img src="http://www.datacornerstone.com/blog/wp-content/uploads/2014/04/Post-2-Hidden-Image.png" alt="ENR Top 500 Combined Revenue" width="549" height="402" class="alignright size-full" /></p>
<p>Last week we looked at the ENR 500 and tried to pull out whatever interesting information we could find. This week we turn back to the ENR 500 and take a bit of a deeper dive.<span id="more-174"></span> We aren&#8217;t taking the drawn out, step-by-step approach we did last time. Instead we’ll present some information and add our own insights where appropriate.</p>
<p><img src="http://www.datacornerstone.com/blog/wp-content/uploads/2014/04/Inline2-1.png" alt="Inline2-1" width="185" height="76" class="alignleft size-full wp-image-230" /></p>
<p>It has been about a week since the first post. We hope to maintain that kind of frequency. We will post whenever we have new or interesting information. Our goal with this blog is to aim for quality while providing some kind of regularity. We also want to give enough time to digest what may be “longer than average” blog posts.</p>
<p>In order to look at how the ENR 500 has changed over time, we took the last ten years of data and carved it up to see what might be of interest. What does it look like if we divide the firms into various &#8220;income&#8221; brackets based on their domestic (US) revenue? Here is that data in table form.</p>
<p style="text-align: right;"><strong>ENR Top 500 Revenue Distribution</strong></p>
<p><img src="http://www.datacornerstone.com/blog/wp-content/uploads/2014/04/Quantity-of-Firms-Table.svg" alt="Quantity of Firms Table" class="alignnone" /><br />
“What the heck am I looking at?” If we look in the top left corner we see that one firm earned between $2.5 and $5 billion dollars in 2002. Each value in the table is the number of firms that occupy that &#8220;income bracket&#8221;. Feel free to draw your own conclusions from these values. Tables are generally worse than graphs at showing changes in time so let&#8217;s graph it.</p>
<p style="text-align: right;"><strong>ENR Top 500 Revenue Distribution</strong></p>
<p><iframe src="http://www.datacornerstone.com/blog/wp-content/uploads/2014/04/area1.html" width="546" height="373" class="alignright" scrolling="no" frameborder="0"></iframe></p>
<p>This is hopefully a little more interesting. Perhaps a bit dated but we see a very clear (albeit delayed) indication of the recession. Just prior to the economy’s change, most ENR 500 firms were earning over $25MM (again, domestic revenue only). Leading up to the recession we see an expansion in both the $25-$50MM and $50-$100MM segments. This suggests that many firms crossed the $50MM threshold in the years following 2003. That trend started reversing in 2007 and didn&#8217;t actually bottom out until 2011. Perhaps more relevant and provocative is the apparent repeat of that shift in more recent years. Firms in the sub-$25MM range are decreasing and the number of $25-$50MM firms appears to be increasing.</p>
<p>This is good news for Consultants and Engineers that want to work for these companies. Perhaps a slight cause for concern however is the apparent lack of growth in the $50-$100MM and $100-$250MM segments. It is difficult to prove exactly what is causing this. We can however look into the possibility that the large companies at the top of the list are reducing the pool of revenue for everyone else. This graph is not the best way to answer that, so we should shift our focus away from the number of firms and more towards the combined revenue of these segments.</p>
<p style="text-align: right;"><strong>ENR Top 500 Combined Revenue</strong></p>
<p><iframe src="http://www.datacornerstone.com/blog/wp-content/uploads/2014/04/area2.html" width="546" height="373" class="alignright" scrolling="no" frameborder="0"></iframe></p>
<p><img src="http://www.datacornerstone.com/blog/wp-content/uploads/2014/04/Inline2-2.png" alt="Inline2-2" width="166" height="112" class="alignright size-full wp-image-231" />How did we get this graph? We started by taking the revenue from firms that earned less than $25MM, and added them up. Then we took the revenue from firms that made between $25MM and $50MM and added them up. We&#8217;re still using the &#8220;income bracket&#8221; analogy. This time however we combined the revenue for each of the companies in those brackets, instead of just adding the number of companies.</p>
<p>Why is this useful? It gives us one way of seeing where money goes, it also let&#8217;s us answer the question about big firms crowding out smaller firms. Prior to 2006, the $2.5B+ segment made up a fairly small percentage of the overall revenue earned by these firms (just under 6%). There was only one firm who even entered this category so not really all that &#8220;powerful&#8221;. Since then that segment has grown both in revenue and in number of firms. In 2012 there were 3 companies who occupied this segment taking up 17.6% of the market. Certainly an improvement over their position 10 years ago.</p>
<p><img src="http://www.datacornerstone.com/blog/wp-content/uploads/2014/04/Inline2-3.png" alt="Inline2-3" width="179" height="112" class="alignleft size-full wp-image-232" />Is this a bad thing? It is and it isn’t depending on where you’re sitting. It’s bad if you’re sitting at an A/E/C firm and you’re trying to compete at the top of the market. Higher revenues and more competition means higher risk. It’s also tough for companies sitting near the edge of this top-tier because it’s hard to overcome the momentum of those giants.</p>
<p>The flip side of this coin is the revenue stability in the smaller segments. I refer to it as being “stable” because we don’t see any major expansions or contractions between $25MM and $500MM. This suggests a fairly dependable revenue stream for a certain segment of the market. If this were not the case we might see the lower revenue segments shrinking as they got “crowded out” by the larger firms. According to this data, the market has actually grown to accommodate the new giants and left the other players relatively unaffected (of course, this excludes firms outside the ENR 500).</p>
<p>You may be thinking about this dataset and wondering if we can get a look at what happened with each individual company. We certainly have the data for it. When we tried to graph the individual companies we got a warning in Excel that “you can only graph 255 entries”. Even after pulling out 623 &#8220;non-architectural&#8221; and data limited companies (firms that had less than 7 years of data) we knew it would still be painful on the eyes. Instead we opted for the interactive visualization below. The graph shows the annual revenue for 200 firms practicing architecture that also participated in the ENR 500 for 7 years or more). We included some regional filters. It&#8217;s interesting to get a rough sense of how income is distributed regionally. It may be of interest to note that even though our dataset is limited to 500 companies annually, over a 10 year span we have actually captured data for 845 unique companies (after adjusting for mergers and name changes)</p>
<p>Lastly please note that this is plotted on a log scale to minimize the differences between market segments.<br />
<iframe src="http://www.datacornerstone.com/blog/wp-content/uploads/2014/04/all_firms.html" width="550" height="538" class="alignright" scrolling="no" frameborder="0"></iframe></p>
]]></content:encoded>
			<wfw:commentRss>http://www.datacornerstone.com/blog/?feed=rss2&#038;p=174</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
	</channel>
</rss>
