As a newly hired data engineer at a fictional company, my first task was to research employees that worked with the company in the 80s and 90s. All that remained of the employee database from that time period was six CSV files.
I designed tables to hold the data from the CSV files (data modeling), imported the CSV files into a SQL database (data engineering), and then answered questions about the data (data analysis).
This project was completed as a part of the UTSA Data Analytics and Visualization Certification program.