November 17, 2020
Bulk renaming columns in a table using a Power Query Custom Function
If you've ever exported data from your ERP system and imported into Power BI, you'll be familiar with the rigmarole of renaming hundreds of columns to a more descriptive name. It's both time-consuming and prone to human error.
June 15, 2020
UX Analytics: tools, testing and pro tips
“Normal work” has been changing a lot for people working in customer experience! Many UX designers are working from home and might do so for a while. This means you’re probably adjusting the way you collaborate and undertake research - including using Miro boards, real-time ‘co-editing' within your Adobe XD document and Teams/Zoom user interviews.
March 31, 2020
The data debt that comes back to bite us when we least need it
Everyone knows that information is power, and that accurate, timely and actionable insights are even more powerful. When the economic situation we live in is healthy, and there is certainty, a lot of companies and organisations take this for granted or even ignore it.
March 9, 2020
Top 3 best practices for dashboard design
An increasing number of organisations are adopting self-service BI, leading to the production of more reports and dashboards. Unfortunately, this often equates to a lack of governance and data literacy. Many people creating these reports and dashboards often have little formal training in the analytics space, leading to an abundance of visualisation artefacts that don’t adhere to some of the fundamental dashboard design best practices.
May 19, 2017
Realising the benefits of data lakes
A data lake is a repository for storing vast amounts of raw, streaming or unstructured data. With a data lake, organizations can store data from multiple sources, without having to model it first. The promise is great - data lakes, when executed well, can provide input into and receive real-time updates from operational applications, as well as providing true, consistent, actionable insights to business users.