A one-day class to develop the necessary skills to clean, join, process, and visualize NYC Parks data with Microsoft Excel
Conceptualizing: Supported scoping of analytics problem and process
Skill Development: Advanced analytics operations, including formulas and functions to clean, process, and join NYC Parks data
Integrating: Investigate context using provided resources
Communicating: Project pitch with content critique in order to foster an entrepreneurial mindset with respect to developing and communicating analytical work
Language Objective: Develop greater fluency in basic data skills to conceptualize a problem with data, integrate context, and communicate a true and compelling data story to others
- Welcome and Introductions
- Excel I Recap
- Plan the Work
- Data Conversation (identifying assumptions/validation)
- Documenting work (process mapping redux)
- Importing Data (SQL, CSV)
- Break
- Work the Plan
- Data Types
- Formulas/Order of Operations
- Nesting functions
- Aggregating (SUMIF, COUNTIF)
- Stacking Fields in PivotTables
- Joining by Attributes (Unique Key VLOOKUP)
- Lunch
- Refine the Work
- Data Visualization Redux
- Communicate the Work
- Presentations
- Wrap-Up