This question originally runs on Quora.
Not every data analyst’s role is the same, much as not every CEO’s role is the same. Different companies at different stage will have different set of data challenges, so no one-way-fit-all.
Think about what problems the company tries to hire you to solve.
I’ve worked with a few good data analysts, and generally I observe them being good at the following:
- Good business sense
- Good data/numbers sense
- Good technical skills (SQL, Python, R)
We've written before a guide for employers to interview data analysts together with some sample questions. Perhaps you can take some inspiration for yourself. Some examples:
- If you run an ecommerce site, how to measure the effectiveness of the Search feature of an ecommerce website?
- How would you design a sales funnel, how would you implement some tracking to measure conversions by different source?
- What do you understand about our business, and how would you measure the business’ performance?
On top of that, do the necessary research similar to as if you’re applying for any other role.
Subscribe to Holistics Blog - The Data Analyst Guidebook
Get the latest posts delivered right to your inbox
From SQL Queries To Beautiful Charts
Connect to your database and build beautiful charts with Holistics BILearn More
"Holistics is the solution to the increasingly many and complex data requests from the operational teams"
Tang Yee Jie
Senior Data Analyst, Grab