Data Usability - designing data for consumption

About this course

Basic data design choices can make the difference between simple analysis and hours of frustration. This classroom based workshop will go over how to make certain dataset design decisions that will make your reporting life much easier, hopefully reducing repetitive asks for data and interpretation. This is a methods course that will primarily use tools and formulas in Excel to help you test your data for analysis readiness.

This class assumes you are comfortable navigating in an Excel worksheet. You should have access to Excel 2010 or 2013 at your workstation.

What you’ll learn

  • How to use functions in Excel to clean and prepare data for analysis
    • Use Paste-Transpose and SEARCH and FIND functions to create categorical variables
    • Create fiscal years from dates
    • Prepare addresses using CONCATENATE
    • Create flexible lookups using INDEX and MATCH
  • New mindsets for approaching data preparation and cleaning