We have now finished our Power of Story Telling with QlikView seminar series, having presented in Melbourne, Sydney, Perth and Brisbane.
The series proved popular, with attendees looking to see how they can improve their businesses with Professional Advantage’s implementation of QlikView, a reporting, and business intelligence application.
A common concern among attendees around their current reporting methods was handling non-standard (ad-hoc) report requests, as well as the time and effort it takes to compile standard reports.
Ad-hoc report requests
When the regular and standard reports are published within an organisation, queries arise regarding the results. To drill into the detail, non-standard (ad-hoc) reports are requested. This triggers a rework of the data stored by the report generation team, and typically involves a turn-around time of one to two days.
Because of the additional workload generated for this team, restrictions are sometimes put in place, restricting who can request such reports, and how often. As a result, report recipients, passionate about improving the performance of the business, are restrained. This impacts the business in two ways: a drop in staff engagement in business optimisation, and the resulting fall in their contribution to the business’ success.
QlikView is unique as it manages the data manipulation itself (no need for manually adjusting data cubes). So users can query the data in many different ways, using data acquired from both internal and external sources, without increasing anyone’s workload. As a result, many queries can be made, and new insights gained, capitalizing on the passion within the organisations’ management.
Standard report generation
QlikView can connect to almost any data source to extract information (Microsoft Excel, SQL, Oracle, Microsoft Access and many more databases). Professional Advantage can configure a QlikView implementation that removes the time consuming (and error prone) manual collation of data which typically involves using Excel pivot tables in the majority of IT environments. This is achieved by directly connecting the numerous disparate data sources. As a result, both standard and non-stand reports become a low or no-effort affair.
‘Dirty data’ is where data is inaccurate, incomplete, or missing altogether and is not an uncommon occurrence. Dirty data reduces a report’s usefulness and, over time, the faith managers have in them. Through the implementation of QlikView, staff are freed up from this regular report compilation task, giving them time to look at the quality of the data collected, and the correlation of data between different data sources, removing dirty data, and monitoring entries as new data is added. The improved report quality gives management more faith in what they’re seeing, and can thus make better business decisions, further optimising the business’ performance.
You can read more about Professional Advantage and QlikView here.