AWS Builder Center

How Students Can Build Their First Data Project on AWS

You don't need a huge project to start learning Cloud and Data Analytics. As a student, one of the best ways to learn AWS is to build something small, practical, and easy to understand. Here's a simple project idea that combines Amazon S3, SQL, Amazon Athena, Python, and data visualization.

Analista de BI

How Students Can Build Their First Data Project on AWS

You don't need a huge project to start learning Cloud and Data Analytics.
As a student, one of the best ways to learn AWS is to build something small, practical, and easy to understand.
Here's a simple project idea that combines Amazon S3, SQL, Amazon Athena, Python, and data visualization.

The Project

Imagine you have a CSV file containing sales data.
Your goal is to upload the dataset to AWS, analyze it using SQL, and turn the results into useful insights.
A simple architecture could look like this:
CSV → Amazon S3 → Amazon Athena → SQL → Visualization
Let's break it down.

Step 1: Prepare Your Dataset

Start with a simple CSV file.
For example:
  • Date
  • Product
  • Category
  • Region
  • Quantity
  • Revenue
You can use a public dataset or create your own.
The important thing is to understand the data before uploading it.

Step 2: Store the Data in Amazon S3

Create an S3 bucket and upload your dataset.
S3 becomes the storage layer for your project.
This is an important concept because many cloud data workflows start with data being stored in object storage.

Step 3: Query the Data with Amazon Athena

Now comes the interesting part.
Instead of downloading the data and analyzing everything locally, you can use Amazon Athena to query data stored in S3 with SQL.
For example, you could calculate total revenue by category:
SELECT
category,
SUM(revenue) AS total_revenue
FROM sales
GROUP BY category
ORDER BY total_revenue DESC;
You are now combining two important skills:
SQL + Cloud

Step 4: Analyze the Results

Once you have your query results, you can start looking for patterns.
Questions could include:
  • Which product category generates the most revenue?
  • Which region has the highest sales?
  • How do sales change over time?
  • Which products have the lowest performance?
This is where Data Analytics becomes more than just writing queries.

Step 5: Create a Visualization

Finally, turn your results into something people can understand.
You could use Python, Power BI, Tableau, or another visualization tool.
For example:
S3 → Athena → SQL → Power BI
Now you have a small but complete cloud analytics project.

What You Learn

Even a simple project like this teaches several important concepts:
  • Cloud storage
  • SQL analytics
  • Data organization
  • Cloud-based querying
  • Data visualization
  • Basic cloud architecture
And most importantly, you have something you can add to your portfolio.

Start Small, Then Improve

Once the basic project works, you can make it more advanced.
You could add:
  • Python automation
  • More datasets
  • Data cleaning
  • Scheduled processing
  • Machine learning
  • A dashboard
  • A serverless architecture
You don't need to build a massive project on day one.
Build something small. Understand it. Then improve it.
That's one of the approaches I'm using while combining my Data Science studies with my experience in BI and my AWS learning journey.
What would you build with this architecture?
Any opinions in this article are those of the individual author and may not reflect the opinions of AWS.
Enjoyed reading this content? Let the author know!

Your likes, comments, shares, and saves help creators reach more builders.

Loading recommendations

Loading article