The problems we encountered and the solutions that we have found
Today marks an important milestone for both Express120 and our team at ELIS Co. The new Express120 platform is now live at express120.com.
Express120 is a startup courier company focused on fast and reliable deliveries, offering services ranging from 2-hour express delivery to standard 24-hour delivery options.
Continue reading “Express120 Goes Live: Building a Modern Courier Management Platform from the Ground Up”
Email delivery used to be simple.
Set up SMTP, send emails, done.
That’s no longer true.
We recently investigated a case where a client’s system was sending thousands of transactional emails daily – and some of them were silently failing. No clear errors, no obvious pattern. Just users saying: “I didn’t receive the email.”
What we found is a good example of how modern email delivery actually works today.
Continue reading “SPF, DKIM, DMARC in the Real World: Fixing Email Delivery Issues Across SendGrid, Microsoft, and Yahoo”
For many businesses, legacy systems are not just software – they are the backbone of daily operations.
But what happens when those systems stop working, and no one is left who understands how they were built?
Recently, we worked with a client in the architectural antiques and restoration industry facing exactly this situation.
Continue reading “When a Legacy System Reaches Its Limits: Rebuilding a FoxPro-Based Inventory Platform”
Sometimes the best proof of long-term software quality is when a client comes back after many years.
Recently we started working again with a long-term client in the structural inspection industry, for whom we originally built a custom online platform more than twenty years ago.
That original system, developed using Visual FoxPro, supported the company’s internal order management, scheduling, and inspection workflows for many years.
Like many businesses, the client eventually decided to move to a modern third-party platform in an attempt to simplify their operations.
However, after using the new system for some time, they realized something important.
Some of the most critical workflows from their original platform were missing.
Continue reading “From Visual FoxPro to React: Modernizing a Legacy Business Platform”Have you ever struggled with handling JSON data in SQL queries? If so, you’re not alone. In this post, we’ll explore a real-world scenario where we tackled this challenge in Snowflake, transforming complex JSON structures into structured, queryable data.
In one of our ETL projects, we process raw data ingested from a third-party REST API into a Snowflake database. Some parent-child relationships within this data are stored as JSON strings inside VARCHAR columns.
Here is a simplified example for the purposes of this article:
We are excited to share a few key tips for optimizing DAX queries that significantly improved the efficiency of our Azure Analysis Services (AAS) Tabular Model project.
Our project involves various financial measures that calculate key metrics such as LTM Sales, LTM EBITDA, and Net Debt. Each of these measures incorporates logic for FX conversions and period filtering. While individual measures performed well, combining many measures in a single dashboard negatively impacted performance. After analyzing our DAX expressions, we identified two major factors affecting execution time. Below, we outline how we optimized performance in each case.
Continue reading “Boosting DAX Performance: Practical Optimizations for Faster Queries”
Enhancing Division Assignment with Google Maps Integration
In our ongoing effort to improve user experience and operational efficiency, we recently integrated Google Maps for tennis roster management. This feature helps administrative users visualize roster locations and make smarter division assignments based on geographic data – saving time and reducing travel inefficiencies.
Continue reading “Optimizing Division Assignments with Google Maps Integration”
Welcome to the next piece of our series of articles describing the challenges we handled while working on the “Snowflake Warehouse and AAS Tabular Model” project.
We are happy to share our recent findings that helped us implement specific requirements in the tabular model project on which we have been working for a while.
Continue reading “Use DAX to Manipulate Relationships in Tabular Model Projects (Analysis Services)”
Welcome to the first installment of our promised series of articles detailing the challenges we encountered and conquered during our work on the “Snowflake Warehouse and AAS Cube” project.
Today, we’re excited to share how we tackled a particularly thorny issue while developing an AAS Cube project for one of our valued clients. Our task involved creating measures to extract financial data such as Sales and EBITDA. Given that reports are generated in specific currencies (e.g., USD), we needed to incorporate currency (FX) conversions within these measures. The parameters for these calculations varied depending on the particular company, with each company having its base currency code.
Continue reading “Mastering OLAP Cube Reporting: Solving Grand Total Calculations in Snowflake Warehouse and AAS Cube Projects”
We’ve embarked on yet another project recently, one that poses our biggest challenge to date.
We have a long-standing client for whom we developed a web-based portfolio management system over 20 years ago. Since then, we’ve continuously improved and expanded its functionality by incorporating new modules, ETL processes to import data from external sources, and various types of reports and exports.