The challenge

The client is a statutory levy board, funded by farmers, growers, and others in the supply chain in the United Kingdom. They run as an independent organisation (i.e., independent of government as well as commercial activity). The delivery of their services to levy payers is focused on six sectors, namely Pork, Dairy, Beef & Lamb, Horticulture, Cereals & oilseeds, and potatoes, which cover about 72% of total agricultural output in the UK.

Client company background

Realising the business benefits of Power BI that turns several unrelated sources of data into comprehensible, visually immersive, and collaborative insights, Cozentus’ client planned on migrating its existing BI dashboards from Tableau to PowerBI. They wanted to make the best use of their hundreds of dashboards through Power BI so that the market insights are readily available to existing and new farmers and growers.

BENEFITS REALISED BY THE CLIENT COMPANY

Optimised data storage

Power BI, being a cloud-based solution, brings only a certain amount of data, as compared to Tableau server that is an on-premise software. This requires higher memory and CPU availability on client machines. On the other hand, Power BI brought only the calculated and aggregated data with less CPU storage utilisation. This resulted in better performance of the reports and dashboards

Cost optimization

With a marked difference in the licence cost, Power BI proved to be much cheaper than the Tableau server which in turn helped customers reduce their overall IT cost.

Ease of operation

Cozentus’ ‘Pay-as-you-go’ model allowed the client to add and remove users as and when desired.

Seamless transition

Similar dashboards and application features, both in terms of its lookand-feel and functionality as Tableau helped in a smooth transition from existing dashboards to Power BI dashboard

SSBI

Ease of use and self-service BI (SSBI) enabled quicker and better adaptability for Power BI by business and technical users.

COZENTUS ADVANTAGE

Unlock operational productivity and business efficiency

Cozentus transforms supply chain by being your trusted business solutions provider innovating on your behalf with fluid collaboration, direction, and stability so you can continue progressing in today's highly dynamic world.

From beginning to end, we have your covered

Cozentus expertise across supply chain core areas and experience with blue chip organisations brings you accelerated delivery times, the ability to save cost and flexible skills accessed at any stage of your logistics value chain.

We offer a humanized end-to-end Client Experience

Cozentus provide you with real time communication, feedback and reassurance throughout the whole end-to-end experience - pushing the boundaries of innovative business solutions with an unrivalled humanized experience.

We elevate your customer experience

Cozentus’ credible leadership experience of over 25 years works with you throughout the digital transformation process, putting you on the path for efficiency and seamless customer relations.

SOLUTION OFFERED BY COZENTUS

Cozentus was onboarded to undertake the ‘feasibility study’ to ascertain if Microsoft Power BI can meet its client’s reporting needs, which were at that point in time achieved using Tableau. Subject to Microsoft Power BI functionality and the results of this feasibility study, the Customer was to decide on full-scale migration to PowerBI. While they ran Tableau as their main data visualisation tool, for the feasibility study, Cozentus initiated operations with Microsoft Power BI reporting and visualisation functionality. As a selected supplier for this exercise, Cozentus ensured the following requirements are met:

Build up to 100 dashboards existing in Tableau, in Microsoft PowerBi.
Ensure that the dashboards encompass all of the information and provide a similar slicing and dicing and filter functionality as available in Tableau.
Go Ensure that the dashboards refresh automatically.
Ensure that the dashboards are aligned with the client’s Office 365 company subscription.
Deploy the dashboards on external facing or websites while being aware of data and its security and confidentiality.
The clients requirement was such that that source database remains same and look and feel of the Power BI report matches with the Tableau report so that users do not feel any change and it should be as seamless as possible.
The Cozentus team owing to expiring Tableau licence has very limited time to complete this activity and could do it successfully

These reports were accessible to various users and only the relevant information was shared to users respective to the report or data level. The database refresh for the deployed reports was managed by Power BI gateway installed on a local on-premises server. The PowerBI reports and dashboards allow different report and data security levels, as well as differentiation of roles and permitted access levels attributed to them. Additionally, the users could also develop their own reports in the workspace and decide at any given point in time when a particular data could be shared with other users.

How Hundreds of Dashboards Were Seamlessly Transitioned to Power BI for an Independent Organisation in the UK