Xpert BI was featured as a case study in the 2020 paper Automating Data Warehouse Development by Henry Cook, Gartner. It high-lighted our co-existence strategy with Microsoft products. It means we don’t reinvent the wheel, rather we add what’s lacking in Azure; an integrated approach to automation and data governance.
First deploy to SQL Server on-premises. Then move to Azure. Then add staging with Azure Data Lake Storage gen2 for large, cost-effective storage. Then add processing layers in Azure Synapse Analytics for high scale data platforms. The flexibility for IT and business are endless, while keeping data lineage and documentation intact.
Every data platform projects use some form of automation with scripts, custom frameworks, and code. This is often hard to maintain over time. With Xpert BI, automation is delivered as software. Thus there is no need for the project team to test any code generation framework for each sprint or iteration delivery greatly accelerating the developing speed.
Project experiences and best practices are built into the software enforcing a consistent development approach. It improves the robustness of your data platform while greatly reducing key-person risks and simplifies onboarding of new people.
Tomorrow's data platform requirements expand well outside the traditional boundaries of a data warehouse. Also Azure ecosystem is complex and is constantly evolving. We advise both small and large organizations on how they can choose optimal Azure components and how to automate their data platforms.
Many automation frameworks for i.e. Azure Data Factory introduce key-person depencies and makes hand-over difficult. Data lineage and documentation is often not automated and the framework can be costly to maintain and lead to inconsistent and unstable data platforms. Instead, Xpert BI provides data platform automation as software ready to-go, so you can focus on your architecture, your data, your models and your business logic.