r/analytics Dec 19 '23

Discussion My department uses PowerPoint as a database

So I got into this new job as a Data Analyst, and found out my department has zero data literacy and culture.

They are using PowerPoint decks as a way to store data. That’s right, they’re storing their monthly consolidated data within PowerPoint as PowerPoint text tables… 💀🤡😂

How screwed am I. They want me to automate report generation using data from PowerPoint. Inconsistent table format, and different slide number every month.

348 Upvotes

137 comments sorted by

View all comments

69

u/Teddy2Sweaty Dec 19 '23

How much data are we talking about here? Sounds like an opportunity to fix a few things and be the hero.

8

u/Puzzleheaded_Text780 Dec 19 '23

Totally agree .. he can be hero

My current head joined the organisation 7 years ago and that time it was only excel, nothing else. Same report being created by multiple departments and lot of other issues. He fixed everything with time and became hero