Try the work of a data analyst

Over the last few months we have been receiving more and more requests for internships and cooperation in web and data analytics. And very often we get the same question:

“What does a data analyst actually do? Can I try the job somehow? What exactly do you do for your clients?”

So we decided to prepare a small sample dataset and a case study for everyone interested, so you can see what an analyst’s work at Archetix really looks like.

What a data analyst does in practice

Our data analysts don’t just work with spreadsheets. They connect data, marketing and business. Our goal is not to collect data for the sake of data, but to find the treasure in it that helps companies grow. Based on these findings, our clients optimise their projects and businesses and become more efficient. A typical data project can include, among other things:

• cleaning and merging data from different sources (e.g. GA4, ad platforms, CRM),
• the data analytics classic: preparing dates and converting them to the right formats,
• analytical work with BigQuery and SQL,
• building clear dashboards in Looker Studio or Power BI,
• interpreting the results for marketing and sales teams,
• proposing optimisations and recommendations based on the data.

We have prepared a sample for you, try it yourself!

Would you like to find out what it’s like to be a data analyst? We have prepared a dataset and a case study based on our real projects. We do analyses and data exploration like this for example for OchutnejOřech.cz.

If you decide to work on the case study, your task will be to:

• understand the structure of the data,
• identify the key metrics,
• uncover interesting patterns and connections using the recommended analyses,
• and suggest how the project’s performance could be optimised based on them.

What the case study will show you

The case study will show you that an analyst’s work is not just about numbers. Above all, it is about thinking, logic and the ability to explain data clearly even to people who are not analysts. Technical skills matter too, but they can usually be taught. What we look for in people is mainly a talent for this field, the ability to get into the problem described, an eagerness to learn and to work independently. You will try all of this in the case study.

You will get a better idea of how we approach projects, how we think about client data and how the technical and business sides of analytics come together at Archetix.

Show us what you’ve got! The assignment

The case study assignment describes the individual tasks and the recommended tools. The assignment is in Czech; if you need it in English, just write to us.

The data: the dataset contains a client’s transactions over the last few years. Use it to work on the tasks from the assignment.

Want to talk about it?

If the work of a data analyst appeals to you and you’d like to go through the results of your case study with us, write to us. We will be happy to discuss your approach, help you interpret the data and maybe even agree on working together.

If so, get in touch at [email protected].

We will start with a phone call to see whether we are on the same wavelength. If we are, an online meeting will follow.

More about us

Archetix are experts in web and data analytics. We always have a tailor-made solution ready for our clients, we can handle problems we have never seen before, and we help companies find and use the treasure hidden in their data. We work with clients mainly through consultations, and our main goal is to turn their data into a source of information that helps them understand the market, gain a competitive advantage and grow their whole business. A consultation is often preceded by data preparation or analysis on our side. We also take long-term care of our clients’ data warehouses and analytics infrastructure (Keboola, BigQuery, dbt, Dataform).