1. Tell me a case that you presented to stack holders who are not very familiar with data 2. Tell me a case that you analyzed customer relationship data.
Sr Data Analyst Interview Questions
3,099 sr data analyst interview questions shared by candidates
1. Tell me a case that you presented to stack holders who are not very familiar with data 2. Tell me a case that you analyzed customer relationship data.
What insights and questions would you ask about this particular data set?
They asked about my experience managing projects and how I handle resistance from stakeholders. The technical portion included an Excel exercise (mainly using VLOOKUP, IF, COUNTA, COUNT, etc.) on a virtual desktop that lagged frequently, likely due to internet speed. The SQL exercise used outdated software with no autocomplete or script support, requiring manual coding for basic queries and INNER JOINs to combine tables, sort results, and present findings. The computer provided had only a single small screen with no option to project your work, which made it more difficult to manage multiple windows and added frustration during an already stressful process. Candidates should be prepared for these technical and environmental challenges, as they differ from the tools and setups common in modern industry environments.
Data aggregation in R, followed by a shiny dashboard. also : imports Summarize & Aggregate String Extraction & Cleaning Keyword Detection & Summarizing Plots App Error Handling Shiny App
Des tests sur des compétences SQL et Tableau sont à réalisés avant tout entretien
Vers les derniers entretiens, la personnalité et la capacité à pouvoir travailler ensemble sont plus testées que les compétences, les questions peuvent alors aller de "quel est le dernier humoriste qui t'a fait marrer ?" à "que ferais-tu si je te donne 100M€ ?" en passant par "si tu pouvais apprendre instantanément quelque chose, ça serait quoi ?"ou encore un prise de position pour ou contre les trottinettes électriques.
What do you want to work here
Not remember something like r u willing to work in shifts
Question on joins, Analytical functions and window functions. Excel questions in grouping, pivot and qdvanced Excel formulas.
Viewing 1761 - 1770 interview questions