Data Quality is a constant need for organisations, especially those with extensive regulatory reporting responsibilities. For our client (a utilities provider in NSW) One51 was asked to develop a report to detect and report on current data quality exceptions. The report targeted Data Stewards, and those responsible for regulatory reporting. Additionally, any identified data quality…
Microsoft Fabric introduces Data Pipelines as a new addition to the Microsoft Data Factory family. This versatile tool combines a comprehensive range of activities designed to facilitate data movement, transformation, and orchestration, often requiring minimal or no coding. The fundamental building block, known as an “activity,” represents an executable task. Activities can be harnessed to…
For a long time, ETL has been the go-to workflow for data teams of all shapes and sizes. I was fortunate enough to start my analytics journey with a long-standing client of One51 Consulting, where I was exposed to an extremely rich ecosystem of data ingestion tools and orchestration techniques. The client’s ETL process involved…
It’s challenging and can be expensive to develop machine learning models, and thus, it is important to have solid foundations in place to enable teams to put those models to work and derive value from them. A Customer of One51 Consulting had the skills to create quality machine-learning models; however, their team worked in an…
At One51, we have been working with Fabric and delivering Proof of Concept (POC) Projects for our clients, as well as developing our Fabric Framework. Microsoft Fabric adds many new content items to the Power BI (now Fabric) ecosystem, which is creating fantastic opportunities for data teams, without the need to spin up additional Azure…
Azure Data Factory (ADF) is one of the key components of the Microsoft Data platform, either as a standalone application or as part of Azure Synapse Analytics. In addition to ADF, Microsoft has been working on the Power BI Dataflows as another great tool for data load and transformation containing hundreds of out-of-box connections. …
One51 is delighted to announce the opening of its new office in Melbourne. This strategic expansion marks an important milestone in the company’s growth and demonstrates One51’s commitment to serving clients throughout Australia.
In our Tech Challenge #1, we walked through the steps required to import Excel data into an Azure SQL Database using Azure Data Factory. This Tech Challenge will explore how Azure Data Factory helps to extract data from an RSS Feed. RSS is a web feed that allows users and applications to access updates to…
Microsoft Excel has become an essential source of data in most organisations.
Azure Data Factory now supports processing Excel files natively, making this process simpler by removing the need to use intermediate CSV files.
We are pleased to announce that One51 Consulting is open for business. See our press release.