Leading a Complex Qlik Implementation
Successfully delivered a critical Qlik solution under tight deadlines:
- Situation: FNB needed a new secured lending BI solution within 3 months
- Task: Lead development of Qlik models and dashboards for multiple business units
- Action:
- Conducted workshops to gather requirements from stakeholders
- Designed optimized data models and ETL processes
- Developed reusable visualization templates
- Implemented automated testing and validation
- Result: Delivered solution 2 weeks early, improved reporting efficiency by 60%
Solving Performance Issues
Optimized a slow-performing Qlik application:
- Problem: Dashboard loading times exceeding 5 minutes
- Analysis: Identified inefficient data model and unoptimized expressions
- Solution:
- Restructured data model using star schema
- Optimized set analysis and calculated fields
- Implemented incremental data loading
- Impact: Reduced load times to under 30 seconds, improved user satisfaction
Collaborating Across Teams
Delivered a cross-departmental BI solution:
- Team Composition: 5 Qlik developers, 3 data engineers, 2 business analysts
- Challenge: Aligning requirements from multiple business units
- Contribution:
- Facilitated requirements gathering sessions
- Developed core data model and visualization framework
- Coordinated testing and deployment
- Outcome: Delivered unified solution meeting all business needs, reduced duplicate reporting