Extract data from all PDFs using Power Query [Excel and Power BI]
Essential Excel [R$ 67.00 with lifetime access] 👉 https://url.joviano.com/2h3on
Data Automation and Processing Training [complete package] 👉 https://url.joviano.com/29jsh
____
In this class, you'll become a ninja in the art of extracting data from PDFs without breaking a sweat. I'll show you how Power Query can be your partner when pulling information directly from PDFs into Excel (and Power BI), turning this task into a breeze.
Besides teaching you to dance to the music of the data, I'll guide you through automating this process. Just imagine: you there, relaxed, while Power Query works for you, combining PDF data as if by magic.
SPOILER 👉 You'll even learn a custom function to recognize tables today!
So, check out the video, give it a like if you enjoyed the content, and subscribe to the channel so you don't miss the next tips that will make you stand out from the crowd!
Oh, this video complements this article on my BLOG 👉 https://url.joviano.com/tfuj3
The link to the complementary video is in this article.
_
📣 VISIT OUR PAGE TO LEARN MORE 👇
👩🎓 POWER QUERY 2.0 TRAINING [Package with over 40 COURSES]
🆓 Free weekly class [with certificate]
🆓 Free course on Power Query, Python, Webscraping and more!
✅ Content curation [books]
💾 Supporting material [if this class contains it]
👉 https://url.joviano.com/5vyni
_
🎬 SCRIPT
00:00 Presentation
00:10 Introduction
00:24 What is a PDF?
01:36 Transforming a photo [print screen] of a PDF table into an Excel table
03:48 A way to solve the problem of data non-recognition
06:00 Using Power Query to import and clean tables from a PDF
09:50 How to transform all PDF files in a folder with a custom function in Power Query [M language]
15:30 Creating a custom function in Power Query
17:36 Unstructured PDF to clean table in Excel and Power BI [example: TIPI table, different invoices...]
19:46 How to merge multiple PDFs with Power Query [ADVANCED MODE | Example: Government DARF]
20:40 Final Considerations