Interactive Dash App to Explore Paraguayan Companies by Territory and Sector

Dash Python
,
1

Hi everyone! :waving_hand:

I’m excited to share a Dash app I developed to explore data on Paraguayan companies. The app allows users to analyze the business landscape from both a territorial and economic sector perspective. It consists of four pages:

1. Home

This landing page features an interactive map of Paraguay. By clicking on a department, users can explore company data either by district or economic sector, depending on their selection. The data can be displayed as either the number of companies or total earnings, shown through bar charts and tables. It also includes general contextual information about the Paraguayan business environment.

2. Territorial Analysis

This section enables users to:

  • Choose whether the analysis should be at the department or district level (departments contain districts).
  • Select multiple territories to analyze.
  • Choose the type of information to display.

Available analyses include:

  • Number of companies by economic sector in the selected territories.
  • Earnings by economic sector in the selected territories.
  • Earnings per company across selected territories.
  • Ratio of companies to population in each selected territory..
  • Ratio of earnings to population in each selected territory..
  • Number of different economic activities present in each territory.

This data is presented using treemaps, bar charts, and summary tables.

3. Economic Activities

This page shifts the perspective to focus on economic activities. In Paraguay, companies must declare the activities they perform. For this project, we focused on the main activity. These are grouped into economic divisions, which are in turn grouped into sections.

Users can:

  • Choose the analysis level: section, division, or specific activity.
  • Select one or more activities to analyze.
  • Choose the type of information to display.

The insights include:

  • Number of companies per selected activity, by department and district.
  • Total earnings by companies engaged in each selected activity, by location.
  • Ratio of earnings to number of companies (a proxy for profitability).
  • Breakdown of companies and earnings by section, division, and activity.
  • Number of districts where each activity is present (activity reach/spread).

4. Methodology

This final page introduces who we are and our motivations for creating this tool. It also describes our data sources, the process followed, and important methodological considerations and limitations to keep in mind when interpreting the results.

The entire dashboard was built with Dash and Plotly, and I’d love any feedback, suggestions, or questions from the community. If anyone’s working on similar regional/economic data visualizations, I’d be happy to connect and exchange ideas!

Here are some of the challenges I’m currently facing:

  1. Mobile responsiveness – So far I’ve only focused on desktop use. I’d like to make the app responsive for mobile devices as well.
  2. Multilingual support – I’m considering releasing an English version, but since it’s a multipage app, I’m still not sure what’s the best way to implement it. Any tips or best practices are more than welcome!
  3. Performance optimization – When deployed on a free server, the app feels a bit heavy. I’m not an expert developer, so I’m sure there are several ways I could optimize my code.
  4. Balancing information depth – I think there’s potential to show more (e.g., distribution of earnings by decile), but I’m concerned it might overwhelm the user. Another idea is to deploy the list of companies based on their selections — though this raises questions about sharing public yet sensitive data.

You can check out the app here :backhand_index_pointing_right: https://geografia-empresarial-del-paraguay.onrender.com/
and the code here :backhand_index_pointing_right:GitHub - CambraBusinessAnalytics/-Geografia-Empresarial-del-Paraguay-

Thanks in advance! :raising_hands:

1 Like
2

That’s a unique analysis and data app, @Jose_Ayala_Cambra . Thank you for sharing.

Is all the data for this app publicly available (from IRE) or is some of it proprietary?

One thing I would recommend in the Inicio tab is to add a loading component (spinner) that will activate to show that the data is being loaded because it takes a few seconds for the graphs to update.

Another small suggestion would be in the Actividades tab. I would pre-populate the dropdown with a value so that an initial graph appears when someone goes to that tab. Otherwise, there is a big blank white space, which looks like something is missing.

P.S. very good usage of the treemap by the way.

1 Like
3

Hi Adam,

First of all, thank you very much for your response and interest.

The data comes from a public source. It was obtained through an official request on the Paraguayan government’s public information access portal. Here is the link: https://informacionpublica.paraguay.gov.py/#!/ciudadano/solicitud/74038

I’ll definitely take your suggestions into account and implement those improvements as soon as possible.

Thanks again for your feedback!

1 Like