“We used Qlikview to draw up our reports”, says Erwin Nagels, IT Service Manager and Chief Data Officer of VOKA. “However, our needs exceeded its user-friendliness and possibilities more and more. Next to that, the licences seemed to become more expensive every year. That’s why only few people used it effectively. We wanted more employees to have access to the software.”
Therefore, VOKA decided to look for a platform that matched better with the existing Microsoft environment and of which the number of licences could be kept in line with the required use. The number of licences increased considerably after Power BI had been introduced. Meanwhile, about twenty active users have been registered, and this number is expected to reach 200 in the near future.
More insights in different databases
VOKA uses Microsoft Dynamics CRM for its membership management and Microsoft NAV for accounting and other activities. Next to that, VOKA has recently started using ClickDimensions to send mailings. “We wanted to integrate those different databases in a data warehouse at VOKA, so that they could be available to the management and all employees at all times. Thanks to those uniform data, everyone can now make well-structured and correct decisions”, says Erwin Nagels.
“Next to reporting possibilities, we can also use Power BI to check the quality of all data. In this way, we can quickly detect which fields are missing in our CRM system. Another example is that we now can use ClickDimensions to send more targeted emails by analysing all those data beforehand. We notice the advantages of Power BI at really all levels.”
Key users train their colleagues
“For this Power BI project we selected two delegates per entity to cooperate with the Kohera consultants”, says Erwin Nagels. Kohera trained them thoroughly, converted the existing reports to Power BI and helped in developing the first complex reports.” Those key users now draw up reports for their own entity, after which they stimulate other users to further use those reports for the benefit of their own field of work. “By doing so, each field (account management, information and advice, files, advocacy,…) already has a central Power BI report that can be widely used within VOKA itself. The number of licences keeps increasing, we still get requests from new users. The interesting licence policy makes sure this remains financially feasible.“
User-friendly for each level
Katrien Moens, advocacy manager of VOKA was one of the first to use Power BI. “The developers of complex reports need some additional IT knowledge, such as knowing how to work with pivot tables in Excel. Knowledge of different databases and how they are interconnected is crucial as well. But no matter which function you want to use; Power BI is and remains very user-friendly. All end users learnt the ins and outs of the tool very quickly.”
“Now we draw up reports for our different teams, so that everyone can follow up his annual results, both operationally and financially. This approach seems to work very well, and we notice that a lot of requests are made to obtain additional reports, which indicates that our employees use the software almost on a daily basis.”
Different projects, one contact person
VOKA appeals to a number of companies of Crosspoint Solutions, a company from the Cronos Group, of which Kohera is part as well. Three companies support VOKA in managing its different applications. “Infront manages our CRM system, whereas Arxus takes care of hosting our server infrastructure. Kohera is responsible for managing our Power BI applications. That unique cooperation was the key to the success of this project”, says Erwin Nagels. “It guaranteed a flawless communication and was highly cost-effective.”
Frederik Aerts, Senior BI Consultant and Team Lead of Kohera was in charge of the BI project. “That flawless communication is indeed unique for a project, in which different parties are involved. The real challenge lay in converting the old reports to Power BI and creating awareness of the platform’s possibilities. VOKA knew exactly in which direction it wanted to go, but it did not know that the range of possibilities was so extensive. We have shown them different ways to obtain interesting insights. Now VOKA is perfectly capable of filtering the information itself and making data-based decisions.”
Cookie | Duration | Description |
---|---|---|
ARRAffinity | session | ARRAffinity cookie is set by Azure app service, and allows the service to choose the right instance established by a user to deliver subsequent requests made by that user. |
ARRAffinitySameSite | session | This cookie is set by Windows Azure cloud, and is used for load balancing to make sure the visitor page requests are routed to the same server in any browsing session. |
cookielawinfo-checkbox-advertisement | 1 year | Set by the GDPR Cookie Consent plugin, this cookie records the user consent for the cookies in the "Advertisement" category. |
cookielawinfo-checkbox-analytics | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics". |
cookielawinfo-checkbox-functional | 11 months | The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". |
cookielawinfo-checkbox-necessary | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary". |
cookielawinfo-checkbox-others | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other. |
cookielawinfo-checkbox-performance | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance". |
CookieLawInfoConsent | 1 year | CookieYes sets this cookie to record the default button state of the corresponding category and the status of CCPA. It works only in coordination with the primary cookie. |
elementor | never | The website's WordPress theme uses this cookie. It allows the website owner to implement or change the website's content in real-time. |
viewed_cookie_policy | 11 months | The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data. |
Cookie | Duration | Description |
---|---|---|
__cf_bm | 30 minutes | Cloudflare set the cookie to support Cloudflare Bot Management. |
pll_language | 1 year | Polylang sets this cookie to remember the language the user selects when returning to the website and get the language information when unavailable in another way. |
Cookie | Duration | Description |
---|---|---|
_ga | 1 year 1 month 4 days | Google Analytics sets this cookie to calculate visitor, session and campaign data and track site usage for the site's analytics report. The cookie stores information anonymously and assigns a randomly generated number to recognise unique visitors. |
_ga_* | 1 year 1 month 4 days | Google Analytics sets this cookie to store and count page views. |
_gat_gtag_UA_* | 1 minute | Google Analytics sets this cookie to store a unique user ID. |
_gid | 1 day | Google Analytics sets this cookie to store information on how visitors use a website while also creating an analytics report of the website's performance. Some of the collected data includes the number of visitors, their source, and the pages they visit anonymously. |
ai_session | 30 minutes | This is a unique anonymous session identifier cookie set by Microsoft Application Insights software to gather statistical usage and telemetry data for apps built on the Azure cloud platform. |
CONSENT | 2 years | YouTube sets this cookie via embedded YouTube videos and registers anonymous statistical data. |
vuid | 1 year 1 month 4 days | Vimeo installs this cookie to collect tracking information by setting a unique ID to embed videos on the website. |
Cookie | Duration | Description |
---|---|---|
ai_user | 1 year | Microsoft Azure sets this cookie as a unique user identifier cookie, enabling counting of the number of users accessing the application over time. |
VISITOR_INFO1_LIVE | 5 months 27 days | YouTube sets this cookie to measure bandwidth, determining whether the user gets the new or old player interface. |
YSC | session | Youtube sets this cookie to track the views of embedded videos on Youtube pages. |
yt-remote-connected-devices | never | YouTube sets this cookie to store the user's video preferences using embedded YouTube videos. |
yt-remote-device-id | never | YouTube sets this cookie to store the user's video preferences using embedded YouTube videos. |
yt.innertube::nextId | never | YouTube sets this cookie to register a unique ID to store data on what videos from YouTube the user has seen. |
yt.innertube::requests | never | YouTube sets this cookie to register a unique ID to store data on what videos from YouTube the user has seen. |
Cookie | Duration | Description |
---|---|---|
WFESessionId | session | No description available. |