Client’s AS400 system didn’t regulate data consistency or provide a user-friendly experience. In working closely with the executive team an end-to-end data solution was agreed upon; Microsoft stack on the backend with Qlik Sense empowering users on the frontend.
A SQL Server Database environment was implemented to ingest AS400 data. With the correct architecture, rules, and cleansing checks, this implementation served as the foundation for trusted data and a backend architecture for frontend tools.
Six enterprise applications were built consisting of 12 dashboards providing insight, standardized KPIs, drillable visualizations, and user-friendly self-service tools. A series of training guides, videos, data dictionaries, feedback loops, and a custom web landing page were also implemented.
Tools Used: AS400, SQL Server, SQL Integration Services, Qlik Sense