How to save up to 50% on your ELT/ETL total cost of ownership (TCO)

Published Jan 22 2021 08:48 AM 1,486 Views

The need for faster data quality

Data validation, data transformation and de-identification can be complex and time-consuming. As data volumes grow, new downstream use cases and applications emerge, and expectations of timely delivery of high-quality data increase the importance of fast and reliable data transformation, validation, de-duplication and error correction.

 

How the City of Spokane improved data quality while lowering costs

To abstract their entire ETL process and achieve consistent data through data quality and master data management services, the City of Spokane leveraged DQLabs and Azure Databricks. They merged a variety of data sources, removed duplicate data and curated the data in Azure Data Lake Storage (ADLS).

 

“Transparency and accountability are high priorities for the City of Spokane,” said Eric Finch, Chief Innovation and Technology Officer, City of Spokane. “DQLabs and Azure Databricks enable us to deliver a consistent source of cleansed data to address concerns for high-risk populations and to improve public safety and community planning.”

 

City of Spokane data architecture.png

City of Spokane ETL/ELT process with DQLabs and Azure Databricks

 

How DQLabs leverages Azure Databricks to improve data quality

“DQLabs is an augmented data quality platform, helping organizations manage data smarter,” said Raj Joseph, CEO, DQLabs. “With over two decades of experience in data and data science solutions and products, what I find is that organizations struggle a lot in terms of consolidating data from different locations. Data is commonly stored in different forms and locations, such as PDFs, databases, and other file types scattered across a variety of locations such as on-premises systems, cloud APIs, and third-party systems.”

 

To help customers make sense of their data and answer even simple questions such as, “is it good?” or “is it bad?” are far more complicated than organizations ever anticipated. To solve these challenges, DQLabs built an augmented data quality platform. DQLabs helped the City of Spokane to create an automated cloud data architecture using Azure Databricks to process a wide variety of data formats, including JSON and relational databases. They first leveraged Azure Data Factory (ADF) with DQLabs’ built-in data integration tools to connect the various data sources and orchestrate the data ingestion at different velocities, for both full and incremental updates.

 

DQLabs uses Azure Databricks to process and de-identify both streaming and batch data in real time for data quality profiling. This data is then staged and curated for machine learning models PySpark MLlib.

 

Learn more and get started

Continue reading how the City of Spokane improved data quality while lowering their TCO using DQLabs. Then get hands on with Azure Databricks by attending a Quickstart Lab.

%3CLINGO-SUB%20id%3D%22lingo-sub-2087473%22%20slang%3D%22en-US%22%3EHow%20to%20save%20up%20to%2050%25%20on%20your%20ELT%2FETL%20total%20cost%20of%20ownership%20(TCO)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2087473%22%20slang%3D%22en-US%22%3E%3CH2%20id%3D%22toc-hId--549990279%22%20id%3D%22toc-hId--549990279%22%3E%3CFONT%20size%3D%224%22%3EThe%20need%20for%20faster%20data%20quality%3C%2FFONT%3E%3C%2FH2%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdbricks.co%2F3p8AqJH%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EData%20validation%2C%20data%20transformation%20and%20de-identification%3C%2FA%3E%20can%20be%20complex%20and%20time-consuming.%20As%20data%20volumes%20grow%2C%20new%20downstream%20use%20cases%20and%20applications%20emerge%2C%20and%20expectations%20of%20timely%20delivery%20of%20high-quality%20data%20increase%20the%20importance%20of%20fast%20and%20reliable%20data%20transformation%2C%20validation%2C%20de-duplication%20and%20error%20correction.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-1937522554%22%20id%3D%22toc-hId-1937522554%22%3E%3CFONT%20size%3D%224%22%3EHow%20the%20City%20of%20Spokane%20improved%20data%20quality%20while%20lowering%20costs%3C%2FFONT%3E%3C%2FH2%3E%0A%3CP%3ETo%20abstract%20their%20entire%20ETL%20process%20and%20achieve%20consistent%20data%20through%20data%20quality%20and%20master%20data%20management%20services%2C%20the%20%3CA%20href%3D%22https%3A%2F%2Fdbricks.co%2F3c1notJ%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3ECity%20of%20Spokane%3C%2FA%3E%20leveraged%20%3CA%20href%3D%22https%3A%2F%2Fdbricks.co%2F3sLuzvT%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EDQLabs%3C%2FA%3E%20and%20%3CA%20href%3D%22https%3A%2F%2Fdbricks.co%2F3iAVrdi%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EAzure%20Databricks%3C%2FA%3E.%20They%20merged%20a%20variety%20of%20data%20sources%2C%20removed%20duplicate%20data%20and%20curated%20the%20data%20in%20Azure%20Data%20Lake%20Storage%20(ADLS).%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%E2%80%9CTransparency%20and%20accountability%20are%20high%20priorities%20for%20the%20City%20of%20Spokane%2C%E2%80%9D%20said%20Eric%20Finch%2C%20Chief%20Innovation%20and%20Technology%20Officer%2C%20City%20of%20Spokane.%20%E2%80%9CDQLabs%20and%20Azure%20Databricks%20enable%20us%20to%20deliver%20a%20consistent%20source%20of%20cleansed%20data%20to%20address%20concerns%20for%20high-risk%20populations%20and%20to%20improve%20public%20safety%20and%20community%20planning.%E2%80%9D%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22City%20of%20Spokane%20data%20architecture.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F248556i8D570890C2744F65%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22City%20of%20Spokane%20data%20architecture.png%22%20alt%3D%22City%20of%20Spokane%20data%20architecture.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22lia-align-center%22%3E%3CEM%3E%20City%20of%20Spokane%20ETL%2FELT%20process%20with%20DQLabs%20and%20Azure%20Databricks%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-130068091%22%20id%3D%22toc-hId-130068091%22%3E%3CFONT%20size%3D%224%22%3EHow%20DQLabs%20leverages%20Azure%20Databricks%20to%20improve%20data%20quality%3C%2FFONT%3E%3C%2FH2%3E%0A%3CP%3E%E2%80%9CDQLabs%20is%20an%20augmented%20data%20quality%20platform%2C%20helping%20organizations%20manage%20data%20smarter%2C%E2%80%9D%20said%20Raj%20Joseph%2C%20CEO%2C%20DQLabs.%20%E2%80%9CWith%20over%20two%20decades%20of%20experience%20in%20data%20and%20data%20science%20solutions%20and%20products%2C%20what%20I%20find%20is%20that%20organizations%20struggle%20a%20lot%20in%20terms%20of%20consolidating%20data%20from%20different%20locations.%20Data%20is%20commonly%20stored%20in%20different%20forms%20and%20locations%2C%20such%20as%20PDFs%2C%20databases%2C%20and%20other%20file%20types%20scattered%20across%20a%20variety%20of%20locations%20such%20as%20on-premises%20systems%2C%20cloud%20APIs%2C%20and%20third-party%20systems.%E2%80%9D%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20help%20customers%20make%20sense%20of%20their%20data%20and%20answer%20even%20simple%20questions%20such%20as%2C%20%E2%80%9Cis%20it%20good%3F%E2%80%9D%20or%20%E2%80%9Cis%20it%20bad%3F%E2%80%9D%20are%20far%20more%20complicated%20than%20organizations%20ever%20anticipated.%20To%20solve%20these%20challenges%2C%20DQLabs%20built%20an%20augmented%20data%20quality%20platform.%20%3CA%20href%3D%22https%3A%2F%2Fdbricks.co%2F3p8AqJH%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EDQLabs%20helped%20the%20City%20of%20Spokane%3C%2FA%3E%20to%20create%20an%20automated%20cloud%20data%20architecture%20using%20Azure%20Databricks%20to%20process%20a%20wide%20variety%20of%20data%20formats%2C%20including%20JSON%20and%20relational%20databases.%20They%20first%20leveraged%20Azure%20Data%20Factory%20(ADF)%20with%20DQLabs%E2%80%99%20built-in%20data%20integration%20tools%20to%20connect%20the%20various%20data%20sources%20and%20orchestrate%20the%20data%20ingestion%20at%20different%20velocities%2C%20for%20both%20full%20and%20incremental%20updates.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDQLabs%20uses%20Azure%20Databricks%20to%20process%20and%20de-identify%20both%20streaming%20and%20batch%20data%20in%20real%20time%20for%20data%20quality%20profiling.%20This%20data%20is%20then%20staged%20and%20curated%20for%20machine%20learning%20models%20PySpark%20MLlib.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--1677386372%22%20id%3D%22toc-hId--1677386372%22%3E%3CFONT%20size%3D%224%22%3ELearn%20more%20and%20get%20started%3C%2FFONT%3E%3C%2FH2%3E%0A%3CP%20data-unlink%3D%22true%22%3EContinue%20reading%20how%20the%20City%20of%20Spokane%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdbricks.co%2F3p8AqJH%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Eimproved%20data%20quality%20while%20lowering%20their%20TCO%3C%2FA%3E%20using%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdbricks.co%2F3sLuzvT%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EDQLabs%3C%2FA%3E.%20Then%20get%20hands%20on%20with%20%3CA%20href%3D%22https%3A%2F%2Fdbricks.co%2F3qJTVbE%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EAzure%20Databricks%3C%2FA%3E%26nbsp%3Bby%20attending%20a%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdbricks.co%2F39ZvPDj%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EQuickstart%20Lab%3C%2FA%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2087473%22%20slang%3D%22en-US%22%3E%3CP%3ELearn%20how%20the%20City%20of%20Spokane%20reduced%20their%20ELT%2FETL%20total%20cost%20of%20ownership%20(TCO)%20by%2050%25%20with%20%3CA%20href%3D%22https%3A%2F%2Fdbricks.co%2F3sLuzvT%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EDQLabs%3C%2FA%3E%20and%20%3CA%20href%3D%22https%3A%2F%2Fdbricks.co%2F3iAVrdi%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EAzure%20Databricks%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2087473%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Databricks%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDelta%20Lake%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Jan 22 2021 08:52 AM