Watch Now 17:33
Preparing Your Data for Analysis
Presenter: Olivia Lippincott
Reshaping Your Data to Answer Questions
The presenter uses three case studies to show how thinking about the questions you want to answer helps determine how to shape your data to prepare it for analysis. The first data study aims to understand, for an event held multiple years, if/how attendance varies by day. The second case compares profits from different countries. The third case tries to understand the relationship between the amount of time customers wait at different stores that have different numbers of check-out lines. The presenter uses stack, split and multiple series stack to help prepare data.
Merging and Updating Data
The presenter demonstrates how to add rows of data from one table to an existing table using Concatenate, add columns of data to a table based on common values in one column of cells using Tables Join, and replace data in cells using Update.
Summarizing and Subsetting
The presenter demonstrates different ways to summarize data, including by grabbing summary statistics from reports and then making them into a data table; making a combined data table for reported statistics of like types; summarizing by a selected variable at the onset of analysis before any reports are run; and using Tabulate to make a chart that can be exported using copy and paste or saved to a third-part format such as PowerPoint. She shows how to create subsets that are unlinked or linked to the original data table and several ways to save subsets to the data table or to a new table.