Domanda di colloquio di Octapharma

How do you use Python and SQL together to clean and process data for a project? In Power BI, when would you choose to perform a transformation in Power Query (M) versus using a DAX calculated column? Can you describe a complex SQL query you wrote to solve a specific business problem? How do you optimize a DAX measure that is running slowly in a large report? How do you prioritize your tasks when you have multiple competing deadlines? Tell me about a time a project was delayed. How did you handle the communication and the workload? Can you give an example of a "blocker" you hit in a project and how you moved past it? What is your process for deciding a problem is serious enough to escalate to management? Describe your experience presenting data insights to top management. How do you simplify technical findings for them? How do you handle working in a multicultural team where communication styles might differ?