You are working on a dashboard for a business team that needs metrics from several source systems in one place. The data comes from transactional tables, API feeds, and scheduled extracts, and the team wants a single view with consistent definitions for the same business entities. The main challenge is getting the data into a shape that supports reliable joins, refreshes, and downstream reporting.
How do you handle a request to combine data from multiple sources into one dashboard?
