Case Studies

Projects that drive impact

A selection of real projects we've built end-to-end for our clients.

Publishing · scientific health communication

Grupo Mayo

Integrated business dashboard

We replaced manual business tracking (Excel, scattered reports and direct ERP queries) with a Power BI dashboard connected in real time to Dynamics 365 Business Central: management, sales and finance see the group's performance and profitability per project with same-day data and no manual work.

No more Excelmanual reporting leaves the daily routine

Technologies

Power BIPower QueryBusiness CentralSharePointPower Automate

View project

02Custom Software

Security · drone detection

ASDT Corporation

Real-time threat detection and monitoring app

We rebuilt SendeScope, the Android app running in more than 500 ASDT portable detection units around the world: real-time drone detection and tracking over offline maps, in hostile terrain. Updating used to mean travelling unit by unit; new versions now reach the whole fleet remotely, with no third party involved.

+500portable detection units deployed worldwide

Technologies

AndroidNode.jsDockerKotlinWebSocket

View project

03Analytics & BI

Public sector · local government

Joves de Barcelona · Ajuntament de Barcelona

Tracking and social-impact analysis platform

We designed a Power BI BI platform for the youth information and guidance services network of Barcelona City Council. We converted manual reporting into an automated analytical ecosystem to measure the impact of its programs in real time.

+15 reportsInteractive in Power BI

Technologies

Power BIPower QueryPythonSharePoint

View project

04Custom Software

Fitness, sport and wellness

Hably

Social network: app and product ecosystem

We built HABLY end to end in a year: a Flutter mobile app (iOS and Android) with in-app payments, workout traceability, real-time messaging and social interaction at scale, plus our own backend, a web back office and ecosystem tools. It is now in testing with more than 100 users ahead of launch.

+100users in the testing phase ahead of launch

Technologies

FlutterNode.jsNext.jsMongoDBDocker

View project

05AI & Data

Third sector · social innovation and health

Sic4Change · Nut4Health

Data platform for the fight against malnutrition

We built Nut4Health's “Data Platform”: the analytics infrastructure that turns the records of thousands of cases across hundreds of health centres, in Spain and Mauritania, into information to act sooner. Full traceability of every case and a more effective operation to reduce the risk of acute child malnutrition and mortality.

Thousands of casesfollowed across hundreds of health centres

Technologies

Power BIPythonMySQLFlutter

View project

06Analytics & BI

Food distribution · cold chain

Grupo Pomona Iberia

Business Intelligence platform for sales and purchases

We unified the sales and purchases of the group's four companies, millions of euros in transactions every day, into a single BI platform: from Excel, SharePoint and scattered ERPs to a common Data Warehouse that group management checks every morning with the previous day's data, with no manual consolidation.

4 companiesconsolidated in a single sales and purchases model

Technologies

Power BIPythonMySQLFlutter

View project

07Custom Software

Leisure and events · open-air afternoon parties and live music

HANGAR

Website, QR tickets and access control at the door

We built HANGAR's complete event system: brand website, QR ticket sales with online payment, ticket emails with a queue and retries, email campaigns with sales attribution, an admin panel and a door app that validates every ticket in real time against the database, with no duplicates even with several door staff.

3 eventspublished with tickets and access control

Technologies

Node.jsExpressSQLiteNodemailerQRSharp+3

View project

Let's talk about your next project.

Book a free 60-minute strategy session. We'll analyze your business and show you exactly where AI, data, and automation can drive real results.

Book Your Free Session

Or email us at info@laketab.com