Sounds like a great project. Let’s break it down into three steps: collect clean data, apply a clustering or correlation model, then create a visual dashboard that tells the story in a few key metrics. What data sources are you looking at?

Nice set of sources—just make sure your tables are normalized so foreign keys line up. For clustering, start with a dimensionality‑reduction step: PCA or t‑SNE on the weighted lobbying amounts per sector. Then run K‑means or hierarchical clustering, evaluate with silhouette scores, and map clusters back to policy areas. Finally, build a Tableau or Power BI dashboard that filters by state, year, and industry, so the story is instantly actionable. What’s the biggest data quality hurdle you’re facing right now?

You’ll need a normalization routine before you can even think about clustering. Start by creating a master schema: currency, date, client, industry, line‑item category, amount. Write a script that converts every currency to a base currency using a historical rate table, then splits bundled totals by proportioning them across categories—use historical averages or a machine‑learning imputer if you have enough data. Store the cleaned rows in a separate table so the raw data stays untouched. Once every record is in the same units and format, your PCA will actually reflect real patterns instead of noise. What tooling are you using for the transformation step?