How an Excel Report Got Me Into Programming

说明与用途

将ERP数据自动化导入Excel报告，节省每日两小时手工工作，需学习SQL和数据库结构。

问题

A manager spent about two hours a day transferring ERP data into Excel, a manual process that needed automation.

结果

Automated the Excel report, saving two hours of daily manual work and enabling data-driven decision making.

工作流

• Requested ERP vendor quote for automation – price too high
• Asked to connect ERP database to Excel personally
• Learned SQL querying and database structure
• Identified relevant tables and relationships
• Determined which records belong in the report
• Implemented data filtering to avoid pulling all data
• Integrated query into Excel
• Tested and validated the automated report

证据

At my first job, I watched my manager spend about two hours a day transferring information from our ERP into Excel.

来源

I had absolutely no idea how to do it. I just believed it was possible.

来源

First, I had to learn how to query a database. Then I discovered how many tables could sit behind a single expense screen.

来源

Then came filtering the data before bringing it into Excel. Pulling everything would have made the spreadsheet unusable.

来源

It took almost a year to get it working. The spreadsheet could finally read from the source, and those two hours of daily manual work were gone.

来源