BigQuery & Looker Studio Setup

I have a collection of CSV files that need to live in BigQuery and feed directly into Looker Studio dashboards. The workflow I have in mind is straightforward: create the initial dataset and tables in BigQuery, load the first batch of files, then automate a weekly refresh so each new CSV lands in the right spot without manual intervention.

Once the data sits reliably in BigQuery, I’d like clean, visually clear reports in Looker Studio that focus on two areas—sales results and overall operational performance. Think trend charts, variance indicators, and drill-downs that anyone on the team can use without additional training.

Deliverables
• BigQuery dataset and table schema set up for incoming CSVs
• Automated weekly load process (Cloud Console, Cloud Functions, or another native method—whatever you feel is best)
• Connection between BigQuery and Looker Studio confirmed and documented
• Two interactive dashboards: one for sales, one for operational performance, each with filter controls and export options
• Brief hand-off guide so I can maintain the pipeline and tweak the visuals later

I’m happy to answer any technical questions you have about the current file structure or naming conventions. Let me know your approach and estimated timeline so we can get started.