Data and AI
Azure Synapse Analytics, Power BI, & Machine Learning
The customer provides various educational products to schools, colleges, and public libraries through its subsidiaries. The customer has been a trusted partner to Pre-K and K-12 schools, districts, and college campuses for more than 140 years.
The customer has developed a reporting solution in QlikView for Publishers to provide insights about content circulation and other elements that help Publishers.
The solution was inefficient and was not supportive of managing large volumes of data (16 Billion) and 1,000+ publishers simultaneously. With a growing readership, timely and accurate data insights are crucial to staying competitive.
The solution architecture was not scalable and had limitations when readers accessed the reports, which impacted the business performance. The customer was keen to build a solution to overcome the following challenges:
- Reduce the time to load the report
- Handle large volumes of data efficiently
- Build reports through volumes of data for better data insights & rich reporting capabilities
- Have the flexibility to scale up and down
- Optimize resource utilization-cost
WinWire proposed a robust architecture to develop the solution using Azure Synapse and Power BI. We supported the customer to:
- Develop a high-performance data ingestion pipeline using Polybase to move the data over the network
- Terabytes of data are stored in Azure Synapse Analytics, processed large volumes of data and complex calculations resulting in faster insights and limitless scale
- Supported large volume of data comprising 17 billion rows & 200 concurrent users, with the scalability of up to 1,000 users.
- Auto scale-out & scale back compute adjustment based on data peak periods for improving query performance
- Optimized cost by offering the flexibility to pause the data warehouse when not consumed
- Rich data insights & reporting capabilities provided using Power BI
- A customized search-based algorithm to give more visions on new releasing titles
- Reports are embedded into a third-party .NET application
- Elevated business efficiency and performance
- Improved user experience
- Reduced the time to load the report to 4 secs