Google Sheets Data Analysis Setup

I’m working on a Google Sheets project that has outgrown basic formulas and now needs a deeper, more professional touch. The core of the job is to turn raw information—coming in regularly as CSV or Excel files—into clear, reliable insights directly inside Sheets.

Here’s what I need:

• Smooth import and export routines for those CSV/Excel files so I can refresh data without breaking references.
• Thoughtful data modelling that makes later analysis painless.
• Dynamic charts, pivot tables, and other visualisations that update the moment fresh data lands.

If you prefer using built-in connectors, the IMPORT functions, or even App Script for the file intake, I’m open, as long as the result is dependable and easy for me to maintain. Once the core workflow is in place, I’d like a concise walkthrough (video or short doc) so I can extend or tweak the work myself later.

Acceptance criteria
– One shared Google Sheet linked to a sample CSV/Excel upload, refreshing successfully on demand.
– At least three interactive visual elements (chart, pivot, or slicer) reflecting the imported data accurately.
– No broken formulas or manual copy-pasting required after hand-over.

If this sounds straightforward to you and you’ve built similar analytical dashboards in Google Sheets before, let’s talk timing and next steps.