Data Engineering and Causal Inference
Scholars of International Relations (IR) can benefit enormously from learning the fundamentals of data engineering, including how to use cloud computing platforms. This guide offers a practical introduction to these tools, designed primarily for IR graduate students but accessible to anyone interested in expanding their methodological skills. It is intended as a quick-start guide, not a comprehensive course: the objective is to provide enough familiarity with the available tools to begin using them independently.
Some of the most compelling research in political science relies on novel datasets. Yet constructing these datasets is often considerably more labor-intensive than analyzing them. Researchers may spend months collecting information, reconciling inconsistent sources, cleaning observations, and maintaining databases before they can even begin testing their hypotheses. In practice, much of empirical social science involves data engineering, not merely data analysis. Despite this, methodological training overwhelmingly emphasizes the latter.
Data engineering can substantially reduce this burden. Rather than manually collecting, cleaning, and organizing information, researchers can build automated pipelines that perform these tasks repeatedly and reliably. Consider a project using social media data: a well-designed pipeline could make thousands of API requests, clean and standardize the resulting observations, store them in a database, and update the analysis as new information becomes available. What might otherwise require extensive manual work can instead operate as a reproducible, largely automated system.
Building such systems does not necessarily require expensive hardware or a dedicated technical team. Cloud computing providers, such as Amazon Web Services (AWS) and Google Cloud, offer access to computational resources, databases, storage, and automation tools on demand. Researchers can therefore use sophisticated infrastructure without purchasing or maintaining it themselves. Many applications can also be built with relatively modest computing resources and costs.
The principal obstacle is often knowing where to begin. Cloud platforms offer an enormous range of services, each with its own terminology, configuration requirements, and learning curve. For social scientists without a background in computer science, identifying which tools are useful—and which can safely be ignored—can be challenging.
This guide is designed to lower that barrier to entry. It provides a streamlined collection of introductory videos covering some of the foundational tools and concepts needed to get started with data engineering and cloud computing. It does not attempt to cover the subject comprehensively. Instead, it aims to equip IR scholars with sufficient practical knowledge to begin experimenting, building basic data pipelines, and exploring more advanced capabilities as their research demands.
The underlying argument is straightforward: social scientists should learn not only how to analyze data, but also how to engineer the systems that produce it. Doing so can make ambitious empirical projects more feasible, reduce repetitive research labor, and open up questions that would otherwise be difficult to investigate.
Step 1: Basics
First, watch these videos to get appraised on the topic.
1. Skim this from IBM. Link.
2. What does an actual, non-academic data engineer do? DITL from Seattle Data Guy on YouTube. Link.
3. Pipelines are what matter. Link.
4. Quick-ish overview from FreeCodeCamp.org. Link.
Second, diving into the basics.
1. Johnny Chivers on YouTube has an excellent starter video. Link.
2. (Optional) from FreeCodeCamp.org. This is more generally about the AWS ecosystem, not necessarily specific to data engineering. Link.
3. CodeAcademy has a user-friendly course on data engineering. Relatively lower on the cloud computing components. Link.
4. What is everything under the sun? AWS cheat sheet by ByteByteGo. Link.
5. ELK stacks in AWS. Link.
Third, your own capstone mini project. For better or for worse, this is the best way to learn — just to do it yourself. Again, just be mindful of costs.
1. Pick a topic you like. Maybe it’s related to something you picked up in the INT Hub.
2. First, get the data sorted into an S3 bucket. This is how an S3 bucket works: link.
3. Next, use AWS Glue to process the data. This is how Glue works: link.
4. (Optional, recommended) use a Lambda function to automatically process the data — including any new data added to the pipeline. This is how a lambda function works: link.
5. (Optional) Train a machine learning model using AWS SageMaker. Once your data is processed, you can take it a step further by using AWS SageMaker to build, train, and deploy machine learning models. Link.
Step 2: Advanced
Warning: everything below is only for advanced and specialized cases. It is only if you were curious as to how to increase and improve automation and efficiency in managing gargantuan datasets from different sources combined with your own specialized cloud tools to collect data. To put it more bluntly: it may not be cost-beneficial to proceed below unless you yourself are actively going to construct a sensing instrument, e.g., a device that collects raw, unprocessed data from the wild. Even then, the steps above might be sufficient anyway.
1. FreeCodeCamp.org again. Link.
2. TechWorld with Nana videos. Link and link.
3. Azure certificate on cybersecurity architecture; AWS and GCC will have their own as well. Link.