Tableau Dashboard Consultant — Translate Lovable Dashboard Concept into Tableau BI

We are building a multi-layered executive & leadership dashboard for a B2B/B2B2C company in the cold-chain / pharma logistics space. The concept and first UI prototype have been created in Lovable and now need to be translated into a robust, scalable Tableau dashboard connected to real data sources. Scope of work Analyze the existing Lovable concept Review the current dashboard structure covering: Executive Board (revenue, margin, liquidity, NRR, churn, pipeline, OKR health, etc.) Operational Value Stream (sales, marketing, customer success, support, operations) Development Value Stream (engineering/flow, product management, shipment insights, quality guardrails) Shared Services (people, finance, quality, IT, warehouse, legal, procurement) Pharma/GxP sub-dashboard (GxP-specific metrics, CFR21, audit readiness, stability budget) You will receive a live preview link, exported screenshots, and the underlying KPI framework documentation. Challenge every KPI for feasibility and accuracy For each metric you must work with the client to confirm: Exact business definition and calculation logic Whether the data currently exists and in which source system Data quality, freshness, and granularity limitations If a KPI is a proxy, estimate, or cannot be reliably sourced Recommended fallback or removal if a KPI is not instrumentable The goal is not to blindly copy the Lovable dashboard into Tableau, but to build a production-grade KPI system that is trustworthy and defensible to the Executive Board. Design and build the Tableau dashboard Translate the validated KPIs into a clean, interactive Tableau workbook with: Executive summary view + drill-downs by function/team Consistent filtering (time period, business unit, region, customer segment, product line) Clear status indicators (on track / watch / at risk) Mobile-friendly layout where possible Documentation of calculation logic and data lineage Integrate multiple data sources We expect data to come from a mix of systems, e.g.: CRM ( Salesforce) ERP / finance system HRIS / people platform Jira / project & engineering tools Support / ticketing tools Warehouse / IoT / shipment data platforms Spreadsheets or manual inputs for not-yet-automated metrics You will design the data model and advise on the most reliable integration approach (Tableau extracts, live connections, middleware, or interim manual uploads). Deliverables KPI feasibility & data-source assessment matrix Recommended dashboard architecture and data model Tableau workbook(s) with the validated dashboards Calculation-logic documentation (one-pager per KPI) Brief training / handover session for internal stakeholders Optional: recommendations for closing data gaps Required skills & experience Strong Tableau development (calculated fields, LOD expressions, data blending, parameters, dashboard actions) Experience with executive / board-level dashboards in B2B, SaaS, logistics, or pharma/GxP environments Ability to translate business requirements into KPI definitions and challenge assumptions Comfort working with multiple, imperfect data sources Excellent written English and German is a plus Prior Lovable, Figma, or similar no-code prototype experience is helpful but not required Familiarity with GxP, CFR21, quality metrics, and cold-chain / IoT data is a strong plus Working model Start with a paid discovery / assessment phase (1–2 days) to review the concept and produce the KPI feasibility matrix Continue with dashboard build-out in 1–2 week sprints Regular async updates and short video calls with the client All deliverables handed over in the client’s Tableau production environment To apply, please include: Two examples of similar dashboard projects (Tableau links or screenshots) How you typically validate whether a KPI can be accurately calculated from source data Your experience with multi-source data integration Your approximate availability and hourly rate A short note on whether you have worked in logistics, pharma, or cold-chain before