South African financial services company

    A financial services company moves its legacy SQL, SSIS and SSAS estate onto Microsoft Fabric

    Senior Fabric specialists worked alongside the in-house data team to migrate, stabilise and decommission the old platform in about six months.

    ~6

    months from migration to decommission

    2
    senior Fabric specialists
    3
    legacy layers retired
    Industry
    Financial services
    Region
    South Africa
    Duration
    About 6 months
    Published
    16 October 2026
    Services
    Microsoft Fabric, Data engineering, Power BI migration
    Built with
    Microsoft FabricPower BISQL ServerAzure DevOps
    The challenge

    A legacy stack the business had outgrown

    The company's data platform ran on SQL Server, SSIS packages and SSAS cubes, feeding a large Power BI estate. The target architecture for Microsoft Fabric was already designed, but the in-house team needed experienced Fabric engineers to deliver it alongside day-to-day work, without losing the business logic only they understood.

    Our approach

    Embed Fabric specialists next to the people who know the logic

    We placed a Fabric data engineer and an analytical consultant into the client's team. The in-house lead kept ownership of the business logic, while our specialists delivered the Fabric build: three months of migration, then three months of stabilisation, optimisation and decommissioning.

    Data in by mirroring and pipelines

    Sources were brought into Fabric through mirroring, pipelines and custom connectors, including MySQL, replacing the SSIS packages.

    Medallion lakehouse

    A metadata-driven Bronze, Silver and Gold architecture replaced the old staging and warehouse layers.

    Models and reports moved

    SSAS models were rebuilt as Direct Lake or Import semantic models, and the Power BI reports were migrated and tuned.

    Every number checked

    Data validation and lineage checks compared Fabric against the legacy platform before anything was switched over, with user acceptance testing on top.

    Proper delivery pipeline

    CI/CD through Azure DevOps and GitHub Actions, with separate Dev and Prod environments, so changes ship safely.

    Knowledge stays in-house

    The client's own team kept the business logic and IP throughout, and our engineers focused purely on Fabric delivery.

    Technology

    Where the data lives and how it flows

    Legacy platform
    ReportingThe migrated and tuned report estate
    Legacy platform · The client's existing Microsoft data estate
    SQL Server, SSIS and SSAS

    Legacy databases, integration packages and cubes, plus MySQL sources, migrated and then decommissioned

    The results

    What changed

    3legacy layers retired (SQL, SSIS, SSAS)
    ~6months to a fully decommissioned old platform
    2specialists embedded in the team

    The company now runs its data platform and reporting on Microsoft Fabric, with the legacy SQL, SSIS and SSAS components decommissioned.

    Because the in-house team kept the business logic while our engineers delivered the build, the knowledge stayed in the business and the platform is theirs to run.

    Get in Touch

    Got a reportingproblem like this?Let's talk it through.

    Bring the system you report from today. In 30 minutes we'll show you what Power BI could do with it. No pitch deck, no obligation.

    Emailinfo@Solv-Systems.com
    Verified Reviews

    What Our Clients Say

    Verified reviews from G2 and Clutch, in our clients' own words.

    • 5.0 / 5.0
      Verified G2 Review
      "Great to work with, highly skilled, good time and effort estimates"

      Oliver P.

      Operations Lead·Mid-Market

    • 5.0 / 5.0
      Verified G2 Review
      "What stands out most about Solve Systems is their ability to understand our business context and translate complex data into clear, usable insights. Their consultants are knowledgeable, responsive, and practical in their approach, which makes collaboration easy and productive. They focus on outcomes rather than just technical delivery, and that adds real value to our operations. They're also a positive bunch of people with a can-do spirit, which makes working with them even better."

      Chantelle V.

      Automation Engineer·Enterprise

    • 5.0 / 5.0
      Clutch Review
      "Their dashboards are intuitive, reliable, and tailored to our needs."

      Ashley Swanepoel

      Technical Team Lead·Cloudbox

    • 5.0 / 5.0
      Clutch Review
      "I was also impressed by the highly skilled nature of their team."

      Darren Mende, CPA

      CEO·DP Mende & Co.

    • 5.0 / 5.0
      Clutch Review
      "Their passion to help businesses utilize technology better."

      Anonymous

      Modern Workplace·Education Company

    • 4.5 / 5.0
      Clutch Review
      "I enjoy the collaborative co-learning structure of our workflow."

      Anonymous

      Ecological Data Analyst·Energy Solutions Company

    Read all reviews on G2Read all reviews on Clutch