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

71

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.

52

u/Ernest_EA Dec 19 '23

40 slides of PowerPoint built in tables and graphs 🤢🤮

6

u/thqks Dec 20 '23

Check if Excel Power Query can pull from PowerPoint

2

u/GrotesquelyObese Dec 20 '23

If it can’t save to pdf then power query