Case Study
Big Data and Analytics
QlikView to QlikSense Migration for a Food Processing Operations Firm
Get It Now
Case Study
Big Data and Analytics
QlikView to QlikSense Migration for a Food Processing Operations Firm
Explore Now Our customer is one of the largest providers of packaged food products in the US for over a century. They were in need of a tool that can report, access DB, flat files, in-line tables and reach other visualization reporting requirements. Our team provided consulting, approach and implementation services for a successful QlikView to QlikSense migration.
Through this case study, you will learn how our customer achieved advanced visualization capabilities and self-service BI for obtaining more cost efficient results than before. The case study also talks about the QlikView implementation and how our team helped in moving the visualization layer from QlikView to QlikSense along with Data Governance and Security.
Thank you for submitting your details!!
Customer Background
Our customer is a leading food processing firm that has been successfully doing business for over a century. With a current focus on private label products, they are one of the largest providers of packaged food products in the US.
Technology Used
The products and technologies used in this effort by our team and the customer were,
- Database - MS Access Scripting
- Scripting - Visual Basic (VB)
- Reporting Tool - Qlikview/QlikSense Cloud
The Business Requirement
Our customer was in the need for a tool which can report, access DB, flat files, in-line tables and reach other visualization reporting requirements. Earlier, they used little dashboards with a bottom-up implementation architecture. Due to multiple QVDs, scripts and connections it was difficult to handle IT governance.
Through a centralized QlikView Enterprise server and QlikSense, the customer was able to achieve advanced visualization capabilities and self-service BI which became much more cost efficient.
Our Solution and Support
Miracle's Data Services team was able to assess the customer's current scenario and offer them suggestions around what approach to take to achieve their goals. The recommendation of QlikSense involved analyzing the requirements versus the tools offerings to ensure that it matched the customer's needs.
- Implemented solution in a phased approach,
- Phase #1 involved moving the visualization layer from Qlikview to QlikSense along with Data Governance and Security
- Phase #2 involved Data layer migration and conversion along with Data standardization and master data management best practices
- Minimal impact to the business was achieved as part of the implementation, as the underlying data structures QVD remained same
Qlikview Implementation and Qlikview to QlikSense Migration
- Our data services team was able to provide consulting, approach and implementation for a successful Qlikview to QlikSense migration in phases
- QlikSense desktop version 3.2 was used for the conversion of Qlikview 11.0 documents and dashboards to QlikSense apps
- Access to the QlikSense 3.2 Dev Hub was used to convert the QVW files to QlikSense QVF
- The tool converts visualizations, dimensions, measures, parameters and variables
- The converter tool converts visualizations to the best extent possible and will create master objects on the ones chosen for export
Customer Benefits
Through our innovative services the customer was able to achieve huge benefits. Below are some of the benefits that the customer experienced.
- Our customer was using MS Excel as a reporting tool, now Miracle has deployed Qlikview and QlikSense
- Our code is highly secure and no one can tamper the code
- Visualize the data with images and graphs
- The data can be accessed anytime anywhere
- The data can be searched directly or indirectly
- Once Qlikview is implemented, QlikSense was also implemented in Cloud
- Provides leadership and expertise in investigation and resolution of performance related issues for warehousing and trading system environments
- Designing major reconstructions of database structures to ensure appropriate levels of performance, data integrity, recovery and security are achieved
- We have assisted in providing technical guidance, support and training to the database administration staff and provided evaluation on their technical proficiency
Folder Structure Details
- The refresh batch file is located under the QVD Generator folder, which can be scheduled using windows task scheduler
- The connection configuration is located under the include folder
- The generated QVDs will be saved under QVD folder - or any other user-defined location in include/connection.txt file
- The QVF (QlikSense Code file) is location under the QVF Folder
Thought Leadership
Modernization of EDI Platform for a US-based Transportation Services Company
Understand how our support services helped the customer by working closely with their team, processes, and data to gain both functional and business knowledge.
3D Product Experience Website for a Leading Custom Apparel Manufacturer
Learn how we use the latest technology to better serve our customers with a realistic view of 3D product experience through our apparel manufacturer's website
CRM Data Visibility Portal on Cloud for Marketing Agency
Discover how a cloud-based CRM data visibility portal can provide marketing firms access to customer data tracking, and reporting to update their services
Job Request Portal for Temporary Employment for Membership Association
Explore how we offer a variety of employment opportunities for membership associations and how this Employment Portal can help job seekers find employment
Implementing Helpdesk Chatbot(s) for National Retailer
Discover our helpdesk chatbot, which includes a live-agent chat interface for global retailers to offer the greatest and improving experience for our consumers
Web Based Order Management System for a Leading Custom Apparel Manufacturer
With a web-based order management system, a custom athletic apparel manufacturer can save time and money while giving customers a safe and smooth experience
Enhanced Application Development for a Global Manufacturer
We used JavaScript/jQuery and Rest APIs to achieve our client's desired performance while improving their application design, reporting, branding, and archiving
Advanced Supply Chain Solution for Leading Logistics Provider
Offering an advanced supply chain solutions to the business on a day-to-day transactions with simplified code to handle large systems with robust outputs
Cloud Based Vehicle Transfer for Wholesale Auction Company
By automating the process for an Auction Company while building an AWS serverless web application to increase efficiency for cloud-based vehicle transit
We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also disclose information about your use of our site with our social media, advertising and analytics partners. Additional details are available in our Cookies policy and Privacy policy.