<?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; Data Analysis</title>
	<atom:link href="http://www.datacornerstone.com/blog/?cat=9&#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>Is There Any Data Out There? (Part II)</title>
		<link>http://www.datacornerstone.com/blog/?p=287</link>
		<comments>http://www.datacornerstone.com/blog/?p=287#comments</comments>
		<pubDate>Wed, 16 Apr 2014 22:38:26 +0000</pubDate>
		<dc:creator><![CDATA[Doug Santo]]></dc:creator>
				<category><![CDATA[Data Analysis]]></category>
		<category><![CDATA[Prediction/Forecasting]]></category>

		<guid isPermaLink="false">http://www.datacornerstone.com/blog/?p=287</guid>
		<description><![CDATA[In this follow-up we’ll give some background on our “Data Practicality Framework”. We'll show how it can be used by applying it to the American Institute of Architects’ Architectural Billing Index.]]></description>
				<content:encoded><![CDATA[<p><img src="http://www.datacornerstone.com/blog/wp-content/uploads/2014/04/Featured-Image-1024x537.png" alt="Is There Any Data Out There?" width="545" height="285" class="aligncenter size-large wp-image-276" /><br />
In <a href="http://www.datacornerstone.com/blog/?p=248" title="Is There Any Data Out There? (Part I)" target="_blank">Part I</a> of this post we went over the (limited) options that engineering and consulting firms have at their disposal for gathering market data.</p>
<p>In this follow-up we’ll give some background on our “Data Practicality Framework”. We&#8217;ll show how it can be used by applying it to the American Institute of Architects’ Architectural Billing Index.<span id="more-287"></span></p>
<h2>#1: Where does it come from?</h2>
<p><img src="http://www.datacornerstone.com/blog/wp-content/uploads/2014/04/Inline11.png" alt="Inline1" width="196" height="96" class="alignright size-full wp-image-299" />This is another way of saying “consider the source”. If someone has a stake in the information they&#8217;re presenting there is a good chance that they are putting a particular spin on it. We can’t even blame anyone for this. It’s a result of the human factor. Information that is entirely free of bias is not only difficult to present, it&#8217;s boring. Human beings end up unconsciously promoting things they want to be true and hiding things they don&#8217;t want to admit. The numbers don&#8217;t lie but the people presenting them might.</p>
<h2>#2: How is it measured?</h2>
<p>Answering this question can help us figure out if we&#8217;re looking at a parameter or a statistic. A parameter is the most pure form of data because it represents an entire population. We are not very likely to see true parameters in our everyday experience. A statistic <strong>attempts</strong> to represent a much larger data set by taking a random sample and assuming it has the same characteristics as the total population. Generally speaking bigger samples are better. Bigger samples are harder to get which is part of where big data comes in. Sometimes practicality gets in the way of collecting big samples. We wouldn&#8217;t be talking about big data if it wasn&#8217;t getting easier but some metrics will always be estimates.</p>
<h2>#3: Who is it meant for?</h2>
<p><img src="http://www.datacornerstone.com/blog/wp-content/uploads/2014/04/Inline21.png" alt="Inline2" width="222" height="117" class="alignleft size-full wp-image-300" />We&#8217;re assuming that you aren&#8217;t using the price of corn futures to project how your AEC business is going to do next month. If you are then maybe you should answer this first. Either way, we suggest that you ask this question at some point because the data might not be as relevant as you think. We aren&#8217;t completely discounting indirect data sources but given the lack of engineer and consultant specific data it bears consideration. If your firm specializes in lighting design for greenhouses you very well might benefit from agricultural data. But if you do use indirect data it&#8217;s important to understand what makes it indirect. Will your business lag the data by a few months? Maybe you are operating in a subset of the overall market? Considering these differences will help to understand what&#8217;s really impacting your business.</p>
<h2>#4: How can I use it?</h2>
<p>This is where we can start to leverage the whole process. The answer to this question depends on the type of data you have and what you&#8217;ve gotten out of it. Putting some serious thought into what you can do with the data could mean the difference between having it positively affect your business or not. It&#8217;s tempting to ask this question first but saving it for last prevents us from using biased, poorly measured, unrelated data for something we shouldn&#8217;t. Let your mind wander with this one but make sure you come out of it with some concrete action items. Maybe pick a time on the calendar when you can look back and see if the suggested outcome actually happened?</p>
<p>Now it&#8217;s time to apply this to the ABI and see what it is/isn&#8217;t good for.</p>
<h2>Data Practicality Framework And The ABI</h2>
<h2>#1: Where does it come from?</h2>
<p>The ABI is generated by the AIA Economics and Market Research group. This group is part of a professional organization that is polling Architect’s on a monthly basis to see what is happening with their business. In this context there&#8217;s really nothing objectionable about it. The ABI is probably as free of bias as any research can be. This is still a good <img src="http://www.datacornerstone.com/blog/wp-content/uploads/2014/04/Inline31.png" alt="Inline3" width="202" height="75" class="alignright size-full wp-image-301" />question to ask because a &#8220;for profit&#8221; organization might be motivated to paint a more promising picture of the economy. We could go into scores of examples where editorial commentary has downright abused the use of statistics and data so the point is, always proceed with caution.</p>
<h2>#2: How is it measured?</h2>
<p>The ABI is a statistic and not a parameter. We know this because the AIA tells us there are approximately 700 architecture firms surveyed for this study. Earlier studies included nearly 300 respondents. So not only are we looking at a sample but we&#8217;re looking at one that has changed over time. If we compare this to the AIA estimate that 17,500 firms are owned by AIA members we see that the ABI is sampling at most, 4% of the industry (there are probably more than 17,500 firms). Statistically 700 is a great number. If the firms are randomly chosen there&#8217;s a strong chance that it actually is indicative of architect&#8217;s as a whole. But there&#8217;s one characteristic of the ABI that we know makes it non-random. The survey is only a product of those firms who respond. <img src="http://www.datacornerstone.com/blog/wp-content/uploads/2014/04/Inline41.png" alt="Inline4" width="215" height="118" class="alignleft size-full wp-image-302" />Is there some other characteristic of these responding firms that biases the data? Maybe smaller firms don&#8217;t contribute suggesting that this is more applicable to larger firms?</p>
<p>Another aspect of the ABI is unfortunately more disappointing. The Economics and Market Research Group isn&#8217;t secretive about this. They come out and say it right on their website. However, most people may not consider the result of this survey method. The ABI is a &#8220;diffusion index&#8221;. Survey respondents are given three questions: have billings grown more than 5%, have billings remained the same, have billings declined more than 5%. If 50% say growth and 50% say decline the score will be a 50. If 100% say stable the score will also be a 50. If 100% say growth the score will be 100. The problem we have is that the score can say 100 but the market will not have grown 100%. It has the effect of making the numbers look like a stock market index for architects, which it&#8217;s not. This is why we think it&#8217;s misleading. It&#8217;s not worth feeling cheated over because it&#8217;s not intentional but if you don&#8217;t know about it you might draw some erroneous conclusions.</p>
<h2>#3: Who is it meant for?</h2>
<p>This should be obvious. The ABI is meant for architects. It&#8217;s not meant for engineers or consultants. The ABI has been featured in a study published by <a href="http://www.aia.org/aiaucmp/groups/aia/documents/pdf/aias076074.pdf" title="white paper" target="_blank">Business Economics</a> showing it&#8217;s relevance to construction cycles which is encouraging. It is also probably a leading indicator because architect&#8217;s have to get paid before Es and Cs do. But how much does it actually lead your business? Hard to say.</p>
<h2>#4: How can I use it?</h2>
<p><img src="http://www.datacornerstone.com/blog/wp-content/uploads/2014/04/Inline4-5.png" alt="Inline4-5" width="189" height="117" class="alignright size-full wp-image-317" />This is a tough one. Based on everything we&#8217;ve covered, Engineers and Consultants should see the ABI as a pulse on the status of architects and nothing more. Some businesses may not see their billings change at all in relation to the ABI. Others may see a direct correlation. What we can say with certainty is that it won&#8217;t have the same significance for everyone.</p>
<p>Hopefully you feel a bit more comfortable looking at new sources of data by using this framework.</p>
]]></content:encoded>
			<wfw:commentRss>http://www.datacornerstone.com/blog/?feed=rss2&#038;p=287</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Is There Any Data Out There? (Part I)</title>
		<link>http://www.datacornerstone.com/blog/?p=248</link>
		<comments>http://www.datacornerstone.com/blog/?p=248#comments</comments>
		<pubDate>Wed, 16 Apr 2014 19:42:16 +0000</pubDate>
		<dc:creator><![CDATA[Doug Santo]]></dc:creator>
				<category><![CDATA[Data Analysis]]></category>
		<category><![CDATA[Prediction/Forecasting]]></category>

		<guid isPermaLink="false">http://www.datacornerstone.com/blog/?p=248</guid>
		<description><![CDATA[<p><img src="http://www.datacornerstone.com/blog/wp-content/uploads/2014/04/Featured-Image-1024x537.png" alt="Is There Any Data Out There?" width="545" height="285" class="aligncenter size-large wp-image-276" /><br />
This week we’re taking a look at some of the data options we’ve come across in our experience.&#8230;</p>]]></description>
				<content:encoded><![CDATA[<p><img src="http://www.datacornerstone.com/blog/wp-content/uploads/2014/04/Featured-Image-1024x537.png" alt="Is There Any Data Out There?" width="545" height="285" class="aligncenter size-large wp-image-276" /><br />
This week we’re taking a look at some of the data options we’ve come across in our experience. We’ll review how they can or can’t be used for the benefit of Engineers and Consultants (“Es and Cs”). The current data situation is pretty bleak but with your help there may be hope.<span id="more-248"></span></p>
<p><img src="http://www.datacornerstone.com/blog/wp-content/uploads/2014/04/Inline1.png" alt="Inline1" width="248" height="94" class="alignleft size-full wp-image-257" />Whether you’re digging it out of your own marketing database, reading it in a magazine, paying a hefty fee, or paying even more for a custom study, getting data is never simple. Perhaps one of the most frustrating parts of being a manager at an Engineering or Consulting firm right now is that everyone in the business world is talking about “Big Data” and it doesn’t seem like it relates to you. What is a manager to do? Here are some ideas.</p>
<p><strong><br />
<h2>Internal Data</h2>
<p></strong></p>
<p>The best way to start is by looking in the mirror. What do you want to know about your own company? Most mid to large size companies have databases for marketing or accounting. Just because you’re a one man shop doesn’t mean you can’t do this too. Everyone should be tracking their own data no matter how big or how small. If you aren’t doing it now we can’t recommend enough that you start. Excel and Quickbooks are perfectly fine places to begin. Throughout our experience we’ve identified over 25 different fields that anyone handling proposals can track. Here’s a handful to get you started:</p>
<p><img src="http://www.datacornerstone.com/blog/wp-content/uploads/2014/04/Sample-Table.png" alt="Sample Table" width="425" height="121" class="aligncenter size-full wp-image-268" /></p>
<p>Once you have these fields you can start asking questions like “How much of our business is done directly with Owners, Architects, or Developers?” You might have an intuition for that but it’s always better to use hard numbers. Particularly because you can see how they change over time.</p>
<p><img src="http://www.datacornerstone.com/blog/wp-content/uploads/2014/04/Inline2.png" alt="Inline2" width="227" height="96" class="alignright size-full wp-image-258" />You don’t have to rack your brain coming up with as many “fields” as you can think of either. Different organizations will have different data needs but it’s important to be practical about it. It’s also important to start somewhere. The benefits of tracking data can’t be overstated enough and the sooner you start the better. Knowing that you landed 5 projects last month will push you to go for 6 this month and 7 the month after that.</p>
<p>Lastly, if you have the feeling that you need to start with all the right fields you should ignore it. When you find out two years later that you wanted to track different market sectors it won’t mean the old data is useless. You can even go back and update the old data to get what you want from it. This is a great way to give old data new life and get more from it. Sure, it’s a pain. But it’s better to have data you can work with then nothing.</p>
<p><strong><br />
<h2>External Data</h2>
<p></strong></p>
<p><img src="http://www.datacornerstone.com/blog/wp-content/uploads/2014/04/Inline3.png" alt="Inline3" width="189" height="97" class="alignleft size-full wp-image-259" />If you already track loads of data internally this part is for you. It’s where things are getting interesting. Internal data is great but it only allows us to analyze things we think we already know. Data from the outside world puts that internal data into perspective.</p>
<p>Even small bits of external data can be useful. For example, if we look at the AIA website we see that there are 17,500 architecture firms owned by AIA members. For the larger firms out there; do you know the number of different clients that you have worked for? What percentage of this 17,500 have you had access to? How has your number of clients changed? Okay, “Small Data” isn’t what anyone is talking about these days so what are some more sizeable options?</p>
<p><strong><a href="http://enr.construction.com/toplists/Top-Design-Firms/001-100.asp" title="The ENR Top 500" target="_blank">The ENR Top 500</a></strong></p>
<p>We have <a href="http://www.datacornerstone.com/blog/?p=19" title="blogged" target="_blank">blogged</a> this one to <a href="http://www.datacornerstone.com/blog/?p=174" title="death" target="_blank">death</a> already but it bears repeating. The ENR 500 is the easiest “go-to” list of the biggest firms in the industry. For some companies this won’t be enough. For other companies it will seem outside of your reach. It’s not. This list is useful to anyone. Even if you’re a small firm, establishing a solid relationship with even one of these firms could mean the difference between celebrating at the end of the year and shutting your doors. Read the list, find the companies you know and work for, then cross them out and learn about the others.</p>
<p><strong><a href="http://www.aia.org/practicing/economics/AIAS076265" title="The AIA ABI" target="_blank">The AIA ABI</a></strong></p>
<p>The American Institute of Architects’ Architectural Billing Index (“ABI”) is one of the first data metrics we found when we began looking back in our early years. It’s no small wonder. The ABI has been around in one form or another since 1995 and offers what some would consider a “stock market like index” of the entire US architecture industry on a monthly basis. We will go into the ABI in more detail in Part II. Rest assured that whatever qualms we may have, the ABI is a metric you should follow and be aware of.</p>
<p><strong>“Independent” Options</strong></p>
<p>This is an area where it should come as no surprise that we are a little biased. There are currently a handful of different firms that cobble together studies at various times with a specific purpose in mind. We’re not going to pick on any in particular which is why we developed a list of questions. These questions form a framework that you can use to analyze any potential data source to see how it relates to your own business practice.</p>
<p><strong>Data Practicality Framework</strong><img src="http://www.datacornerstone.com/blog/wp-content/uploads/2014/04/Inline4.png" alt="Inline4" width="196" height="121" class="alignright size-full wp-image-260" /></p>
<ol>
<li>Where does it come from?</li>
<li>How is it measured?</li>
<li>Who is it meant for?</li>
<li>How can I use it?</li>
</ol>
<p>Most of the independent data sources are collecting information from big companies and presenting it back to them. In that context these studies have a purpose. Smaller unrelated firms will probably find it hard to justify the cost of these reports when the titles alone are meant for someone else. Still other providers are combining so many different types of companies you have no idea if it&#8217;s actually useful.</p>
<p>This is where Data Cornerstone comes in. We&#8217;re able to combine data from various specialty firms and give you a metric like the ABI for your specialty discipline. Not only will we tell you what has happened, we&#8217;ll tell you where it&#8217;s going. The Data Cornerstone model relies on the knowledge that small firms make up a significant percentage of any professional services market which is exactly what these reports typically leave out. Even among architects the AIA estimates that firms with less than 9 staff make up 81% of architecture firms and 21% of architect&#8217;s billings.</p>
<p>Next time we’ll go into more detail by applying our “Data Practicality Framework” to the ABI. In the meantime, leave us feedback in the comments. Are there other sources of data we forgot? Maybe we can help you develop your own sources of internal data.</p>
]]></content:encoded>
			<wfw:commentRss>http://www.datacornerstone.com/blog/?feed=rss2&#038;p=248</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
	</channel>
</rss>
