Locations: Czech Republic
Area served: Europe
Phoenix LV is a leader in the pharmaceutical distribution market in the Czech Republic and forms part of the multinational Phoenix Group, one of the largest European pharmaceutical wholesalers operating in 26 countries. For these pharma leaders, compliance and building trust with their partners, customers, and stakeholders is key. One way they’re able to forward their ethical operations is by using data to support their decisions. We recently chatted with one of their Data Engineers, Karel Lebr, about their data journey with Qlik Sense and Vizlib.
For Phoenix LV, their analytics journey began many years ago with the business using Excel to create basic tables and visualisations. “For something like test visualisations, we used MS Powerpoint online,” Karel added.
So, we were definitely relieved when he added that “we are moving away from this type of dinosaur solution to visualising data in a modern way.”
Looking at their present-day business intelligence (BI), Karel shared that the business’ core function is the transportation of medical materials and medicine, resulting in them using logistics data every day.
Another key use case for their analytics is in sales, analysing the sales margins of the products they deliver, for instance. Also to gauge the profitability of each product, and optimise transport routes between their headquarters and retail points.
For the past three years, Phoenix LV has been using Qlik Sense for their data analytics.
But even though they’ve been shifting to more modern BI, not all their end users were along for the ride yet with native Qlik Sense. “The end users have to get used to it [Qlik Sense] because they’re more comfortable using Excel and Powerpoint,” Karel explained.
Their main use of Qlik Sense is for their finance department for visualising P&Ls, and P&L reports.
“Before switching to Qlik Sense and Vizlib, all the P&Ls were delivered in Excel tables. So it took a long time and was not dynamic.” Karel Lebr, Data Engineer, Phoenix LV
Since the company needs to visualise their P&Ls in a dynamic environment, they now use Qlik and Vizlib to simplify their data.
“And when I tried to make these P&Ls with only Qlik Sense visualisations, it was awful.” Karel Lebr, Data Engineer, Phoenix LV
The business discovered that with the limitations of native Qlik Sense, the end users couldn’t utilise the exact colours they wanted for their P&L reports. “All the P&Ls and other reports required specific colours for everything like budgets, for instance.”
So they had a problem to solve. “…and it had to be solved because the business really needed customisable colours and visualisations,” Karel explained.
What did they do next? They searched the market for enhancements to their Qlik Sense solution. “And we found Vizlib Library.”
Phoenix LV needed their dataviz to be more modern and dynamic. And by adding Vizlib to their Qlik analytics, the end users benefited greatly!
“It’s far easier to get used to working with it because it’s much more end-user friendly. It’s simpler to get into and answer your business questions.” Karel Lebr, Data Engineer, Phoenix LV
Now all their users are working confidently with data using Vizlib Library. “And the reason why is simple. It’s so much easier to use it as a developer. And has helped us open up lots of new possibilities with our standard Qlik Sense visualisations plus Vizlib. And Vizlib’s basic charts are much more valuable than standard Qlik Sense.”
And Karel wasn’t finished singing the praises of Vizlib Libary.
“Vizlib Library is an amazing product and enhancement. I’m really enjoying the features like the Viztips – the little details that make our reports better and prettier, plus easier for the end user.” Karel Lebr, Data Engineer, Phoenix LV
Another Vizlib Library extension they’re enjoying is Vizlib Pivot Table. “Vizlib Pivot Table is awesome because it’s something our end users are more familiar with. It’s really similar to the Pivot table in Excel. So it was easier to learn, much easier than learning the standard Qlik Sense Pivot table.”
Phoenix LV plan to continue using Qlik + Vizlib to support their end-user needs. Since being fairly new to Vizlib’s value-adding products, Karel shares their ideas for how they’ll be expanding usage. “The next steps for the organization are getting used to working with data in a dynamic environment with Qlik Sense, with a lot of help through Vizlib Library.”
Within the Vizlib Library range, the company also plans to explore Vizlib Table. “The possibilities of the table are endless. We can improve those reports much more than they are now.” Plus they plan to explore the benefits of Vizlib Scatter Chart soon.
As for what’s next in their Vizlib journey, Karel added, “I’m really looking forward to using Vizlib Self-Service because I think it can be really useful in the future.”
Another way they plan to grow and improve their analytics and Qlik adoption are by improving data literacy in the organisation. “We have to teach the end users how to read data and how to use it.” Karel feels that their main hurdle when establishing new projects is that “end users don’t know what can be achieved and that we can deliver in-depth reports because they’ve used to using tools like Excel and Powerpoint.”
We can’t wait to hear more about how Vizlib is helping Pheonix LV boost data literacy and help all their users get the most from their Qlik analytics.
Vizlib’s feature-rich data visualisation products will help you get started on your data storytelling journey.
Got a technical question? Our Help Centre has heaps of helpful guides, articles, FAQs and more. Access Help Centre