Boosting development impact: Data visualisation with ShinyApps and PowerBI, featuring real-world case studies

ShinyApps vs. PowerBI: Evaluating data-communication tools

When working with data communication and visualisation, tools like ShinyApps and PowerBI can be useful. Both platforms offer diverse features suitable for different needs, particularly in staff and public communication. This blog post takes a look at their capabilities in user management, accessibility to unauthenticated users, and overall suitability for project reproducibility and customisation.

Many humanitarian and development organisations use PowerBI for data visualisation, but they might be missing out on the powerful capabilities of ShinyApps. When needing more sophisticated analysis and flexible tools, ShinyApps is the better choice. It supports advanced data handling and real-time analytics, and its ability to be fully customised means it can adapt better to complex projects. Besides, ShinyApps can significantly enhance decision-making and project outcomes if combined with features of R and Python.

User management and accessibility

ShinyApps, a web-application framework powered by R, allows for the integration of sophisticated analytical work directly into an interactive web application. It supports user authentication through shinyapps.io, which can manage access at a basic level. For more advanced user management, integrating Shiny with third-party tools like Auth0 is possible, allowing for secure and flexible user roles and permissions.

PowerBI, Microsoft’s analytics service, offers user management capabilities inherent to the Microsoft ecosystem, such as Azure Active Directory. It provides robust access controls and the ability to publish reports with various permissions, catering well to enterprise environments.

Regarding accessibility for unauthenticated users, ShinyApps can freely share apps with the public, although this requires the app to manage its own user authentication for finer access control. PowerBI, however, generally restricts sharing publicly, necessitating a PowerBI Pro license for each user, which can be a significant barrier for widespread public access.

Templating and reproducibility

ShinyApps excels in templating and reproducibility due to its use of R and, potentially, Python scripts. This feature enables the creation of highly customizable templates that are easily adjustable and reusable across multiple projects. Such flexibility is crucial for organisations that routinely perform analytical tasks across diverse datasets.

PowerBI adopts a GUI-based approach (”graphical user interface”) that facilitates report-building without extensive coding. However, this ease of use can lead to limitations, particularly in the context of humanitarian and development actions. For example, PowerBI may not automatically calculate specific indicators crucial in these fields, such as Food Consumption Scores and Livelihood Coping Strategy Indexes. PowerBI also lacks support for qualitative data analysis, which precludes the use of mixed methods in monitoring and evaluation—considered best practice. These limitations result in reduced flexibility, scalability, and increased costs. Replicating a PowerBI project involves more than merely reusing a script; it often requires navigating the platform’s interactive design. This setup complicates the process of adapting a project’s framework for different datasets or objectives, especially across varied projects, potentially increasing costs and limiting adaptability.

Advanced customisation and analysis

ShinyApps excels in customizability due to the underlying use of R. It can incorporate the latest algorithms and statistical methods, including text mining and even AI-driven analysis, though these might require more sophisticated coding skills and understanding of the underlying data science.

Conversely, PowerBI integrates less smoothly with advanced analytics. While it does support R and Python scripts, the integration often feels like an add-on rather than a core feature. This limitation becomes apparent when conducting in-depth qualitative analysis or applying complex machine-learning algorithms directly within the tool.

Showcasing the public dashboards 

At movimentar GmbH, we maintain a commitment to utilising advanced data visualisation tools to enhance the transparency and impact of development and humanitarian projects. Here, we highlight three cases from our work where we used Shinny App to design. The tree are public dashboards that illustrates our work and the ongoing outcomes of these initiatives.

1. Faith for Peace – Nigeria

Project overview: The “Faith for Peace” initiative in Nigeria is a collaborative effort funded by EuropeAid, aimed at promoting peacebuilding, human rights, democracy, and religious tolerance. Led by the German NGO Bread for the World, along with the partners CCAPAD and TEKAN, the project focuses on empowering community-based groups, CSOs, CBOs, and religious leaders across 12 communities in Gombe and Nasarawa states.

Our mission was to develop a dashboard which provides insights into collaborative efforts and capacity building for peace and human rights advocacy. The dashboard includes various visualizations such as bar charts, line graphs, and maps to display data on peacebuilding activities, trends, and geographical distribution. Our aim was to design a dynamic tool that facilitates real-time monitoring and evaluation, leveraging gender-sensitive and disaggregated indicators to tailor interventions effectively.

Dashboard link: https://movimentar.shinyapps.io/faith4peace/

Project duration: April 2023 to September 2025

2. Ekoliso – Angola

Project overview: The “Ekoliso” project, conducted in Angola, was designed to enhance dialogue and development in the provinces of Huíla and Huambo. This initiative was spearheaded by Bread for the World with the local partnership of ADRA. It focused on strengthening the capabilities of rural communities and CSOs, aiming to have a direct impact for over 24,000 individuals.

The dashboard served as a practical tool for visualising the development impacts across multiple communities targeted by the project. The use of the Shiny App provided us to handle real-time data feeds, which is vital for monitoring environmental conditions and responding to changes promptly. It documented the enhanced engagement of local groups and showcased the improvements in rural livelihoods and social cohesion through visualising the achievement of the project indicators.

Dashboard link: https://movimentar.shinyapps.io/ekoliso/

Project duration: March 2017 to February 2018

3. EU ACT – Transregional

Project overview: The “EU ACT” project focused on addressing drug-related organised crime along the so-called “Heroin Route”. Managed by FIIAPP with a budget from the European Commission, the project targeted several countries from Eastern Europe to East Africa, aiming to improve policies and cooperation against drug trafficking and organised crime.

This dashboard illustrates the geographic reach and the broader approach of the project, by showing, among others, the total number of beneficiaries, participants’ feedback, and demographic information. Shinny allows that users can filter and drill down into specific projects, regions, or funding periods to get detailed insights.

Dashboard link: https://movimentar.shinyapps.io/eu-act-dashboard/

Project duration: January 2017 to December 2021

Conclusion

Choosing between ShinyApps and PowerBI depends significantly on the specific needs of an organisation. ShinyApps offers superior customisation, flexibility, and reproducibility, making it ideal for projects that require deep data analysis and bespoke application needs. PowerBI is highly effective for quick deployment of interactive data reports within an ecosystem that prioritises ease of use over deep customisation.

The choice on using Shinny App for designing the dashboards was integral to our strategy of ensuring accountability and enhancing the effectiveness of complex development initiatives. They are a result of movimentar GmbH’s main goal to support its partners and stakeholders in making informed decisions that drive sustainable development and humanitarian outcomes.