What is ERP?
Most businesses, big and small, generally use an Enterprise Resource Planning (ERP) system. Some of its uses are:
- Keeping track of all transactions and ensuring that the accounting is correct ๐งพ
- Keeping track of customers, their orders and payments ๐ง
- Keeping track of inventory and order new products when they run low ๐
- ...and a lot more...
As you can see, its mostly about keeping track of everything the business needs to run. ๐ค๏ธ
Reporting
But notice, since they now got all this information stored in a single place, it's very easy to create PDF and Excel files with, for instance:
- Top 10 customers this month ๐
- Top 5 products by region (Bergen, Oslo, ...) ๐
- Top 3 products that have the highest return rate ๐
All of this information is incredibly useful when making decisions about what the business should be focusing on going forward. Presenting the data in this way is called Business Intelligence.
Integration
Remember that I said you could create PDF and Excel files? Well those are just two ways to present the data:
- PDF is excellent for presentations and human interpretation ๐
- Excel is great for management who usually knows how to use Excel and can process that data further on their own ๐งฎ
If you take that data and put it in a very structured format, i.e. JSON or XML, it's very easy for another system to read that information back out and understand the contents โ which would be very hard to do with a PDF file. ๐
What would I use it for?
Now, imagine we had a way to send files to the government and they somehow understood our XML files, then we could automatically report tax and employee information without having to spend an insane amount of time filling those out by hand. ๐ฅฑ
Well, this actually exists! Altinn Studio is a website dedicated to teach you how to communicate with Altinn automatically. ๐คฏ
Communicating with other systems like this is called Integration.
Exactly how you'd do something like this is beyond the scope of this introduction; the point I want to make is that having structured data in an ERP system comes with a lot of benefits, which you wouldn't necessarily get by only using Excel sheets.1
- ...yes, there's a lot of businesses that run purely on big, complex Excel sheets... ๐ฅต.โฉ