What is data presentation and analysis?
Data presentation and analysis forms an important part of all academic studies, commercial, industrial and marketing activities as well as professional practices. It is necessary to make use of collected data which is considered to be raw data which must be processed to put for any use. Data analysis helps in interpretation of data and take a decision or answer the research question. Data analysis starts with the collection of data followed by sorting and processing it. Processed data helps in obtaining information from it as the raw data is non comprehensive in nature. Presenting the data includes the pictorial representation of the data by using graphs, charts. maps and other methods. These methods help in adding visual aspect to data which makes it much easier and quick to understand.
Significance of data presentation and analysis
Data presentation and analysis plays an important role in every field. A great presentation can be a deal maker or deal breaker. Some people make extremely effective presentation with the same set of facts and figures which are available with others. At times people who did all the hard work but failed to present it present it properly have lost important contracts, the work which they did is unable to impress the decision makers. So in order to get the work done especially while dealing with clients or higher authorities presentation matters! No one is willing to spend hours in understanding what you have to show and this is exactly why presentation matters!
Related: Data Management Best Practices, Data Visualization
Data analysis helps people in understanding the results of surveys conducted, makes use of already existing studies to obtain new results. Helps in validating the existing study or to add/expand existing study.
Data presentation and analysis or data analysis and presentation?
These two go hand in hand and it will be difficult to provide a complete differentiation between the two. Adding visual aspect to data or sorting it by means of grouping and presenting it in form of table is a part of presentation which further helps in analyzing data. During a study with an aim and multiple objectives, data analysis will be required to complete the required objectives and compiling or presenting the analysed data will help in overall analysis and concluding the study.
You can have variety of data which can be used in presentations. Some of these type include :
- Time Series Data
- Bar Charts
- Combo Charts
- Pie Charts
- Geo Map
- Scatter Charts
- Bullet Charts
- Area Chart
- Text & Images
Some of these have been described in brief with example in the end of this article.
Steps for presenting and analysis data:
- Frame the objectives of the study and make a list of data to be collected and its format.
- Collect/obtain data from primary or secondary sources.
- Change the format of data i.e. table, maps, graphs etc in desired format
- Sort data by means of grouping, discarding the extra data and deciding the required format to make data comprehensible
- Make charts and graphs to help adding visual part and analyse trends.
- Analyse trends and relate the information to fulfill the objectives.
Presenting the result:
- Presentation should have a predefined sequence of arguments being made to support the study. Start with stating the Aim of study and the objectives required to reach the aim.
- Break the objectives in multiple parts and make a list of data to be collected, the sources of data. form in which data exist and needs to be obtained, conducting primary survey for information which does not exist.
- Form and explain the methodology adapted to carry out study.
- Data collection by means of primary survey need to have well thought of sampling methods. This will help in reducing the efforts and increasing efficiency.
- Present only the required information and skip the background research to make your point more clear.
- Do not forget to give credits and references in the end and where ever required.
The presentation can be done by means of softwares such as Microsoft Powerpoint, Prezi, Google Analytics and other analytic softwares. It can also be done by making models, presenting on paper or sheets, on maps or by use of boards. The methods selected depends on the requirement and the resources available.
Related: Data Mining, Data Mapping
How to present different type of data
Secondary surveys forms major part of data research and primary means of data collection by conducting various surveys and making use of existing data from various sources. The data thus obtained from various sources like Census department, Economics and Statistics department, Election Commission, Water Board, Municipal Bodies, Economic surveys, Website feedbacks, scientific research etc. is compiled and analyzed. Data is also required to forecast and estimate the change in requirement of various resources and thus provide them accordingly. Phasing and prioritization forms another important part for effective implementation of the proposals.
Different types of charts which can be used for data presentation and analysis.
Bar Charts/Bar Graphs: These are one of the most widely used charts for showing the grown of a companies over a period of time. There are multiple options available like stacked bar graphs and option of showing change in multiple entities. These look as shown in image below:
Related: Methods of data collection, Data Processing
Line Chart: These are best for showing the change in population i.e for showing the trends. These also work well for showing the growth of multiple areas at the same time.
Pie Charts: These work best for representing the share of different components from a total 100%. For eg. contribution of different sectors to GDP, population of different states in a country etc.
Combo Chart: As the name suggest it is a combination of more than one chart type. The one shown in the figure below is a combination of line and bar graph. These saves space and are at times more effective then using 2 different charts. There can even be 3 or more charts depending on the requirement.
Related: Data Mining, Information Processing Cycle
Data analysis and presentation
Scope and purpose
Scope and purpose
Data analysis is the process of developing answers to questions through the examination and interpretation of data. The basic steps in the analytic process consist of identifying issues, determining the availability of suitable data, deciding on which methods are appropriate for answering the questions of interest, applying the methods and evaluating, summarizing and communicating the results.
Analytical results underscore the usefulness of data sources by shedding light on relevant issues. Some Statistics Canada programs depend on analytical output as a major data product because, for confidentiality reasons, it is not possible to release the microdata to the public. Data analysis also plays a key role in data quality assessment by pointing to data quality problems in a given survey. Analysis can thus influence future improvements to the survey process.
Data analysis is essential for understanding results from surveys, administrative sources and pilot studies; for providing information on data gaps; for designing and redesigning surveys; for planning new statistical activities; and for formulating quality objectives.
Results of data analysis are often published or summarized in official Statistics Canada releases.
A statistical agency is concerned with the relevance and usefulness to users of the information contained in its data. Analysis is the principal tool for obtaining information from the data.
Data from a survey can be used for descriptive or analytic studies. Descriptive studies are directed at the estimation of summary measures of a target population, for example, the average profits of owner-operated businesses in 2005 or the proportion of 2007 high school graduates who went on to higher education in the next twelve months. Analytical studies may be used to explain the behaviour of and relationships among characteristics; for example, a study of risk factors for obesity in children would be analytic.
To be effective, the analyst needs to understand the relevant issues both current and those likely to emerge in the future and how to present the results to the audience. The study of background information allows the analyst to choose suitable data sources and appropriate statistical methods. Any conclusions presented in an analysis, including those that can impact public policy, must be supported by the data being analyzed.
Prior to conducting an analytical study the following questions should be addressed:
Objectives. What are the objectives of this analysis? What issue am I addressing? What question(s) will I answer?
Justification. Why is this issue interesting? How will these answers contribute to existing knowledge? How is this study relevant?
Data. What data am I using? Why it is the best source for this analysis? Are there any limitations?
Analytical methods. What statistical techniques are appropriate? Will they satisfy the objectives?
Audience. Who is interested in this issue and why?
Ensure that the data are appropriate for the analysis to be carried out. This requires investigation of a wide range of details such as whether the target population of the data source is sufficiently related to the target population of the analysis, whether the source variables and their concepts and definitions are relevant to the study, whether the longitudinal or cross-sectional nature of the data source is appropriate for the analysis, whether the sample size in the study domain is sufficient to obtain meaningful results and whether the quality of the data, as outlined in the survey documentation or assessed through analysis is sufficient.
If more than one data source is being used for the analysis, investigate whether the sources are consistent and how they may be appropriately integrated into the analysis.
Appropriate methods and tools
Choose an analytical approach that is appropriate for the question being investigated and the data to be analyzed.
When analyzing data from a probability sample, analytical methods that ignore the survey design can be appropriate, provided that sufficient model conditions for analysis are met. (See Binder and Roberts, 2003.) However, methods that incorporate the sample design information will generally be effective even when some aspects of the model are incorrectly specified.
Assess whether the survey design information can be incorporated into the analysis and if so how this should be done such as using design-based methods. See Binder and Roberts (2009) and Thompson (1997) for discussion of approaches to inferences on data from a probability sample.
See Chambers and Skinner (2003), Korn and Graubard (1999), Lehtonen and Pahkinen (1995), Lohr (1999), and Skinner, Holt and Smith (1989) for a number of examples illustrating design-based analytical methods.
For a design-based analysis consult the survey documentation about the recommended approach for variance estimation for the survey. If the data from more than one survey are included in the same analysis, determine whether or not the different samples were independently selected and how this would impact the appropriate approach to variance estimation.
The data files for probability surveys frequently contain more than one weight variable, particularly if the survey is longitudinal or if it has both cross-sectional and longitudinal purposes. Consult the survey documentation and survey experts if it is not obvious as to which might be the best weight to be used in any particular design-based analysis.
When analyzing data from a probability survey, there may be insufficient design information available to carry out analyses using a full design-based approach. Assess the alternatives.
Consult with experts on the subject matter, on the data source and on the statistical methods if any of these is unfamiliar to you.
Having determined the appropriate analytical method for the data, investigate the software choices that are available to apply the method. If analyzing data from a probability sample by design-based methods, use software specifically for survey data since standard analytical software packages that can produce weighted point estimates do not correctly calculate variances for survey-weighted estimates.
It is advisable to use commercial software, if suitable, for implementing the chosen analyses, since these software packages have usually undergone more testing than non-commercial software.
Determine whether it is necessary to reformat your data in order to use the selected software.
Include a variety of diagnostics among your analytical methods if you are fitting any models to your data.
- Data sources vary widely with respect to missing data. At one extreme, there are data sources which seem complete - where any missing units have been accounted for through a weight variable with a nonresponse component and all missing items on responding units have been filled in by imputed values. At the other extreme, there are data sources where no processing has been done with respect to missing data. The work required by the analyst to handle missing data can thus vary widely. It should be noted that the handling of missing data in analysis is an ongoing topic of research.
Refer to the documentation about the data source to determine the degree and types of missing data and the processing of missing data that has been performed. This information will be a starting point for what further work may be required.
Consider how unit and/or item nonresponse could be handled in the analysis, taking into consideration the degree and types of missing data in the data sources being used.
Consider whether imputed values should be included in the analysis and if so, how they should be handled. If imputed values are not used, consideration must be given to what other methods may be used to properly account for the effect of nonresponse in the analysis.
If the analysis includes modelling, it could be appropriate to include some aspects of nonresponse in the analytical model.
Report any caveats about how the approaches used to handle missing data could have impact on results
Interpretation of results
Since most analyses are based on observational studies rather than on the results of a controlled experiment, avoid drawing conclusions concerning causality.
When studying changes over time, beware of focusing on short-term trends without inspecting them in light of medium-and long-term trends. Frequently, short-term trends are merely minor fluctuations around a more important medium- and/or long-term trend.
Where possible, avoid arbitrary time reference points. Instead, use meaningful points of reference, such as the last major turning point for economic data, generation-to-generation differences for demographic statistics, and legislative changes for social statistics.
Presentation of results
Focus the article on the important variables and topics. Trying to be too comprehensive will often interfere with a strong story line.
Arrange ideas in a logical order and in order of relevance or importance. Use headings, subheadings and sidebars to strengthen the organization of the article.
Keep the language as simple as the subject permits. Depending on the targeted audience for the article, some loss of precision may sometimes be an acceptable trade-off for more readable text.
Use graphs in addition to text and tables to communicate the message. Use headings that capture the meaning (e.g. "Women's earnings still trail men's") in preference to traditional chart titles (e.g."Income by age and sex"). Always help readers understand the information in the tables and charts by discussing it in the text.
When tables are used, take care that the overall format contributes to the clarity of the data in the tables and prevents misinterpretation. This includes spacing; the wording, placement and appearance of titles; row and column headings and other labeling.
Explain rounding practices or procedures. In the presentation of rounded data, do not use more significant digits than are consistent with the accuracy of the data.
Satisfy any confidentiality requirements (e.g. minimum cell sizes) imposed by the surveys or administrative sources whose data are being analysed.
Include information about the data sources used and any shortcomings in the data that may have affected the analysis. Either have a section in the paper about the data or a reference to where the reader can get the details.
Include information about the analytical methods and tools used. Either have a section on methods or a reference to where the reader can get the details.
Include information regarding the quality of the results. Standard errors, confidence intervals and/or coefficients of variation provide the reader important information about data quality. The choice of indicator may vary depending on where the article is published.
Ensure that all references are accurate, consistent and are referenced in the text.
Check for errors in the article. Check details such as the consistency of figures used in the text, tables and charts, the accuracy of external data, and simple arithmetic.
Ensure that the intentions stated in the introduction are fulfilled by the rest of the article. Make sure that the conclusions are consistent with the evidence.
Have the article reviewed by others for relevance, accuracy and comprehensibility, regardless of where it is to be disseminated. As a good practice, ask someone from the data providing division to review how the data were used. If the article is to be disseminated outside of Statistics Canada, it must undergo institutional and peer review as specified in the Policy on the Review of Information Products (Statistics Canada, 2003).
If the article is to be disseminated in a Statistics Canada publication make sure that it complies with the current Statistics Canada Publishing Standards. These standards affect graphs, tables and style, among other things.
As a good practice, consider presenting the results to peers prior to finalizing the text. This is another kind of peer review that can help improve the article. Always do a dry run of presentations involving external audiences.
Refer to available documents that could provide further guidance for improvement of your article, such as Guidelines on Writing Analytical Articles (Statistics Canada 2008 ) and the Style Guide (Statistics Canada 2004)
Main quality elements: relevance, interpretability, accuracy, accessibility
An analytical product is relevant if there is an audience who is (or will be) interested in the results of the study.
For the interpretability of an analytical article to be high, the style of writing must suit the intended audience. As well, sufficient details must be provided that another person, if allowed access to the data, could replicate the results.
For an analytical product to be accurate, appropriate methods and tools need to be used to produce the results.
For an analytical product to be accessible, it must be available to people for whom the research results would be useful.
Binder, D.A. and G.R. Roberts. 2003. "Design-based methods for estimating model parameters." In Analysis of Survey Data. R.L. Chambers and C.J. Skinner (eds.) Chichester. Wiley. p. 29-48.
Binder, D.A. and G. Roberts. 2009. "Design and Model Based Inference for Model Parameters." In Handbook of Statistics 29B: Sample Surveys: Inference and Analysis. Pfeffermann, D. and Rao, C.R. (eds.) Vol. 29B. Chapter 24. Amsterdam.Elsevier. 666 p.
Chambers, R.L. and C.J. Skinner (eds.) 2003. Analysis of Survey Data. Chichester. Wiley. 398 p.
Korn, E.L. and B.I. Graubard. 1999. Analysis of Health Surveys. New York. Wiley. 408 p.
Lehtonen, R. and E.J. Pahkinen. 2004. Practical Methods for Design and Analysis of Complex Surveys.Second edition. Chichester. Wiley.
Lohr, S.L. 1999. Sampling: Design and Analysis. Duxbury Press. 512 p.
Skinner, C.K., D.Holt and T.M.F. Smith. 1989. Analysis of Complex Surveys. Chichester. Wiley. 328 p.
Thompson, M.E. 1997. Theory of Sample Surveys. London. Chapman and Hall. 312 p.
Statistics Canada. 2003. "Policy on the Review of Information Products." Statistics Canada Policy Manual. Section 2.5. Last updated March 4, 2009.
Statistics Canada. 2004. Style Guide. Last updated October 6, 2004.
Statistics Canada. 2008. Guidelines on Writing Analytical Articles. Last updated September 16, 2008.