Description
Living in spreadsheet hell? Tired of going to IT to get your data structured for basic (or advanced) tasks? Our Data Process Automation (DPA) course takes you on a journey to data independence and efficiency. Leveraging open source tools, our students learn how to move away from the limitations of traditional office tools, to automated toolkits.
COURSE OUTLINE
- Data access – Reading and Writing Data
- Combining data from multiple sources
- Data Cleaning and Formatting – Preparing data for analysis
- Mathematical Operations – Adding incremental value to raw data
- Data Transformation – Converting data to summary information
- Data Aggregation – consolidating results
- Working with date and time data
- Working with databases
WHAT YOU’LL WALK AWAY WITH
- Best practices on how to approach a data process automation project
- Core concepts of transitioning from Excel to an automated tool
- Sample workflows and reports which can be reused at your convenience
- Office hours coaching to help you tackle your chosen assignment
- Continuing Professional Development credits, where applicable
