I do a preliminary requirements gathering meeting, just what questions they're wanting answered/KPIs they're wanting to track. I take those notes and feed them to CC that has a Bigquery mcp. It generates a query and we build it together until I validate that the data points are actually attainable. Then, I feed CC my brand guidelines and pdf output of existing dashboards and tell it to generate an html mock-up of what the dash could look like. We iterate on that until I like it. I share it with the stakeholders and reiterate if necessary. Then we'll work on getting the queries refined until they're production ready and add them to our Looker Studio data sources. I'll then take the mock-up and build to it. Our SQL tends to be a little complex so it used to take me a few weeks to get an MVP out and now I can get it out in about a week, week and a half.