StratoData Logo
    Content/Case Study
    Case StudyData Warehouse & BI

    From Fragmented Spreadsheets to a Company-Wide Data Culture

    Alasans·International E-commerce·Cooperation since 2020·Ongoing

    >80%

    Growth during cooperation

    100+

    Data sources refreshed daily

    75K+

    SKUs with automated pricing

    25+

    Markets covered

    The Company

    A Growing Retailer That Needed Data to Match Its Ambitions

    Alasans is a large international e-commerce retailer, originally built around lighting and now steadily expanding into the broader home equipment market. With operations spanning more than 25 countries, the company's management team is deeply data-driven — they measure, question, and act on numbers every single day.

    As the business scaled, that data-driven instinct ran headlong into a fundamental problem: the tools holding their data together were no longer fit for purpose. Something had to change.

    The Challenge

    Outgrowing Boxed Reporting Tools

    By the time Alasans approached us in 2020, their previous reporting solution had become a bottleneck rather than an asset. Data from more than 25 markets sat scattered across a patchwork of platforms, updated infrequently and siloed by department. Decision-makers were working from yesterday's numbers — or last week's.

    "Management needed fresh, precise data from marketing platforms, web analytics, and their ERP — integrated and ready each morning."

    The goal was clear: build a system where every market, every channel, and every euro of marketing spend could be monitored and acted upon in near real time. Without that, sustainable growth across 25+ markets was simply not possible to manage profitably.

    The Solution

    Building a Unified Data Warehouse Across 25+ Markets

    We designed and built an Azure-based data warehouse that pulls together data from over 40 platforms — ERP, Google Analytics, accounting systems, and performance marketing channels — into a single, coherent source of truth.

    Power BI dashboards replaced the maze of manual Excel sheets, giving every department a live, self-updating view of the metrics that matter to them. We ran training sessions across teams to accelerate adoption and build internal confidence with the new toolset.

    But reporting was only the beginning. As the data warehouse matured, we layered on tailored automations: dynamic pricing that responds to market conditions, campaign feed enrichment, and automated PPC bidding across 25+ markets covering 75,000+ SKUs. These weren't off-the-shelf solutions — they were built specifically around how Alasans operates.

    Roadmap Highlights

    How We Got There

    1

    Built a scalable Azure data warehouse as the foundational layer

    2

    Connected ERP, marketing, finance, procurement, and logistics data from 40+ platforms

    3

    Replaced legacy Excel sheets with automated Power BI dashboards

    4

    Developed automated profit-based bidding, campaign automation, and dynamic pricing tailored to Alasans' markets

    5

    Increased data literacy and self-service capability across all departments

    Departments engaged

    E-commerceFinanceProcurementLogisticsPerformance MarketingExternal Vendors

    Cultural Shift

    From One Department to a Company-Wide Data Culture

    The project started with the e-commerce team — the most urgent need, and the clearest proof of concept. As results became visible, other teams joined in. Finance, procurement, logistics, and performance marketing all came on board as the warehouse expanded to serve their specific needs.

    Reporting stopped being something people checked occasionally and became the central reference point for every major decision. Automated processes gradually absorbed the repetitive manual work that had consumed hours each week. A data culture — not just a data tool — took root across the organization.

    Key Milestone

    The Shift from Reporting to Automation

    The defining turning point wasn't the dashboards — it was the moment data maturity enabled genuine automation. Automated profit-based bidding and dynamic pricing moved Alasans from reacting to data to having data act on their behalf, turning data infrastructure into a direct driver of measurable commercial results.

    Outcome

    Data-Driven Operations Powering Sustainable Growth

    Since 2020, Alasans has grown more than 80% — and the data infrastructure has both supported and enabled that growth. What began as a reporting project has evolved into a platform for intelligent automation, operating across 100+ connected data sources, 25+ markets, and more than 75,000 SKUs.

    The company that once ran on fragmented spreadsheets now operates with unified, real-time visibility and automations that continuously optimise pricing and marketing spend. The work continues: we stay close to the business, exploring new opportunities for automation and finding new ways to put data to work.