Categories
Data Information audit Software

Growing Trust in Power BI Reporting

Want to build trustworthy Power BI reports? This article emphasizes the importance of branding, storytelling, standardizing footers, thorough documentation, clear commenting, and validating metrics. These practices ensure reports are accurate, auditable, and resilient, fostering confidence and trust among stakeholders.

Categories
Software Automation Data Social Learning

With Great Power Comes Great Responsibility: A Look at Artificial Intelligence

As we delve inexorably into the inevitable world of AI we’re finding it has the potential to revolutionize our lives in countless ways, from automating tasks to pioneering scientific breakthroughs. With this power comes a great responsibility to ensure AI is developed and used ethically. In this blog post, we’ll explore the basics of AI, […]

Categories
Automation Data Software

Transform your data in PowerAutomate

Super-charge your automations in PowerAutomate by customising the data coming into it using Power BI’s query editor…

Categories
Data Intranets Software

Power BI : Learn to build free Venn and Euler diagrams

Grouping datasets into overlapping circles can, in many cases, allow your audience to easily grasp relationships between them. Power BI comes a bit short in being able to deliver on this, with no out-of-the-box visualisations for Venn or Euler graphs – and the custom visualisations are lacking essential features or cost up to US$5,000 p/annum. […]

Categories
Data Intranets Software

Power BI – Keeping it Simple

You know the scenario – you throw some visualisations together and publish a proof of concept. People love it, and start filling up your backlog. You quickly add new features accordingly, and before you know it you’ve an unintelligible mass of pages, charts, tables, filters, maps, and text boxes; the ‘love’ turns out to be […]

Categories
Software Data

Power BI Toggle Switch visualisation updated

Sometimes it’s the little things that get me excited; so I was delighted to find out the Power BI toggle switch visualisation has been updated. This handy little graphic allows a user to click on it to filter the data in other visualisations to a value, or values, that you specify in the options; and […]

Categories
Software Data

Conditional formatting based on values from another query

We an issue we were able to cunningly solve in the query editor; we wanted to show in our report which values in one query had a match in the other. One query was a list of features on a site, the other was a list of core features. We wanted the site features to […]

Categories
Automation Software

PowerAutomate: Copy/Paste switch conditions

I was delighted to see the ‘Copy to/Paste from clipboard’ feature introduced some months ago; however I could never seem to get it working from one switch condition to another. After a bit of research, I found a way to do it…

Categories
Internet tips Open Source Software

WordPressing with style Part 2: Plug-ins

What is a plug-in? Where do they go? What are the essential ones? And where do I find them all in one file? Let the Information Handyman guide you through this three-step process for adding functionality to your WordPress installation…

Categories
Software Classification EDRMS and ECM Records Management

How to Manage Emails: Taming the Outlook silos with Mail Manager

One of the abiding concerns of records managers is how to manage emails. Theoretically it is simple; they should be managed as you would other records. Practically, however, the situation is fraught with complexity…