Halloween Special - Data Horror Stories

The Clearly Podcast

31-10-2023 • 26 mins

In this podcast, the team discusses common data horror stories in IT consulting. They highlight the issue of hiding bad data with filters in reports instead of fixing errors at the source, leading to bigger problems during system migrations. Another problem discussed is trying to use tools like Power BI to mimic Excel functionalities, which leads to alignment and maintenance issues since Power BI and similar tools are not designed to replace Excel.

The conversation touches on the issues with manipulating data in Excel before importing it into Power BI, causing inconsistent data and errors. There's also a focus on the importance of cleaning data before migration to avoid transferring existing problems to new systems.

They mention the challenges of treating estimates as fixed prices and the tendency of clients to ask for continuous changes, causing scope management issues. Another point raised is the problematic practice of turning prototypes into production reports, leading to more issues because prototypes are not meant for long-term use.

The discussion also covers the problem of having poorly defined measures across different departments, resulting in inconsistencies in reporting. Lastly, they emphasize the importance of understanding one's own data to ensure accurate and effective data management and reporting. The episode concludes with a reminder to stay safe and avoid nightmares from data horrors.

You can download Power BI Desktop from here.

If you already use Power BI, or are considering it, we strongly recommend you join your local Power BI user group here.

To find out more about our services and the help we can offer, contact us at one of the websites below:
UK and Europe: https://www.clearlycloudy.co.uk/
North America: https://clearlysolutions.net/

You Might Like

Darknet Diaries
Darknet Diaries
Jack Rhysider
Double Tap
Double Tap
Accessible Media Inc.
TechStuff
TechStuff
iHeartPodcasts
Waveform: The MKBHD Podcast
Waveform: The MKBHD Podcast
Vox Media Podcast Network
Fortnite Emotes
Fortnite Emotes
Lawrence Hopkinson
Acquired
Acquired
Ben Gilbert and David Rosenthal
Hard Fork
Hard Fork
The New York Times
Talkin' Shop
Talkin' Shop
Eclipse Automotive Technology
The Vergecast
The Vergecast
The Verge
RNIB Tech Talk
RNIB Tech Talk
RNIB Connect Radio
Smashing Security
Smashing Security
Graham Cluley & Carole Theriault