Charles Yi

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.

Certifications

Blog Posts

Avatar
Fri 01 Dec 2023 | Charles Yi
Dashboard Week Day 4: Try Again!
Final day of dashboard week and the final day of training! We were tasked to create our initial interview dashboard: https://public.tableau.com/app/profile/charles
Avatar
Tue 28 Nov 2023 | Charles Yi
Dashboard Week Day 3: Coldplay Lyrics
Dashboard week day 3 consisted of using lyrics to make a dashboard. Originally, the task was to use the Genius API to pull our own data on our favorite artists. However, we ran into some technical issues so we pivoted to a kaggle dataset: https://www.kaggle
Avatar
Mon 27 Nov 2023 | Charles Yi
Dashboard Week Day 2: Cheese, Cheese, Cheese!
The second day of dashboard required us to web-scrape data from cheese.com and to build a dashboard with the data. Step 1. Web-Scraping I used Alteryx to web-scrape. At first, I attempted to web-scrape all the cheese in the website, but quickly realized that this would take too long
Avatar
Wed 27 Sep 2023 | Charles Yi
Regex in Alteryx
Regex, short for regular expressions, is a sequence of characters that specifies a match pattern in a string. In Alteryx, Regex can be used to replace, split, parse, and match text using two tools: the Formula tool and the Regex tool
Avatar
Thu 21 Sep 2023 | Charles Yi
Starter Guide to Tableau Containers
Tableau containers are objects that let you group related dashboard items together so you can quickly position them.  Containers can be extremely helpful in dashboard design and layout if used properly. In this post, I'll walk through the basics of containers and share some tips (don't use tiles!)
Avatar
Sun 10 Sep 2023 | Charles Yi
Basics of Parameter
After covering a few things in Alteryx, we are back to Tableau! This post will be all about parameters
Avatar
Tue 29 Aug 2023 | Charles Yi
Ranking in Alteryx Using Multi-Row Formula
Last week, we looked at how to rank in Alteryx using the Record ID and Join tools. This week, I'll be demonstrating how to rank using the Multi-Row Formula tool. I'll be using the dataset from Alteryx's Weekly Challenge #9 to showcase the tool
Avatar
Tue 22 Aug 2023 | Charles Yi
Ranking in Alteryx Using Record ID
Although there is no rank calculation or tool in Alteryx, you can still rank values using workarounds. In this post, I'll show you how to do so using the Record ID and Join tools. The example I'll be using to demonstrate Record ID and Join is based on Alteryx's Weekly Challenge #9
Avatar
Wed 16 Aug 2023 | Charles Yi
Filtering Basics: Dimensions vs Measures
Filtering is a powerful tool in Tableau and most users will have probably used it to slice and dice their data
Avatar
Tue 15 Aug 2023 | Charles Yi
What's the Difference Between Measures and Dimensions?
Tableau categorizes fields by whether they are measures or dimensions OR discrete or continuous. Understanding the difference between these categories can help you build more effectively in Tableau. Take a look at a snip of the data pane below from the Sample - Superstore dataset
Avatar
Mon 14 Aug 2023 | Charles Yi
Scaffolding in Tableau
Scaffolding is a technique used to artificially create a data structure to aid in analysis and visualization. Depending on one’s needs, this could mean inserting rows into an existing dataset or creating an entirely new dataset to be joined with the original dataset
Avatar
Mon 14 Aug 2023 | Charles Yi
Transitioning from the Military to Corporate Data Analytics (Why I Chose the Data School)
Are you a current or former military member looking to transition into data analytics? Be sure to consider the Data School to jumpstart your career! I served in the Air Force for six years and then worked as a contractor for various companies and federal agencies in northern Virginia
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2025 The Information Lab