Guest Post: Power BI in Library and Information Science

For the last few days, I have been attending the EBLIP10 (Evidence-Based Library and Information Practice) conference at the University of Strathclyde. As a recent Information and Library Science grad, I put myself down as a student volunteer so I could sit in on some of the sessions for free (and eat the fancy lunches – they had vegan tacos, so you could imagine the position I was in).


As you can maybe imagine, a large amount of the talks were library-centred; targeted at librarians who want to implement a more evidence-based practice in their workplace, or researchers looking to improve their methods. I was fortunate enough to attend some fascinating lectures that I may otherwise have never thought much about, and get to know some lovely and interesting information professionals from all over the world, from Portugal to Canada to Mexico.


One of the speakers, Louise Graham from the Scottish Library and Information Council, spoke on the importance of evidence of impact in public libraries. Describing the process her and her team had gone through in implementing new technology throughout Stirling Council Libraries to work on quantifying evidence of how patrons benefited from using their local public library, Graham spoke on the complexities and benefits of user-friendly data collection.


Credit to myrfa at Pixabay

Stirling Council Libraries now have a collection of touch-screen devices in their libraries that allow patrons to outline their feelings about and experiences of the library, largely via simple visuals. If a patron wanted to convey to the staff that their favourite thing about their library was the space to sit down and read in a quiet environment, they would tap on a picture of a person reading a book on a sofa. The platform was designed to be as accessible as possible to everyone who wanted to use it, and it resulted in hundreds of submissions within the first few weeks, and a wealth of evidence for the librarians to have to hand if they ever needed to defend their library.

Defending Libraries with Data

However, one thing I learned from attending EBLIP10 was that there are so many different ways to collect and display evidential data. As many of the speakers at the conference were researchers, PhD students and lecturers, a lot of this data was displayed via published papers in academic journals. But this medium isn’t usable for everyone – and certainly not those of us who are not in academia.

Since I’ve started working recently as a Data Translator for Data Relish, and am currently working on training programs for Power BI, it got me thinking – are there ways that we can use Power BI to effectively and accessibly display evidence of our work?

When it came to making evidence easily-accessible, particularly for our colleagues and customers who may not have been involved in the rest of the process, my first thought was Power BI Service and the Power BI mobile app.

Operating the full desktop version of Power BI may not be the most efficient way to quickly demonstrate that your work has yielded tangible results – when you’re looking for an in-depth analysis, it’s the ideal option for sure, but sometimes what you need is a clear, visually-appealing display of your data that a customer or less-experienced colleague can pull up quickly and understand at a glance.


This is the beauty of the Power BI Dashboard, in all its forms; it’s evidence of your results that anyone can understand – and enjoy looking at – regardless of whether or not they’re an experienced data scientist. And if you want clear evidence of how your work is going well, or helping others, you can’t make it so dense and complex that only a data scientist will be able to parse it. Your stakeholders are more likely to want to see your evidence represented in clear visuals.


Many of the speakers at the conference, while their presentations were clear and effective, presented the results of their studies in tables, and long lists of data. This was fine for those of us who were at the conference in person – we could see the slides up close, so it was easy enough to get an idea of what the data was representing. But the small text that came with fitting long lists on one PowerPoint slide caused a few problems.


Part of my job as a volunteer was to manage the virtual conferencing. Virtual attendees had paid £65 to watch the presentations via webcam, and it was my job to mute and unmute them, convey their questions to the speaker, and straighten out any issues as best I could. The biggest problem by far that I had to tackle was the virtual attendees being unable to read the small text; many of them completely missed out on any visual representation of the speakers’ findings. The webcam wouldn’t pick up the text – at a conference on evidence-based practice, they were missing out on the actual evidence! And making me so frazzled I had to go and stress-eat a bunch of tacos behind the reception desk! 


There’s no doubt in my mind that many of these findings could have been improved if the speakers had had a tool like Power BI at their disposal. Had they been able to turn their long lists of data into representative visuals, everyone would have been able to understand it at a glance, rather than squint at their screens and try to read some under-pixelated numbers.


Power BI could be a strong tool for research, particularly research where concrete evidence is paramount – and particularly research where those findings will be helpful and interesting to those outside your immediate professional circle. Some of the available visualizations look lovely, and can make even the drier data look more engaging.


Power BI is a perfect way to tailor the presentation of your findings to your audience, and there seem to be few corners of the professional world where it wouldn’t come in handy.

Why is sustainability important in supply chains?

Social impact can act as a differentiator that creates more value for the supplier and the buyer — it’s a ‘give-win’ situation for all involved. Organisations have to do this intelligently, and offering them an intelligent spend platform can help them drive cost savings, increase sustainability, and, crucially, protect the brand and drive value.

The Boston Consulting Group are calling for Purpose 2.0. Boston Consulting Group found that, in procurement, social impact was thirteen times more likely to be selected than a dollar discount. B2B should be leveraged to lift shareholder value as well as have a positive social impact. There is an inherent shared value in social impact — both the seller and the buyer are bound to benefit. This means that organization will need to consider leveraging social impact that aligns with  business’ corporate goals. CSRHub, for example, provide access to the best sustainability metrics in the business.


Credit: Alexas_fotos at Pixabay

How can organizations can get started? When choosing suppliers, we should care about the purpose and what the business stands for. The organization can lead by example rather than shaming organisations.

Organizations can start to think about issues that they care about, and start to measure it. One idea: any RfP should have a metric on the reduction of plastic. This requirement would transmit to their suppliers which would, in turn, transmit to their suppliers.

When organizations make decisions, they want to focus on supporting sustainability-based businesses. Businesses want to leverage these sustainability efforts.

Organizations need to publish sustainability goals and be transparent about how they are meeting them. For example, SAP publish their information here.

Organizations can get started right away with sustainability initiatives by using data to support their decisions.

Data will give more value and insights on sustainability, thereby providing support to organizations that want to implement sustainability initiatives. Data is needed to support collaboration and give  valuable insights.


Credit: Alexas_fotos at Pixabay

Data can help us to think productively about investing in social impact. Organizations can consider using data as a tool to help organizations to apply social impact initiatives and be agents of social change: all the actions we take as individuals, however small, can really add up. As part of an organizations, we can do so much more.

Where can organisations get data? The Global Impact Sourcing Coalition make great use of data in order to help drive social change. By connecting through the world’s only Impact Sourcing Supplier Directory, they facilitate connections between employers and those looking to take their first steps onto the career ladder, and help to work towards their vision of ensuring that all people have the opportunity to find decent work. Similarly, BSR Collaborative Initiatives create jobs for those most in need through the power of procurement and global supply chains. 

The UN Global Compact provides support to companies to help them do business responsibly, by  helping them align their strategies and operations with the Ten Principles on human rights, labour, environment and anti-corruption, and recognise their fundamental responsibility as businesses in upholding these principles. Furthermore, the UN Sustainable Development Goals, building on the principle of “leaving no one behind” and emphasising a holistic approach to sustainable development, outlines seventeen goals to “transform the world for persons with disabilities”, with one of their objectives being to establish an ongoing live web resource for each goal and each disability. The Sustainable Goals are provided below:

UN Sustainable Development Goals

How should organizations get started? The UN Sustainability Development goals are a good starting point to inform direction. There has to be a proper strategy in place to connect the moving parts. There should be ladders going up and down up and down from business goals to government national state goals.

Businesses could do more than what they  are currently doing, but there is a promising future ahead in terms of development.

It is important to take strategic actions to advance broader societal goals. Ideally this strategy should correspond to the agenda that the UN set with their Sustainable Development Goals agenda — and there should be an emphasis on collaboration and innovation in the undertaking of these actions.

The UN’s 17th SDG is “Partnerships to achieve the Goal”, and this is something all organizations should all be striving to incorporate into our own practices. Partnerships are essential, including with consumers. Ultimately, everyone should be involved, and, together, we can make a huge impact for good using business as a force for good and a force for change, moving in the direction of travel of other organizations.