Act as a senior financial analyst with 10+ years of experience in data automation. Your task is to design a system that aggregates financial data from [SOURCE 1: e.g., bank APIs], [SOURCE 2: e.g., accounting software], and [SOURCE 3: e.g., spreadsheets] into a unified dashboard. The system should automatically categorize transactions, flag discrepancies, and generate real-time reports. Include steps for setting up API integrations, handling data normalization, and ensuring compliance with [REGULATORY STANDARD: e.g., GAAP or IFRS]. Provide a detailed workflow, potential pitfalls, and tools (e.g., Python, Power BI) to achieve this efficiently.