Skip to content
2.0SOFTWARE DEVELOPMENT · INTEGRATION · DATASOFTWARE · INTEGRATION · DATATODAY · TOMORROW · FOREVER

Software engineering for companies that think long term.

We design, build and integrate systems that solve today, scale tomorrow and last forever.

WE WORK WITH
  • Python
  • SQL Server
  • Power BI
  • TypeScript
  • Next.js
  • PostgreSQL
  • Supabase
  • Applied AI
data-ecosystem / architecture viewREFERENCE DIAGRAM
CONNECTIONIntegrates with the systems you already use
CONTROLEvery run is logged
DECISIONInformation ready to act on
REFERENCE DIAGRAM
2.1224 SYSTEM

Today, tomorrow and forever: how we design every solution.

224 reads two · two · four: today, tomorrow, forever. It is not a slogan: it is how we make every engineering decision.

2TODAY
NOW

Solve

We deliver value from the first stage: clear scope, business priorities and results you can use from day one.

  • 01Process and data assessment
  • 02Phased deliveries
  • 03Prototype validated before building
PHASED DELIVERIES
2TOMORROW
NEXT

Scale

We design architectures, data and integrations that support growth without rebuilding everything.

  • 01Documented data models and APIs
  • 02Integration with your current systems
  • 03Solutions that grow in modules
ARCHITECTURE · DATA · APIs
4FOREVER
ALWAYS

Last

Maintainable code, documentation, data security and support after delivery.

  • 01Code and documentation handed over
  • 02Personal data under Colombia's Law 1581 of 2012
  • 03Support and continuous improvement
SUPPORT · DOCUMENTATION · LAW 1581
2.2CAPABILITIES

What we build for your company.

Five engineering capabilities, one way of working. Pick one to see what it includes and how it looks.

Not sure which one you need? Tell us about your case
03 / 05 · DATA AND BUSINESS INTELLIGENCE

Data and business intelligence

We turn scattered data into reliable KPIs: we model the information, consolidate it and bring it into dashboards that update themselves.

DELIVERABLES
  • SQL data modeling
  • ETL processes
  • Power BI dashboards
  • Custom Power BI visuals
FOR COMPANIESConsolidate several companies or locations into one view.
FOR FOUNDERSMeasure what grows your business from day one.
  • SQL Server
  • Power BI
  • DAX
  • Python
ILLUSTRATIVE INTERFACE · SAMPLE DATA
Let's talk about data and business intelligence

We turn scattered data into reliable KPIs: we model the information, consolidate it and bring it into dashboards that update themselves.

DELIVERABLES
  • SQL data modeling
  • ETL processes
  • Power BI dashboards
  • Custom Power BI visuals
FOR COMPANIESConsolidate several companies or locations into one view.
FOR FOUNDERSMeasure what grows your business from day one.
  • SQL Server
  • Power BI
  • DAX
  • Python
ILLUSTRATIVE INTERFACE · SAMPLE DATA
Let's talk about data and business intelligence

2.3CASE STUDIES

Case studies that show how we work.

Real projects. When confidentiality requires it, we present the client by industry.

  • FEATURED CASE
  • RETAIL · ANONYMIZED CLIENT
  • IN PRODUCTION

A data ecosystem for retail

From accounting systems to management dashboards: an automated, auditable data engineering flow, consolidated across several companies in the same group.

01 · CONTEXT

A retail group with several companies records its sales and credit notes in a cloud accounting system.

02 · CHALLENGE

Information did not arrive in time to be analyzed, and the existing sync stopped as the number of records grew.

03 · SOLUTION

API integration with date-based paging, Python ETL processes with safety checks, SQL Server with consolidated views and Power BI dashboards.

04 · DATA FLOW ARCHITECTURE
  1. 01 · SOURCE
    Accounting API · invoices · credit notes
  2. 02 · EXTRACTION
    Extraction · Python · date-based paging
    Refresh window: reloads by range, keeps history
  3. 03 · CONTROL
    Validation · safety checks
    Control table: every run logged
  4. 04 · STORAGE
    SQL Server · tables per company · views
    Consolidated views: one source for several companies
  5. 05 · ANALYSIS
    Power BI · management dashboards
05 · WHAT THE TEAM SEES
06 · RESULTS
  • The sync no longer stops as the number of records grows.
  • Every run is logged and auditable.
  • Consolidated reports for several companies in Power BI.
  • Python
  • REST API
  • SQL Server
  • Power BI
  • DAX
MORE CASE STUDIES
02
RETAIL · DELIVERED

Business intelligence and management dashboards

Sales and inventory dashboards and custom Power BI visuals built in TypeScript, with a visual theme aligned with the client’s brand.

  • Power BI
  • DAX
  • TypeScript
03
MULTI-BRAND RETAIL · IN PROGRESS

Management apps and business software

An omnichannel loyalty app: points for purchases in store, web and app, passwordless sign-in and a CRM-style dashboard for the team to review activity and launch offers.

  • Mobile app
  • Web dashboard
  • Code sign-in
04
224 · IN PRODUCTION

Web platforms and integrations

This site: bilingual, generated as static pages, with forms connected to automatic email for the team and a confirmation for the customer.

  • Next.js
  • TypeScript
  • Netlify
  • SMTP email
224 PRODUCT

Digital loyalty cards

Stamp cards with each business’s brand, saved in the phone Wallet. Includes a customer view, a cashier view and an owner dashboard.

See the product and its demo
Café Tostón is a sample business.
2.4ARCHITECTURE AND TECHNOLOGY

Clear layers, pieces that connect.

Every solution is organized in four layers. That makes it easier to understand, maintain and grow.

LAYER 01InterfaceWhat your customers and team use
  • Next.js
  • React
  • React Native
  • Power BI
LAYER 02Logic and APIsBusiness rules and integrations
  • TypeScript
  • Python
  • REST APIs
  • Automations
LAYER 03DataReliable, consolidated information
  • SQL Server
  • PostgreSQL
  • Supabase
  • ETL
LAYER 04InfrastructureWhere it lives and how it is protected
  • Netlify
  • Cloud
  • Transactional email
  • Security and access

ENGINEERING PRINCIPLES

  1. 01
    Security and data protectionRole-based access and personal data handled under Colombia's Law 1581 of 2012.
  2. 02
    Documented code, handed overWe document how each piece works so it can be maintained over time.
  3. 03
    Integrations with logging and checksEvery process leaves a trail to catch and fix failures early.
  4. 04
    Measured performance and accessibilityWe check speed and accessibility before every delivery.
2.5HOW WE WORK

From idea to solution, with no surprises.

Four stages with clear deliverables. You always know where your project stands.

  1. 01

    Discovery

    We meet with you and learn your processes, your data and what you want to achieve.

    YOU GETProcess and goals assessment
  2. 02

    Proposal and quote

    We define scope, timeline and investment in a clear proposal with no fine print.

    YOU GETScope, timeline and investment documentClient access →
  3. 03

    Design and validation

    You see how the solution will work before we build it, and we refine it with you.

    YOU GETMockups and clickable prototype
  4. 04

    Build, delivery and support

    We build in stages, deliver with documentation and keep supporting you afterwards.

    YOU GETWorking solution, documentation and support
2.6224 · ABOUT US

Engineering judgment behind every solution.

224 designs, builds and integrates software, systems and data. It is led by a systems engineer with business intelligence experience in retail: data integration, ETL processes, databases and management dashboards.

That experience in real operations is what we bring to every project: understand the business first and build solutions that can be maintained over time.

MISSION

To design and build custom technology solutions that solve real needs, with quality, closeness and a long-term view.

VISION

To be a reference in software development in Colombia and the region, supporting our clients today, tomorrow and forever.

224 AT A GLANCE224
NAME
224 · Digital solutions
LEADERSHIP
Systems engineer · data and business intelligence
FOCUS
Custom software · integration · data · applied AI
SERVICE
Colombia · Spanish and English
PERSONAL DATA
Colombia's Law 1581 of 2012
2.7FAQ

What we usually get asked.

If your question is not here, write to us and we will answer it in our first conversation.

Ask another question →
How much does a project cost?

It depends on the scope. After a meeting we send you a detailed quote you can review online.

How long does it take?

Every quote includes a phased timeline based on what you need.

Do you work with entrepreneurs or only with companies?

Both. We adapt the solution to where your business is today and grow it with you.

Can you integrate with the systems we already use?

Yes, when the system offers an API or lets you export its data. We review it during discovery.

How do you handle security and personal data?

We apply role-based access and handle personal data under Colombia's Law 1581 of 2012.

Where is the solution hosted?

It depends on the project: in the cloud of your choice or on infrastructure we manage, such as Netlify or Supabase.

What happens after delivery?

We stay with you, providing support and improvements so the solution keeps running.

How do I check my quote?

In Client access, with your tax ID or national ID and the personal access code we send to your corporate email.

2.8CONTACT

Have a process to improve or an idea to build?

Tell us what you need. We will reply with concrete questions and, if it makes sense, schedule a discovery session.

CLIENT ACCESS

Already have a proposal?

Online access will be available soon. In the meantime, we send your proposal by email.

PORTAL UNDER CONSTRUCTION