AI-powered
podcast player
Listen to all your favourite podcasts with AI-powered features
2min snip
Automating Excel: Demystifying VBA, Office Script, Power Query & Python - Mark Proctor | Ep.069
The Adam Shilton Podcast
Challenges of Connecting to ERP Systems for Data Extraction
Connecting directly to ERP systems for data extraction presents challenges due to the complexity of finance systems. Finance systems are primarily designed for efficient data storage rather than easy reporting. For instance, accessing specific data like 'good received, not invoiced' from ERP systems requires expertise to navigate through years of transactional data. Even if data can be extracted using tools like Power Query, the intricate database structure of ERP systems makes it complex to convert for practical use in Excel. Hence, sometimes it is more beneficial to work with system-generated outputs rather than attempting to restructure the database for direct data extraction.
00:00
Transcript
Episode notes
Get the Snipd
podcast app
Unlock the knowledge in podcasts with the podcast player of the future.
AI-powered
Discover
highlights
Listen to the best highlights from the podcasts you love and dive into the full episode
Save any
moment
Hear something you like? Tap your headphones to save it with AI-generated key takeaways
Share
& Export
Send highlights to Twitter, WhatsApp or export them to Notion, Readwise & more
AI-powered
podcast player
Listen to all your favourite podcasts with AI-powered features
Discover
highlights
Listen to the best highlights from the podcasts you love and dive into the full episode