Exciting news! Vizlib joins the insightsoftware family | Learn more
Improving data quality writeback in Qlik Sense
May 28, 2021

Minimising data errors with Vizlib’s writeback capability

Traditionally, data analytics applications have been a one-way street: read the source data and generate results. When it comes to BI, you need to have the cleanest, error-free data possible. It’s a pain to go into your data source, fix or add information, and then get the app to reload it and run the analysis again. What if we told you there is a way to cut out those timely issues?


Meet Geoff 🙋‍♂️, he makes mistakes 🤦‍♂️. Geoff is a master of Customer Services, but not when it comes to capturing data. We can’t blame Geoff, really, he’s just trying to be helpful and we love his can-do attitude! But Geoff’s mistakes mean that the rest of the team has to spend a lot of time cleaning data, otherwise, the BI results won’t be accurate.


Thankfully, there’s a solution to all of Geoff’s, or our problems: Writeback.


Writeback instead of backtrack


Vizlib’s writeback capability for Qlik Sense operates with databases that use the REST API. It enables users to safely and securely edit data sources in almost any way they want to. With writeback, a user can easily add in new columns, change formatting, or fix data that may have originally been captured incorrectly. And the data is stored where you choose, whether it be CSV, TXT, QVD, SQL Database (PostgreSQL default) or any other REST endpoint. Vizlib puts the decision-making in your hands.


So Geoff and his team can instantly review their stats, plus edit and analyse their sales data all in the same place with Vizlib’s writeback capabilities. No need to navigate away from their Qlik app.  Since all the details are at their fingertips,  the team can immediately spot and correct any bad data, adjusting it instantly to maintain accurate data quality and insights! 


Everyone on the team can easily input and adjust data on the fly

And don’t worry about having a server, you can choose Vizlib’s serverless writeback option. This means it also works on Qlik Sense Cloud ☁. Neat! You can also choose to reload the app when the data is edited.


Plus, Vizlib’s writeback capability is already included with the Collaboration product, so you don’t need to worry about adding another piece of software to your stack.


Limit access with Collaboration


But what if you don’t want Geoff to go anywhere near the data? Well, you can do that too. With Vizlib’s Server solution, Administrators can configure who can use the writeback feature. It is built with security in mind. Plus, it can be used to reduce and secure data that is viewed by end-users. After all, your data is important and no one wants it to be erased and damaged beyond repair by certain people…


Version control with ease


Usability is the name of the game, and that’s why it’s already included with Collaboration (along with Vizlib Input Form). Your team can leave notes when Geoff needs to fix data, see what he edited, and completely manage version control. It’s an extremely robust solution that is perfect for the current pandemic-skewed world.


Capture data quickly, easily and safely with Vizlib’s writeback capability


Agile retail analytics in Qlik Sense

Vizlib Collaboration enables your organisation to rapidly prototype and build new fields and columns on the fly. The new fields will integrate and become part of the app’s data model and can be stored in other destinations. If you’d rather not offer that level of flexibility to your users and keep your schema controlled, you can write back to an SQL Database using Vizlib’s Server solution.


Now, if only we can get Geoff to stop microwaving fish in the shared kitchen.


Oh, Geoff. 🤷‍♂️


Are you ready to take charge of your data with writeback? Sign up for a demo today.

You’ve come to the right place!

Vizlib’s feature-rich data visualisation products will help you get started on your data storytelling journey.

  • Easy-to-use (including drag and drop functionality)
  • No coding skills needed
  • Highly customisable to suit your design needs
  • Templates to fast-track your dashboard creation

Got a technical question? Our Help Centre has heaps of helpful guides, articles, FAQs and more. Access Help Centre

Book a demo