Services
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.
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.
Verticals
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
Real move on Data Lake using Rest API on ADF
There are many times where I’ve needed to move a file using Azure’s Data Factory and found it weird that the only native option provided is to copy the file, then delete it. Many reading know that disk level renames…
Recreating a Power BI GIT Repos in Azure DevOps
In a previous blog, I showed how to shrink a GIT repos using git commands and the opensource bfg-cleaner to remove history of large PBIX files.https://prodata.ie/2021/10/23/shrinking-azure-repos-bloat-due-to-powerbi/ Sometimes the patient is just to sick and its too messy to clean-up, so…
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…
SqlDW / Synapse – TABLE Variable Compatibility
Azure Synapse SQL does not support the the use of TABLE variable. Therefore a workaround is to use Temporary Tables in SqlDW. If we run the below statement in Synapse SQL then it willa throw syntax error as below: Alternative…
Enabling Managed Identity Authentication on Azure Functions in Data Factory
This blog shows you how to enable Managed Identity on an Azure Function call from ADF, this can help secure the Function by adding a second authentication method on top of the API Key. Enabling these options enforces https on…
Import Json using SQL Dedicated Pool in Azure Synapse Analytics (SQLDW)
This blog shows how to easily Extract Json and XML objects and Arrays into SQDW using COPY INTO SQLDW is a bit behind other vendors like snowflake when it comes to being able to query Json natively off a data…
Bob Duffy – User Group and Event Sessions for 2022
If you are running a SQL/Data User group or event I’m always happy to do a 50-60 minute virtual talk. Let me know bob@prodata.ie or @bob_duffy on twitter. 2022 Session Options 01. SqlPool Maintenance Fundamentals SQL Pools now support auto…
SQL Storage Fundamentals for Azure VMs
Thx to anyone looking at my session at #SsqlBits on SQL Storage fundamentals for Azure VMs. Here is a copy of my slide deck if you want to see any of the links or content.
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…
Azure SQL Performance Testing on ESv5 v DSv2
In a previous blog I talked about the new Esv5 Azure VM Types that looked very promising for SQL Server and data warehousing , perhaps unseating the older DSv2 that we had been recommending. https://prodata.ie/2021/11/03/the-new-king-vm-type-for-sql-has-arrived/ Now that we have upgraded…
Loading…
Something went wrong. Please refresh the page and/or try again.