I interviewed two Data Analyst positions in BI team. One of them needed a coding test, basic SQL and google spreadsheets skills, but I only had 30 minutes. I didn't have enough time to finish them. You need to be very familiar with spreadsheets functions like IF, VLOOKUP etc. Interview questions focused on case study and my working experiences. - predict the profit of one bread store earning in a day - how do I cooperate with PM & DA - share a project I owned and how did i do it - any difficulty in my current company - what did I do when facing difficulty - ... Those were all good questions and not difficult to answer if you really have those experiences. They would go deeper and deeper to see your answer and reaction . Be fully prepared.