We are a consultancy specializing in benchmarking surveys. Each year, we conduct surveys via Excel, gathering 20-30 responses per survey. To date, we have conducted six surveys and are currently running our seventh. Our data pipeline involves extracting survey responses from Excel using Python scripts and storing the structured data in a PostgreSQL database. The dataset is organized into eight tables, which include: • Raw client data (responses) • Calculated client-specific metrics • Aggregated statistics (average, median, min, max, percentile) for both data points and metrics We are seeking an experienced data visualization expert to develop client-specific reports using Google Looker (strongly preferred) or Tableau. Scope of Work • Build structured, dynamic dashboards that visualize key data points and metrics for each client. • Develop a standardized report layout, ensuring identical structure across all clients. • Create visualizations including: • Bar charts (stacked, grouped, horizontal, vertical) • Line charts • Data tables for trended data points • Highlight individual client responses within visualizations (e.g., a distinct color or annotation in bar charts). • Implement filtering capabilities so that selecting a client’s name generates a tailored report. • Generate well-designed PDF reports from the dashboards, including: • Title page • Table of contents • Organized sections based on wireframes (provided in Google Slides) • Text insights and additional elements where appropriate • Ensure the reports are interlinked within the dashboard for ease of navigation. Project Details & Requirements • Number of data points & metrics: 258 total, with 188 requiring visualization. • Data types: Integer, float, string, dropdown (categorical). • Data preparation: No SQL or transformation required—all data is already structured for reporting. If adjustments are needed, we will provide the necessary data format. • Tool preference: Google Looker (preferred) or Tableau. • Deadline: Final PDF reports must be available by April X, 2025. Ideal Candidate • Strong experience with Google Looker (preferred) or Tableau. • Expertise in data visualization & dashboard creation for business intelligence reporting. • Experience working with structured datasets (preferably in PostgreSQL). • Ability to create clean, professional PDF reports with consistent formatting and filtering capabilities. • Attention to detail in ensuring accuracy and readability of reports. • Proactive communicator who can work efficiently with provided data and wireframes.
Keyword: Design visual
Price: $75.0
Data Visualization Google Analytics Tableau Python
We are seeking a detail-oriented individual with strong Excel skills to create comprehensive year-to-date (YTD) monthly sales spreadsheets for our business. The goal is to organize and streamline our sales data across three key platforms—Distributor Sales, Shopify, and ...
View JobI’m looking for a talented graphic designer or artist to bring my self-help book cover to life. The book empowers readers to embrace confidence, emotional intelligence, and unapologetic authenticity—with a bold, edgy, and modern tone. I want a cover that visually captur...
View JobAbout Us GovPilot is a leading provider of cloud-based government management software, dedicated to streamlining operations and improving service delivery for local governments. We’re currently embarking on an exciting project to develop a next-generation platform, and ...
View Job