
EKT Equities uses Open Source to Centralize Data and Reduces Reporting Time

ETL: Talend Open Studio
Sources: Zillow, PropertyShark, Reonomy, NYC ZoLa, and StreetEasy
Destination: MySQL
Front End: Custom Web Development (CSS, Java & HTML)
Data Stack:
With Pingahla's services and the use of Talend Open Studio, MySQL and custom Web Development, EKT Equities is able to streamlining the analytics pipeline for greater performance and insights during the changing times of commercial real estate.
Pipeline Performance Redefined
Pingahla Success Story: EKT Equities


EKT Equities is a commercial real estate investment market leader in the acquisition, development, and management of multifamily and commercial properties throughout the New York and New Jersey. EKT Equities provides real estate investment opportunities for its customers to consider as they seek to diversify and strengthen their investment portfolios.
When COVID-19 hit it directly impacted the commercial real estate industry. EKT Equities had to move quicker and faster to understand better its markets on where to invest more and wherethey should sell. EKT Equities had limited standardized analytics processes. Many key reports were static PDFs or Excels coming out of Microsoft Access once a week which took about one-two days to create and compile. The lack of analytical opportunity had a dwindling effect on RDS investments. Due to the changing times EKT Equities had to became more digital and David Khaloyan, Partner of EKT Equities saw an opportunity to make it more data-driven.
Data-Driven Transformation: EKT Equities Adapts to a Changing Market
Prior to COVID-19, EKT Equities didn’t need to rely on speed and relied on a lot of manual processes for data collection. In addition, for data consolidation, transformation and reporting many of these tasks were complete by using Microsoft Excel and Microsoft Access. Mr. Khaloyan and his partner realized they needed a more automated and near real-time solution that allowed them to better understanding itssurrounding markets and its real estate investments. EKT Equities knew they had to invest in a reliable solution that would not break the bank. EKT Equities along with Pingahla its strategic partner outlined the use of open-source technology to address it needs.
Building a Modern Open-Source Platform


In search of an open-source solution that would not break the bank for EKT Equities, but increase speed, visibility and remove tedious manual processes, Pingahla architected an open-source solution that helped addressed main of the pain points while creating a valuable and scalable solution. Utilizing some of the leading open-source solutions such as Talend and MySQL. Pingahla was able to set up automated ETL data pipelines using Talend’s Open Studio (TOS) to would be scheduled to run has well as having the flexibility to run on demand. Utilizing the power of TOS, EKT Equities needed a frontend business intelligence solution that allowed them to quickly from anywhere and on any type of device quickly gain digital insights on its properties and market. With the custom web development provided Pingahla, our internal portal allowed RDS to quickly visualize property investments and surrounding markets. With custom HTML reports and visualizations embedded into the user portal, users have a convenient way to access the insights they need to be truly data-driven.
Implementing the Open-Source Stack
Since introducing the open-source centralized analytics solution to the business, RDS seen about a 10-15% increase in its core property returns during the struggling times of COVID. It is also allowed them to quickly investment in undervalued properties. Mr. Khaloyan explains, “The emphasis on analytics is only growing at EKT Equities especially how COVID-19 has altered and changed the commercial real-estate business and we could have not been able to pivot so quickly if we did not partner with Pingahla.”
About Pingahla: Pingahla is a digital transformation solution provider that provides services to help organizations be data driven by providing digital insights. To learn more please visit www.pingahla.com for more information.
About Talend: Talend is a leader in cloud data integration and data integrity. They offer enterprise and open-source software that is used to transform business and companies with data. To learn more please visit www.talend.com for more information.
About MySQL: MySQL is a powerful open-source database platform. To learn more please visit www.mysql.com for more information.
About HTML, CSS & Java: First developed by Tim Berners-Lee in 1990, HTML is short for Hypertext Markup Language. HTML is used to create electronic documents (called web pages) that are displayed on the World Wide Web. CSS is the language for describing the presentation of Web pages, including colors, layout, and fonts. JavaScript is a client scripting language that is used for creating web pages.
About EKT Equities: EKT Equities is a commercial real estate investment market leader in the acquisition, development, and management of multifamily and commercial properties 2throughout the New York and New Jersey with over 20 million in assets under management. Please visit www.rdspny.com for more information.
High Performance Analytics
with less resources
.png)