K4 Analytics

 K4 Analytics: logoWith K4 Analytics, finally enjoy Smart Data-Entry in both Qlik Sense & QlikView! Leverage K4 Analytics and build the missing link between your preferred BI platform and Enterprise Databases, delivering rich Corporate Performance Management applications. Or just fulfil your needs for data-entry and write-back in your Qlik Sense apps.

No more spreadsheet anarchy and finally effortless real-time data consolidation: you will continue to use your Excel models but we will make them dynamically integrated with the data-sources, with the ability of editing the data and saving back on the fly to the central database(s).

With Smart Data-Entry, master numbers and simulation thanks to rich features such as blocked totals, copy from, allocation drivers... Just add full audit trail, integrated workflow control and real time collaboration, this is K4 Analytics!

  • Initialize the budget with one click using any data as a reference (e.g. previous year sales, forecast, etc.)
  • Create different budget versions
  • Manage distributed data-entry where different users collaborate, participating to the budgeting process in a secure and controlled way with audit trails
  • Manage planning calendars
  • Explode an aggregate budget to a detailed one in a Top-Down approach
  • Manage driver-based allocations
  • Collect easily and consolidate data from existing spreadsheets
  • Make the budget figures available in real-time to other systems (e.g. ERP, CRM,etc)
  • Develop SOX-compliant applications thanks to audit trails
  • Leverage all the power of Sense and QlikView for analysing performance against the budget
  • Leverage excel templates for P&L and other financial statements (with data-entry)

All this and much more is already possible, thanks to the new K4 Analytics software!


What can you do with K4 Analytics?

K4 allows you to leverage all the flexibility of spreadsheets inside QlikView and Qlik Sense. Using an Excel© file as a template, keeping all the formulas and the formatting, K4 dynamically fetches data from Qlik dataset and SQL live queries to populate the Excel template.

You can, for example, use K4 to manage a simple Profit&Loss statement with amazing speed and simplicity: just build the template in Excel, link cells to data and use it inside Qlik, users are not required to have MS Excel installed.
And it doesn’t stop there ... you can even enter data, text, date, checkbox and drop lists in K4, saving on the fly to a SQL database!K4 Analytics: spreadsheet flexibility

In a very simple way you can lock data (disable the data-entry) on a cell-by-cell basis through a Qlik or a SQL expression:you can display actual data for closed month and editable cells for planning months.
The locking logic can be as complex as you need: taking into account for example the current date versus the planning calendar and the current user versus the hierarchies.
You can manage a distributed planning process with multiple users entering data in a common database with full control thanks to K4 Audit Trails feature.
K4 does not come with a predefined business model, you can use it to build exactly the application you need.

K4 Analytics: data entry and SQL databases


How does K4 work?

The K4 solution is made of two components: the Qlik extension object and the web service. 
The extension object loads data dynamically from one or several Qlik datasets or one or several SQL queries and merges them into an Excel file used as a template.

If K4 is configured for data-entry, when the user hits Save the new/changed data is sent to the web service which takes care of writing them in a table in a relational database. 
The data is then read back on-the-fly from the SQL database when the object is refreshed. (and eventually loaded back into Qlik with a reload). 



K4 Analytics: K4 object in a document opened with the browser



You can use the K4 object in a document opened with the browser (AJAX client) from the Qlik access point or opened with the Desktop client (in QlikView in WebView mode). MS Excel is not required on the clients.

K4 uses its web service for write-back. The web service receives from the K4 object the new/changed data together with the Qlik document current selection and the user id: it compares these data with the structure of the buffer table to check that it has all the information (e.g. primary keys) it needs to create/update records in the buffer table.


About Agilos

Agilos’ mission is to help businesses to become more competitive and agile through a smarter and better use of their data. We do this by providing a best-of-breed platform that enables companies to take better decisions.

Through our training, coaching and expertise, we help them realize a short time to value and maximize the ROI of their business intelligence journey.

Connect with us

Get In Touch

Brussels Office

Luxembourg Office

contact [at] agilos.com