Azure Data Engineering
Whether your data platform is in Azure, on premise or hybrid, Prodata has world class expertise in data engineering and associated disciplines such as data warehousing, ETL, ELT, analytics and business intelligence.
We implemented our first OLAP solution back in 1999 in SQL 7.0 and today work across the Microsoft data stack in Azure with:
- Synapse Pools (SQLDW)
- SQL Server
- SQL Analysis Services
- Azure SQL DB
- Synapse workspace & ADF
- Power BI
- Power Automate
- Hybrid On premise Gateways
- Powershell Automation
- Dot.Net bespoke Development
- XML and Json Messaging
- SQL Integration Services
- SQL Reporting Services
We bring decades of experience building enterprise platform solutions. More importantly as well as our experience we bring our solutions accelerator and PAGE framework to jump start your solution and avoid starting from scratch.
We provide analytics and / or data warehousing for your ERP platform.
Prodata have extensive experience in working with the following ERP and CRM systems
Prodata then take these integrations and using our semantic modelling and data warehousing experience transform your ERP data into an enriched, facilitated self-service, analytical platform
- SAP (Various)
- Infor M3
We have experience both adding analytics and reporting on top of ERP and integrating from EDW into ERP, both batch and realtime.
We specialise in providing a secure, rich, managed self service BI framework on top of complex ERP structures. Empowering thousands of users to explore data in a secure yet flexible and modern toolset such as PowerBI.
Power BI is Microsoft’s hugely successful reporting as a service platform. Prodata have led the rollout of this technology and its predecessors (Power View, Power Pivot and Power BI V1) in Ireland, helping enterprise customers with training, adoption and implementation.
Using our extensive modelling, DAX and M/Power Query experience we have rolled out paradigm changing Power BI self-service analytical solutions to thousands of users.
Our teams have decades of experience across hundreds of solutions. Specific Expertise includes:
- Finance (GL, AP, AR, risk modelling)
- Board Pack Automation
- Enterprise Scorecard modelling and analytics
- Wholesale/Retail Chain (500 to 10,000 stores)
- Enterprise SLA Monitoring and Penalty calculations
- Fuel and Forecourt
- Point of Sale
- Supply Chain
- Financial Services