Data Services

Data Excavators

The data that enterprises generate and collect has considerable value. However, like gold, raw data doesn't yield its value without considerable refinement.

That's where FdR can help. We are experts in extracting, loading and transforming source data into curated analytic environments such as the Kimball-style data warehouse. Today, this is achieved via the medallion architecture using lakehouses and warehouses. An advantage of this approach is that the silver layer, in addition to being a staging layer for the curated model, is also the springboard for ML and data science.

Needless to say, while the refinement of data is vitally important, data consumers in the organisation need to access the data through fast and well-structured semantic models which are visualised via applications such as PowerBI, Python, or good old Excel!

Additionally, other tools (e.g. Spark, Apache MLlib, Neo4J, SAS - or even SQL) can be pointed to the data for ad-hoc analyses and model training. This is the domain of exploratory queries, statistical analyses and machine learning which are of huge importance at the present time.

Technologies

Contemporary tools enable easy connection to a wide variety of data sources. These can be obscure (for example, InterSystems Caché or even Borland Paradox!) but are often commonplace (say, PostgreSQL and Oracle). FdR are also extremely comfortable working with sets in JSON and XML formats.

There are many tools for manipulating data. At FdR, we have experience of Microsoft, Fabric, Snowflake, Azure and good old Microsoft SQL Server. These are great stacks for extracting and warehousing data. Fabric in particular raises the Microsoft offering to a whole new level!

Outcomes

It's true. We love data. Not simply as a technical challenge to be overcome, but for the business outcomes it can deliver. We consider the success criteria for any project is the point when the data is delivering tangible and real outcomes: superior decision-making, operational efficiencies, increased sales and reduced churn - to name but a few.

Contact us today to see what riches we can help you to unearth.