Real-Time Business Dashboards Build Preferable Looker Stuido

Job ID: 39850701

Budget: $10 – $30 USD

I need four executive-grade dashboards—Snapshot, Pulse, Apex, and Custom—designed and built for Intelura so I can pull client performance and competitor insights for restaurants, clinics, and retail brands at a glance. Each dashboard must stay in sync with a live Google Sheets data source, refreshing automatically and ready for one-click export to an A4-formatted PDF.

The style I’m after is unmistakably corporate: clean lines, modern typography, restrained colour use, and visuals that feel board-meeting ready. Within those layouts I want clear KPI blocks, trend lines, competitor comparisons, a concise SWOT section, and a space for narrative insights. Key metrics to highlight are customer satisfaction scores and wider market-trend indicators; sales figures and other data can sit in the background but the focus needs to remain on those two headline themes.

You can build in Google Looker Studio—my first choice—or an equivalent platform such as Power BI or Data Studio as long as the Google Sheets connection is seamless. Native PDF export, filter controls and sharable links are essential. I’ll provide the structured Sheets; your job is to handle schema mapping, visual layout, conditional formatting, and any calculated fields so the dashboards update in real time without manual intervention.

Deliverables
• Four fully functional dashboards (Snapshot, Pulse, Apex, Custom)
• Live connection to my Google Sheets with automated refresh
• Corporate-style visual theme applied consistently
• Export preset for A4 PDF with print-friendly margins
• Handover of edit access plus a short Loom walk-through showing how to add new data rows and regenerate the PDFs

If you’ve crafted similar real-time reports before and are confident with Looker Studio’s data-blending, please let me see a sample so we can get started right away.