Complex problems require you to understand the connections between things, not just the facts about them, and struggling with spreadsheets and relational databases built to focus on the facts limits what you can learn and wastes your time writing complicated formulas and queries that still aren’t quite right. Countless hours spent analyzing different combinations leaves your head spinning and it becomes hard to see why one solution is better than another.
The City works for complex problems because it lets you investigate how things are connected as much as the facts you have about them so you can easily see bridges and silos. It keeps your data organized because your data model matches with how you think about things in the real world and how you can optimize solutions for a problem is a wholly different capability than repetitive analysis.
Start by modeling your situation in the Cognitive City, visually explore relationships, measure connectedness, and optimize instead of analyze.