For most businesses and government agencies, lack of data isn’t a problem. The concern is that: there's often too much information available to make a clear decision. You need something more from your data. You need to know it is the data that informs your decision-making process, right data for answering your questions, whether it draws accurate conclusions or not.
In a nutshell you need better data analysis. With the right data analysis process and tools, information becomes a simple, clear decision point.
To upgrade your data analysis skills and untangle your decisions, execute these five steps in your process:
- Step 1: Define your Questions.
- Step 2: Set clear Measurement Priorities.
- Step 3: Collect Data.
- Step 4: Analyze Data.
- Step 5: Interpret Results.
Business data Analysis must begin with right questions. Questions should be Measurable, clear and concise. Design your Question to either qualify or disqualify potential solution for opportunities. For example, start with a clearly defined problem: A government contractor is experiencing rising costs and is no longer able to submit competitive contract proposals. One of many questions to solve this business problem might include: Can the company reduce its staff without compromising quality?
This step breaks down into two sub-steps:
- A) Decide what to measure
- B) Decide how to measure it.
A) Decide what to measure
Consider what kind of data you’d need to answer your key question. In this case, you’d need to know the number and cost of current staff and the percentage of time they spend on necessary business functions. In answering this question, you likely need to answer many sub-questions (e.g. Are staff currently under-utilized? If so, what process improvements would help?).
Finally, in your decision on what to measure, be sure to include any reasonable objections any stakeholders might have (e.g., If staff are reduced, how would the company respond to surges in demand?).
B) Decide how to measure it.
Key questions to ask for this step include:
What is your time frame?
(e.g., annual versus quarterly costs)
What is your unit of measure?
(e.g., USD versus Euro)
What factors should be included?
(e.g., just annual salary versus annual salary plus cost of staff benefits)
When your question clearly defined and your measurement priorities set, now it’s time to collect your data. As you collect and organize your data, remember to keep these important points in mind:
Before you collect new data, determine what information could be collected from existing databases or sources on hand. Collect this data first.
Determine a file storing and naming system ahead of time to help all tasked team members collaborate. This process saves time and prevents team members from collecting the same information twice. If you need to gather data via observation or interviews, then develop an interview template ahead of time to ensure consistency and save time.
Keep your collected data organized in a log with collection dates and add any source notes as you go (including any data normalization performed). This practice validates your conclusions down the road.
After you’ve collected the right data to answer your question from Step 1, it’s time for deeper data analysis. Begin by manipulating your data in a number of different ways, such as plotting it out and finding correlations or by creating a pivot table in Excel.
A pivot table lets you sort and filter data by different variables and lets you calculate the mean, maximum, minimum and standard deviation of your data – just be sure to avoid these five pitfalls of the statistical data analysis.
As you manipulate data, you may find you have the exact data you need, but more likely, you might need to revise your original question or collect more data. Either way, this initial analysis of trends, correlations, variations and outliers helps you focus your data analysis on better answering your question and any objections others might have.
During this step, data analysis tools and software are extremely helpful. Visio, Minitab and Stata are all good software packages for advanced statistical data analysis. However, in most cases, nothing quite compares to Microsoft Excel in terms of decision-making tools. If you need a review or a primer on all the functions Excel accomplishes for your data analysis, we recommend this Harvard Business Review class.
After analyzing your data and possibly conducting further research, it’s finally time to interpret your results. As you interpret your analysis, keep in mind that you cannot ever prove a hypothesis true: rather, you can only fail to reject the hypothesis. Meaning that no matter how much data you collect, chance could always interfere with your results.
As you interpret the results of your data, ask yourself these key questions:
- Does the data answer your original question? How?
- Does the data help you defend against any objections? How?
- Are there any limitation on your conclusions, any angles you haven’t considered?
By following these five steps in your data analysis process, you make better decisions for your business or government agency because your choices are backed by data that has been robustly collected and analyzed. With practice, your data analysis gets faster and more informed decisions to run your organization most effectively.
Want to draw the most accurate conclusions from your data? Click below to download a free guide from Big Sky Associates and discover how the right data analysis drives success for your organization.