Did you ever export ERP data to CSV and imported into Excel ? Spreadsheets are great, but one-time exports are not a repeatable solution. Instead, you need a real-time interactive data layer on top of Exact Online to explore, combine and share data.
Whether you are in Revenue Ops, Marketing Ops, Finance Ops or any other “Ops” team, you need instant access to data to follow up on processes, to do ad hoc analysis, to calculate metrics and to build internal apps to share data with stakeholders.
Also Product Managers, Marketing Managers, Sales Managers, Finance Managers need to be data driven to thrive.
Peliqan is the only platform that helps Business Ops Teams to do all of the above in a self-service manner without the need for direct ERP access.
No need to call the data engineering team, no complex ETL data pipelines !
Connect to one or multiple Exact Online instances with a few clicks and start exploring your data. You only need to allow “read only” access and still your business users will be able to edit the data in their own private virtual copy.
Allow teams and business users to explore and edit Exact Online data in a rich spreadsheet editor.
Users can work with virtual copies and add their own rows and columns with notes, new data and apply formulas similar to Excel or Google Sheets.
Peliqan allows you to easily combine data from Exact Online with other sources, using the visual “Join editor”.
Power users can write SQL queries to combine data. Need to combine data without a joined key ? No problem, Peliqan’s Magical Joins allow you to apply fuzzy matching.
Combine data from Exact Online with data from:
Turn your data into charts and dashboards with a few clicks. Share dashboards with others, publish them and embed them into webpages or documents.
Developers can implement a wide range of use cases using low-code Python scripts.
Go beyond analytics, make your Exact Online data interactive, perform writebacks and apply machine learning with just a few lines of code.
Enjoy direct unified data access from your code to your Exact Online instances. Write, test, run all in one place.
Build custom reports with a low-code script, based on accounting data and distribute them as Excel files or PDF documents.
Use low-code Python to write updates into your accounting software, for example update sales orders based on eCommerce transactions.
Reconcile data, for example sales orders and transactions from payment gateways (Stripe, Paypal, Klarna etc). Next, visualize the results in Peliqan or your own BI tool.
Analyze your Exact Online data with SQL or in a spreadsheet.
Enable business users with controlled self-service data access.
Create views for “human in the loop” processes.
Build custom reports in HTML, PDF…
Build internal apps using low-code Python to make datasets interactive.
Replace complex user interfaces with a targeted UI for knowledge workers.
Implement Exact Online data migrations using SQL and low-code Python.
Peliqan is an all-in-one data stack on top of Exact Online.
Work with your Exact Online data in a spreadsheet that is always up-to-date.
Create charts and visualize your Exact Online data in dashboards.
Reconcile your accounting data, product data, customer data etc.
Apply machine learning models on your Exact Online data with low-code python.
Implement reverse ETL flows and writebacks to send data to Exact Online or any SaaS.
Get real-time access to your raw Exact Online data.
Get your Exact Online data in a data warehouse instantly, with a few clicks.
Use SQL on your raw Exact Online data to view, share and transform data.
No credit card needed