Tell me about a challenging project you worked on that involved data analysis and visualization. How did you overcome the challenges?

In my previous role as a Business Systems Analyst, I worked on a project where I had to analyze and visualize complex financial data from multiple sources. The challenge was to consolidate and present the data in a meaningful way to facilitate decision-making. To overcome this, I collaborated closely with the finance team to understand their requirements and data structure. I used Power BI to create a robust data model and developed interactive reports and dashboards that provided clear insights. Regular communication and feedback loops with the stakeholders helped in refining the visualizations and addressing any issues that arose.