Charles Yi is a Data Consultant at The Information Lab (TIL). Charles graduated from the United States Air Force Academy in Colorado Springs, Colorado, with a B.S. in Political Science and commissioned as an Air Force Intelligence Officer in 2014. After working on a big data project as an intelligence analyst for the Defense Threat Reduction Agency (DTRA), Charles took a data bootcamp, sparking his passion for data and eventually leading him into a career in data analytics. Now at TIL's New York City location, Charles is looking use his skills and prior experience to inform, educate, and inspire organizations, causes, and people seeking to do more with their data.
Charles' most extensive project involved automating various accounting processes for a Forbes 500 client using Alteryx. Throughout his year with the client, Charles was able to develop over a dozen workflows that streamlined, standardized, and accelerated key tasks. For example, he built a workflow to calculate commissions and overrides for over 200 contracts and more than a thousand partner agencies. This process had previously taken around 90 days with 5-6 accountants working around the clock to complete. Now with a push of a few buttons in Alteryx, the same task can be done by one accountant in 20 minutes. Charles is also a passionate about sharing his knowledge. He dedicated over 100 hours to train and upskill approximately a dozen client employees, ensuring long-term success for their team.
Despite his most impactful project involving Alteryx, Charles is also passionate about and experienced in Tableau, SQL, and Python and is always eager to stay on top of the fast-moving world of data and technology.
In his free time, Charles enjoys working out, playing soccer, and reading.