Dealing With a Mess of Data Systems and Products

The Clearly Podcast

26-05-2024 • 39 mins

Send us a Text Message.

Hosts: Andy Clark, Tom Gough

Guest: Greg Bounds

Topic: Dealing With a Mess of Data Systems and Products

Key Points:

1. Introduction:

·      Andy and Tom introduce Greg Bounds, who works as a data architect for a national nonprofit and also consults on data projects.

2. Defining the Problem:

·      The discussion focuses on inheriting a complex data environment, termed a "dog's breakfast," with a mix of applications, systems, and databases.

·      Tom emphasizes the challenges of dealing with multiple cloud providers and on-premises systems.

3. Scoping the problem:

·      Start by talking to various stakeholders to understand the importance of different systems.

·      Auditing and documenting the systems should follow naturally from these conversations.

4. Managing Stakeholder Priorities:

·      Understand the challenge of balancing different departments' priorities and stresses the importance of understanding the entire data flow.

·      Show the benefits of changes through small, manageable projects.

5. Technical Approach:

·      Look for low-hanging fruit and opportunities to consolidate systems for quick wins.

·      Simplifying the data architecture can de-risk the environment and reduce points of failure.

6. Benefits of Consolidation:

·      Understand there may not be immediate cost savings, reducing the number of platforms simplifies governance and management.

·      It also minimizes the need for specialized knowledge across multiple systems.

7. Planning for the Long Term:

·      The importance of data governance and having a data team that is approachable and open to new solutions.

·      Ensuring the data team has the right skills and capacity is crucial to maintaining a streamlined environment.

8. Key Takeaways:

·      Communication with stakeholders and understanding their needs is essential.

·      Focus on data quality and transparency, even if it means creating "snitch reports" to highlight issues.

·      Look for quick wins to build momentum and show the value of changes.

·      Engage the C-suite to drive adoption and support across the organization.

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
Double Tap Productions Inc.
Acquired
Acquired
Ben Gilbert and David Rosenthal
TechStuff
TechStuff
iHeartPodcasts
Hard Fork
Hard Fork
The New York Times
Talkin' Shop
Talkin' Shop
Eclipse Automotive Technology
The Vergecast
The Vergecast
The Verge
Waveform: The MKBHD Podcast
Waveform: The MKBHD Podcast
Vox Media Podcast Network
Smashing Security
Smashing Security
Graham Cluley & Carole Theriault
RNIB Tech Talk
RNIB Tech Talk
RNIB Connect Radio
This Week in Retro
This Week in Retro
Neil from RMCretro - The Cave, Chris from 005 AGIMA and Dave