Data Warehousing
MarginPoint Data Warehouse is a Data as a Service (DaaS) product that offers a customer or distributor a dedicated Database in the cloud.
The Data Warehouse includes the most important and relative database entities and their relationships required for external reporting and analytics.
The Data Warehouse is offered as a normalized SQL database with a pre-defined schema that is updated on a regular basis and can be used by external applications.
MarginPoint Data Warehousing is a Data as a Service Product that offers a customer or distributor the ability to combine inventory data with your business data from other systems to realize spend optimization & true analysis of cross system data. Data Warehousing is the ultimate solution that ties your systems together.
MarginPoint Data Warehouse Advantages
- A dedicated normalized SQL database for each customer/distributor with a pre-defined and documented SQL Schema.
- Includes current and historical data from the day the customer was onboarded – No limitation on the number records to pull into the reports.
- Includes data for each company, its subsidiaries, and suppliers.
- Includes each company’s master and transactional data as well as users and their usage information.
- The database is refreshed regularly based on pre-defined frequency.
- MarginPoint Data Warehouse is a Data as a Service (DaaS) product that offers a customer or distributor a dedicated Database in the cloud.
- The database is refreshed regularly based on pre-defined frequency.
- Hosted on Microsoft Azure platform with highest security standards.
- Managed and maintained by MarginPoint DevOps team.
- Eliminates the need to run and export data from multiple MarginPoint reports.
- Eliminates the need to import static data into any external SQL databases.
- Accessible by multiple external BI and reporting tools (PowerBI, etc.).
- Designed for direct queries to access multiple tables and data sources for easy reporting.
- Distributors can access multiple company/customer databases across their supply chain for analytics.
- Distributors can track sales and transactions on specific items through the supply chain and across multiple company customers.
- Connection to the Data Warehouse can be on-demand or persistent.
- Optional custom connectors development and integration services available by MarginPoint.