Our company sells products on European marketplaces (including Poland, Germany, Czech Republic, and other countries). All operational reports are stored in a PostgreSQL database.
It is necessary to set up data visualization in one of the BI tools: Power BI or Looker Studio (formerly Data Studio) — depending on your experience and recommendations. The goal is to create clear, interactive reports with filtering and detailed viewing capabilities.
What needs to be done:
Connect to the PostgreSQL database.
Configure dashboards with filtering options by the following slices:
• By period: day, week, month, quarter
• By countries/regions: Poland, Germany, Czech Republic, etc.
• By suppliers
• By marketplaces
• By SKU (products)
• If needed — by product categories, order types, sales channels, etc.Ensure the possibility of dynamic filtering and drill-down (detailed data viewing).
Optimize query structure (create views or subqueries in PostgreSQL if necessary).
Documentation/training: a brief user guide and the possibility to transfer rights for independent editing.
Technical details:
• Data source: PostgreSQL (I will provide access or dump)
• Visualization tool: Power BI or Looker Studio (open to suggestions)
• Work format: project task, possible phased implementation
• Desired timeline: 7–14 days from the start
Candidate requirements:
• Experience with PostgreSQL and SQL queries
• Proficiency in Power BI and/or Looker Studio
• Experience building dashboards for e-commerce / marketplaces or large retail chains (for example, IKEA) — mandatory
• Understanding of basic business analytics and KPIs for trading
What to include in your response:
• Examples of previous dashboards or visualizations (screenshots or links)
• The tool you propose to use and why
• Preliminary estimate of cost and timeline