One Click to Bring Your Financial Data into SQL Database
Вставка
- Опубліковано 8 вер 2024
- 💡 SQL Databases are powerful for data analysis, and in the world of Finance, we handle massive amounts of data, often scattered across various platforms. The time wasted searching for data and switching to ERP systems can be frustrating. Join me as I reveal how I revolutionized data storage and management in my department by replacing traditional Excel spreadsheets with a high-performance SQLite database, all thanks to Python programming!
📚 RESOURCES IN THIS VIDEO:
Data and DB:
github.com/joe...
Python:
www.python.org...
Visual Studio Code:
code.visualstu...
Anaconda:
www.anaconda.c...
SQLiteStudio:
github.com/paw...
SQLite ODBC Driver (Admin rights needed for installation):
www.ch-werner.d...
MY FAVOURITE TOOLS & GEAR:
📝 Notion - How I Manage My Day - affiliate.noti...
💻 My Personal Laptop - Legion 5 Pro - amzn.to/3nZrn1I
✈️ My Travel Companion - Macbook Air M1 - amzn.to/43jLLuE
📷 My Camera Gear - Sony ZV-E10 - amzn.to/40T7uIj
MY OTHER SOCIALS:
🌍 My links: linktr.ee/joel...
🙎🏻♂️ WHO AM I:
I'm Joel, a Regional Finance Controller working in Singapore. I make videos about technology, automation, and productivity.
📧 GET IN TOUCH:
I would love to hear from you if you'd like to talk. Email me directly at joelting92@gmail.com would be the quickest way to get a response. I will try my best to reply to your email as soon as possible.
P.S. Just a heads up, I receive a kickback from some of the links in this description as they are affiliate links
Hi Joel, I admire your expertise in automation. Would you consider creating content on automating sap tree?
Hi there. When you mentioned SAP tree automation, do you mean extracting information from GUI tree elements? like the BOM?
@@JoelTing Looking for guidance on automating document flow display in VF02 SAP transaction using GUI tree.
Is there a way to input new data into excel and then have some kind of submit button to submit it to the table?
@@jaredgarbo3679 hi Jared. Do you mean to submit planning data into BW table using Python?
You can use power query in excel/pbi
Thank you for your input! To clarify, I view SQLite not as a replacement for Power Query, but rather as an alternative for Excel spreadsheet when it comes to data storage. Power Query in Excel and Power BI remains a crucial part of my data processing workflow. SQLite serves more as a robust storage solution, complementing rather than replacing the data manipulation capabilities of Power Query.
Hello Joel. Great insight. Thanks for share. Same way can be done in PBI instead of Excell?
Hi there. Yes, it is the same in Power BI and Excel. You can use a similar approach to replace your data source in PBI if they all come from the same source.
Using what? Where can I watch your videos for sap data extraction?
May I clarify, what was your question?
Hi Joel
I am missing your good videos!
When are you going to show us something cool again?
Thank you
Klaus
Hi Klaus, sry for keeping you waiting, but things have been quite busy at my end recently. I will try to come out with something asap. Any specific topic that you would be interested in?
@@JoelTing Hi Joel, thank you for your response. Have you ever worked with GUIXT on modifying SAP-screens? This is actually very promising, but I only started looking into it. I don't know how far one can get with only the free version, but maybe you have experience here?
@@user-kq2gd1hj9y Nope. I have not work with GUIXT before. I'm probably not the best person to advise on this topic.
@@JoelTing Understood. No problem. I will just look forward to the topic you will bring up. Thanks.
Joel, SAP GUI Scripting is available in VBA nowadays or it change the name? Since I go to tools references and it doesn t appear
Hi there. Usually it's not in Tools, References. You need to browse and look for sapfewse.ocx in your SAP installation folder.