Choose Language Hide Translation Bar
gail_massari
Community Manager Community Manager

Preparing Your Data for Analysis

 

See how to:

  • Understand how thinking about the questions you want to answer helps determine how to shape your data to prepare it for analysis
    • Example 1 aims to understand, for an event held multiple years, if/how attendance varies by day
    • Example 2 compares profits from different countries
    • Example 3 tries to understand the relationship between the amount of time customers wait at different stores that have different numbers of check-out lines
    • Use stack, split and multiple series stack to help prepare data

 

See how to:

  • Merge and update data
    • 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
    • Replace data in cells using Update

 

See how to:

  • Summarize and subset
    • Grab summary statistics from reports and then make them into a data table
    • Make a combined data table for reported statistics of like types
    • Summarize by a selected variable at the onset of analysis before any reports are run
    • Use Tabulate to make a chart that can be exported using copy and paste or saved to a third-part format such as PowerPoint.
    • Create subsets that are unlinked or linked to the original data table
    • Save subsets to the data table or to a new table