fbpx

open challenges

Data dashboard design for a 100-year-old Made in Italy agribusiness company

Artificial Intelligence – Data Science

Data dashboard design for a 100-year-old Made in Italy agribusiness company

Challenge Description:

We are seeking an experienced data analyst or business intelligence (BI) developer to design and implement an effective data dashboard for a major Italian agribusiness company.

With a rich heritage of more than a century, this family-owned business has established itself as a leader in the production of high-quality food products. The company invests more than 3.5 percent of revenue in innovation and plans to leverage data-driven insights to further improve its success in Italy’s second-largest manufacturing sector.

Key requirements:

The company is trying to develop a comprehensive data dashboard that is in line with its goals and objectives. The dashboard must meet the following requirements:

  1. Essential metrics: identify key metrics that align with company goals, including revenue, profit margins, market share, customer acquisition, customer retention, product performance, and inventory levels.
  2. Logical Hierarchy: organize metrics in a logical hierarchy, presenting high-level summaries with the option to drill down to more detailed information. This will enable users to quickly grasp overall performance and identify areas for further analysis.
  3. Effective visualizations: use appropriate visualizations such as line graphs, bar graphs, pie charts, and tables to represent data clearly and concisely. Apply color coding and highlighting to draw attention to critical information and trends.
  4. Interactive functionality: allow users to filter and manipulate data according to their specific needs. Incorporate drop-down menus, check boxes, and date range selectors to provide customization options and facilitate in-depth exploration.
  5. Benchmarking: include features that allow easy comparison across different time periods, product lines, geographic regions, or other relevant dimensions. This will help identify patterns, trends, and outliers that affect the company’s performance.
  6. Responsive Design: design a responsive dashboard, making sure it adapts to different screen sizes and devices. Consider accessibility guidelines to ensure that all users, including those with disabilities, can access and understand the information presented.
  7. Clean and intuitive interface: aim to achieve a clean and intuitive design, avoiding clutter and complex images. Use clear labels, headings, and hints to guide users and improve their understanding.

Technical Specifications:

Preferred software tools:
  • Data visualization: Tableau, Power BI or QlikView for creating visually appealing and interactive data visualizations.
  • Database Management System (DBMS): Microsoft SQL Server for efficient data storage and retrieval.
  • ETL tools: Talend or Pentaho to extract, transform and load data from various sources into the dashboard.
Software-related requirements:
  • API support: make sure the dashboard software supports the necessary APIs, especially the .NET APIs or provides connectors for seamless integration of data from different sources.
  • Implementation of data preprocessing and cleaning: apply appropriate data preprocessing and cleaning techniques to ensure accuracy and consistency of data before visualization.
Hardware requirements (at customer’s disposal):
  • Sufficient processing resources, including processing power, memory, and storage capacity, to handle smooth data processing and visualization.
  • The architecture must be based on Microsoft Azure cloud services.
  • High-resolution displays to effectively present detailed visualizations and ensure clarity.

Project Details:

The project timeline is three months from the start, and communication with the external expert will be facilitated by a Widecons Delivery Manager. The compensation will be agreed upon before the start of the project.

Please provide a summary of your expertise and proposed approach to meeting these requirements, highlighting your expertise in the tools mentioned and ability to meet key customer requirements. We are ready to receive your proposals!

Participate in this challenge!
Leave your details, we will get back to you!
I have read the privacy policy and consent to the storage of my data, in accordance with the European Data Protection Regulation No. 679/2016 (GDPR).

Let us know what you are capable of!

Fill out the form found by clicking on the button below. Let us know your story and what fields you excel in.