Ireland’s Azure Data Platform Experts


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:

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.

ERP Analytics

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
  • Salesforce
  • Agresso
  • Exchequer

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

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 
  • Hospitality 
  • Point of Sale 
  • Telco  
  • Banking  
  • Supply Chain 
  • Quality 
  • Manufacturing 
  • Services 
  • Printing 
  • Travel 
  • Media 
  • Marketing 
  • Government 
  • Military 
  • Financial Services  

Featured Posts

Bug – Synapse SqlPool Language and dates

We found this interesting bug on Dedicated SQL Pool when working with British style language. If you use Dynamic SQL to change the language, then selects on the date fail with a conversion error, but prints work. Weird… An example…

Meta data Automation at SqlBits 2022

The absolute key to getting agility and extensibility in a data warehouse project is a good meta data based automation framework and tools, regardless of whether you are using TSQL, Pool, Databricks and/or Python. If you are coming to SqlBits…

Selecting the right Azure VM for SQL

When looking for the right VM for SQL we need to look at a lot of factors, but mainly these four factors Throughput of VM (Cached and Uncached)Cores AvailableVM Memory GNCost per month (compute and SQL license) This can be…

Power BI- Data Connectivity Modes

Import Data This connection means that Power BI will cache the data meaning Pulling data from Data Source and into Power BI Desktop File. Advantages: Caching the data makes you take full advantage of Vertipaq Engine. Report Performance will be…


Something went wrong. Please refresh the page and/or try again.