This is an excerpt from a case study. You can download the entire case study here.
NSW Business Chamber is one of Australia’s largest business support groups, helping over 25,000 businesses each year.
Founded in 1825, they support thousands of companies, from sole traders to large corporates, and have developed into a leading business solution provider and lobbying group with tremendous strengths in workplace management, work health and safety, IR, HR, international trade and improving business performance.
Independent and non-government, NSW Business Chamber represents the needs of business at a local, state and federal level, lobbying governments and authorities to create a better environment to do business in.
Many reports, little consistency in look and feel
Akash Jaiswal, Manager of Analytics and Application Development at NSW Business Chamber, found he was juggling a multitude of requests for data about membership. Senior management and board members were constantly seeking reports detailing the number of members, the products, services or events that members had paid for, membership data by region or industry sector, and changes in membership.
“There were lots of reports flying back and forth but no consistency in look at feel,” Jaiswal explains. “We never had an opportunity to look at the variety of information being used or to consider what was needed from month to month. When we did stop to look we discovered the same information was being reproduced nearly every time with just minor changes.”
When an organisational change forced Jaiswal to look carefully at his staffing resources, he realised that the number of requests being received and the production of ad hoc reports for the board each month had become too time consuming. It was clear the Chamber needed a tool to automate and bring consistency to the process, one that could make the relevant data available to all stakeholders. Further, Jaiswal wanted to apply the tool to more than just membership information. The Chamber had a wide variety of financial and commercial data that could benefit from such analysis and reporting.
Check with the experts
Jaiswal began to research business intelligence (BI) and analytics tools. “We checked with the Gartner report to see who the providers were in the market and whether they were benchmarked as leading or emerging. We identified which tools would fit our requirements.”
Land and expand
Professional Advantage recommended the Chamber adopt the proven “land and expand” methodology for the deployment, starting with small, discrete projects and then expanding from there. This would allow the Chamber to quickly begin reaping benefits from its investment as each stage was completed.
The first area of the business chosen to benefit from QlikView was the Chamber’s commercial services. Jaiswal says, “We chose this because commercial services had fewer automated reports.” Therefore, he explains, it presented the greatest opportunity for fast and appreciable business improvement.
The project focused on reporting transactional information for the Chamber’s general manager and for inclusion in board information packs. Within three months the QlikView solution was up and running with a simple-to-use dashboard providing access to a range of reports such as the top 50 or 100 customers, product performance by various business groups, and comparisons of sales year-on-year, by individual, product and client. All data is capable of being filtered according to region or industry sector.
Next, QlikView was integrated with the membership data. Jaiswal comments, “Data mining was key for this, especially with regards to storing a historical copy of data, and the need to validate the business rules behind that particular data. For example, if dealing with a membership reinstatement or invoice cancellation, the rules of that time have to be factored in.”
Managers and the board welcomed the new reporting functionality. “This was the first time we had information that was flexible, that could be sliced and diced. We were getting a consistent view of the data and no longer needed an analyst sitting there working out the reports. The feedback from the business was very positive,” Jaiswal affirms.
Finance was the third area to come under the QlikView spotlight. This was soon followed by the Apprenticeship Centre, a division within the Chamber’s business dedicated to helping employers and their apprentices build effective and mutually rewarding working relationships. QlikView is being used to help track the number
of apprentices and their performance in terms of completion and cancellation rates.
Instead of allocating analysts to work with each part of the business we now have just one analyst working across all five units, supporting all the dashboards.”
Where it used to take two days to prepare monthly membership data for reporting, it now takes Jaiswal’s team less than an hour. In other areas of the business, Jaiswal believes that QlikView is saving anywhere between one and five days in monthly report preparation.