VodafoneZiggo’s Journey How VodafoneZiggo accelerated their position and delivered a robust service-oriented BI Platform

2 Who am I JOHAN VAN DEN BOSCH Technical lead reporting & visualization analyst at VodafoneZiggo Married and father of 2 daughters (7 and 11). I live in Ede (gld) and I am 46 years old. I love to cook, to travel, to read and history. I also like to hike, do sports in general and to have it “gezellig” MORE ABOUT ME I studied Technical Information After graduation started as a developer of software (1998) and since 2008 working with Qlik (QlikView). I’ve been a consultant for many years and have worked for a lot of interesting companies varying from civil engineering, finance, social care, pharmacy and governmental organizations. I have worked for companies like: Yacht, Vattenfall, TVM, Fortis, SNS and for Philips, Janssen Cilag and Verint as well. Before VodafoneZiggo I worked more than 5 years for Bitmetric. Since 2019 I work for VodafoneZiggo EDUCATION & EXPERIENCE

3 Chapter Reporting & Visualization NEARLY 6.9% Of our users are reporting analysts, business analysts and developers. Able to create their own insights, share and evolve those across the company or outside. And almost 3000 users use embedded solutions 7250+ Internal developers, business and data analysts, and customers use our BI environment use our data for actionable insights. 250+ Colleagues of Data & Artificial Intelligence support and facilitate our (business) users and customers. 40+ Reporting analysts support business Qlik reports, dashboards, stories and Nprinting solutions VODAFONEZIGGO AND PARTNERS TRIBE DATA & ARTIFICIAL INTELLIGENCE CHAPTER REPORTING & VISUALIZATION

4 Challenges we face Demand of data increases more and more and we need it yesterday Legacy reporting needs to be faced out. New technology needs to be embraced Shortage of qualified staff versus availability of business knowledge in the business itself. Can the business do more on their own? Hardware, software and tooling are no longer sufficient to support demand

5 ALL IS GOOD, BUT COULD BE IMPROVED Identified areas of improvement 02 04 06 We need to help colleagues to become more data literate and provide more in-depth schooling KNOWLEDGE We need to make our processes faster, more efficient and leaner PROCESSES We need to setup simple rules, guidelines and provide help where possible GOVERNANCE & GUIDELINES 01 03 05 We need to provide the proper tooling and automate processes where possible TOOLING & AUTOMATION We need to create better dashboards, faster data flows and better understanding how thinks work PERFORMANCE TUNING We need to scale up, -out and beyond to support the increased demand and possibilities HARDWARE & SETUP LOTS OF THESE IDEAS AND EXECUTION OF THEM CAME FROM OUR OWN REPORTING COLLEAGUES & BUSINESS USERS!

6 Business Analysts and other enthusiasts D&AI Tribe Reporting Analysts Share the knowledge Shorts bursts of knowledge. Mix of easy and complex topics, best practices and how-to’s KNOWLEDGE SHARING SESSIONS Long sessions about complex topics, data modeling , “under the hood” and visualization IN DEPTH SESSIONS Extensive 2-month enrollment about Business Intelligence. DWH techniques, data modeling, Python, Qlik and soft skills MASTER CLASS + A basic and advanced training to provide understanding and ability to DIY. Design Thinking trainings are offered as well BUSINESS ANALYST TRAINING Coach and guide groups of business analysts and advanced power users COACHING AND MONITORING Tailor made knowledge sharing sessions, shorts bursts of relevant topics. BUSINESS KNOWLEDGE SHARING SESSIONS 01

7 Tooling and automation 02 Help reporters and business analysts to create better dashboards, reports and insights by provide the right tools, automate tedious steps. Remove manual labour such as repetitive checks, setting baselines, deployments and focus on gaining valuable insights, predict the future and prescribe the necessary. HOME

8 Tooling 02 The right tool is choosing the right software, and stick to it. The rights tools are sometimes as simple as templates and scripts. Governance and guidelines originate from these tools as well. • Qlik Sense • Qlik Sense Document Analyzer Pro • Monitoring apps • Templates • Re-usable scripts • White papers and cheat sheets TECHNICAL TOOL BOX

9 Automation 02 We have automated tedious manual steps, and provide pre-made sets of data. The power of automation is to control the simple tasks and focus on the more interesting ones. • Deployments via GITLAB • JIRA • Definition of Done and Ready • Create a “QVD-layer” • Data reload triggers from Workflows instead of set times AUTOMATED

10 Improve the process Remove unnecessary steps from the process, but add better checks GDPR, Architecture, best practices Easier to create and deploy solutions LESS STEPS, MORE CHECKS KEY REPORTERS/REVIEW We added the role Key Reporting Analyst to perform checks and peer reviews. Acts a guard at the gate This brought our deployment time back from 2 weeks to 2-3 days SPLIT THE PROCESS We now have 2 similar processes Dependency and Quick This saves deployment time as well Majority is deployed in 1 day INCREASED SERVICE MANAGEMENT TEAM We have increased the service management team from 1 to 3-4 This allows us to improve at any moment in every way 03

11 Performance tuning 04 Challenge: Quality of dashboard solutions & data had to be improved. Knowledge of reporters and business analysts had to level up and hundreds of legacy had to phase out. It took too long to get the newest data, the data was not right and business was annoyed…. A LOT WHAT DID WE DO?

12 Performance tuning Teach about best practices How to script in Qlik How to data model How does Qlik work “under the hood” Explain why things the way they work KNOWLEDGE SHARING TOOLS AND CHECKLISTS Use QSDA and monitoring apps to set a base line Set governance, guidelines and rules Bad performing solutions will be exposed and taken care of BUDDY SYSTEM We have set up a senior – medior/junior system to guide our colleagues Key reporters review solutions before deployment Be the Nerd/geek ALWAYS ASK THE W 04

13 Governance and guidelines 05 We already had rules, and lists and best practices. We had Ways of Working, guidelines and flyers, papers and best efforts. But not in one place. We needed experienced people to govern all of the above, we needed colleagues to be ambassadors, we needed One Way of Working. Qlik Advisory Board Key Reporter Analysts

14 Governance and guidelines (Examples) 05

15 It helps us to support future extensive Self service, less down time and a more mature Reporting Chapter Improve the hardware setup 06 We had a single node Qlik Sense setup for Acceptance and one for Production We provided a single Nprinting server and 1 person to support this Now we have a six node Qlik Sense Server setup with fail over possibilities Setup can be scaled-out and –up easily and Nprinting has become a 4 server lay out Now we have a team to support this

16 ALL IS BETTER AND WILL BE IMPROVED OVER TIME Identified areas of improvement 02 04 06 We need to help colleagues to become more data literate and provide more in-depth schooling KNOWLEDGE We need to make our processes faster, more efficient and leaner PROCESSES We need to setup simple rules, guidelines and provide help where possible GOVERNANCE & GUIDELINES 01 03 05 We need to provide the proper tooling and automate processes where possible TOOLING & AUTOMATION We need to create better dashboards, faster data flows and better understanding how thinks work PERFORMANCE TUNING We need to scale up, -out and beyond to support the increased demand and possibilities HARDWARE & SETUP UTILIZE THE KNOWLEDGE OF YOUR EXTERNAL HIRES!

Questions? Happy to answer! Please meet us with Qlik at stand 97! We’ll have a chat and all time!