CASE STUDY included ease of use , scalability and the flexibility to cover multiple areas of its operation . The other major requirements were self-service and visualisation .
When South Africa-based data specialist Insight Consulting proposed Qlik Sense and Qlik NPrinting , Fayo was impressed . “ We looked at Qlik and saw a full and sustainable package , including some great data integration capabilities .”
ARMSCOR was looking to partner with someone well established in the country that could support the company and Insight met the criteria . ARMSCOR saw that Qlik Sense offered the interpretation and analysis capabilities it needed , while also being able to acquire data from across the organisation ’ s diverse IT environment . process or extract , transform , and load process , is a data integration process that combines , cleans and organizes data from multiple sources into a single , consistent data set for storage in a data warehouse , data lake or other target system .
A detailed assessment of legacy data sources was conducted , followed by data cleansing and transformation directly within Qlik to ensure compatibility . Data was then extracted , transformed , and loaded into Qlik Sense for analysis .
Data governance measures were enforced to maintain data integrity throughout the migration . Historical data was consolidated into a centralised repository , providing a strong foundation for Qlik ’ s analytics and reporting capabilities .
“ The scope of the project was to address data quality issues and process inefficiencies within ARMSCOR ’ s Finance department , ensuring the creation of a trusted single source of truth ,” says Marco Afonso , Business Development Manager , Insight Consulting .
Process of modernisation
This foundational step was aimed to provide faster , more accurate , and actionable insights for executives across the organisation . By streamlining reporting processes , the initiative improved efficiency , consistency , and the reliability of financial data , enabling data-driven decision-making at all levels .
This approach not only enhanced the Finance department ’ s operational effectiveness but also contributed to better strategic alignment , ensuring that critical decisions were supported by accurate , and timely information throughout the organisation .
Once migrated , the data was integrated into Qlik Sense ’ s associative engine , enabling users to explore and analyse insights dynamically . This integration allowed ARMSCOR to leverage both historical and current data , enhancing decision-making and operational efficiency across the organisation .
This streamlined integration and migration process ensured Armscor could maximise the value of its data using Qlik products .
Business benefits
Qlik Sense and Qlik NPrinting went live around 18 months after ARMSCOR launched the tender . The Qlik suite , encompassing Qlik Sense and Qlik NPrinting , has significantly enhanced the value derived from these applications . By integrating Qlik Sense , ARMSCOR established a single source of truth , ensuring data accuracy and consistency across departments .
ARMSCOR relies on business-critical applications such as financial management systems , project tracking tools , and procurement systems to support its operations . These applications handle large volumes of data essential for maintaining efficiency , compliance , and operational excellence in defencerelated activities .
Integrating Qlik products with ARMSCOR ’ s IT infrastructure involved deploying Qlik Sense onpremises , in alignment with security and compliance standards . Qlik was integrated with key systems , such as mainframe servers , project tracking , and procurement tools , enabling seamless data flow and real-time access across the organisation ’ s IT landscape .
For data migration , Qlik itself was used as the ETL tool , eliminating the need for any additional tools . An ETL
This integration enables real-time insights , allowing decision-makers to monitor financial performance , track project progress , and optimise procurement processes more effectively .
Qlik ’ s associative engine empowers users to explore data relationships within critical systems , uncovering hidden patterns and actionable insights . Enhanced visualisations provide a clear overview of complex data , making it easier for executives and teams to identify trends , address bottlenecks , and improve operational decision-making .
With Qlik NPrinting , ARMSCOR automated its reporting processes , delivering customised , timely , and detailed reports to stakeholders . This reduced manual effort , improved data governance , and ensured that vital insights reached the right people when needed .
52 INTELLIGENTCIO AFRICA www . intelligentcio . com