Pergunta de entrevista da empresa LexisNexis Legal & Professional

How do you handle missing or inconsistent data in a dataset? What’s the difference between an inner join and a left join in SQL? How would you identify outliers in a dataset? Can you explain a project where you used Tableau (or Power BI) to create actionable insights? How do you decide which visualization type to use for different kinds of data? What are some common KPIs you’ve worked with in your previous roles? How would you approach analyzing customer churn data? What steps would you take to validate the accuracy of your analysis? Can you explain the concept of correlation vs. causation with an example? How would you optimize a slow SQL query?