How We Turned Many Excel Files Into an Interactive Power BI Report about Latvia’s Export landscape

Dec 16, 2021

How We Turned an Excel Sheet Into an Interactive Report: Latvia Export Barometer.


ZoomCharts took part in a widescale project that created a full report of Latvia’s Export Barometer. This report focused on Latvia’s export shifts within the past 3 years to more accurately assess Latvia’s overall export growth.

The Latvia Export Barometer is intended to showcase Latvia’s export landscape to a wider audience, including the government sector, companies, and the general public. The interactive nature of the report, made possible by ZoomCharts, allows everyone to gain full comprehension of Latvia’s exportation process. The Latvia Export Barometer was publicly demonstrated during the Export and Innovation Awards’ closing ceremony and is available for public viewing online.


The Journey From Raw data to beautiful report

ZoomCharts received datasets from a variety of data and statistics suppliers and set out to clean up the data in preparation for importing it into Power BI. After discussing what story should the report tell and ensuring that it was not oversaturated with information while still being capable of engaging users, we input that data into Power BI. 

A report cannot be made more interactive than the data permits. If the data is one-dimensional and straightforward, there is no use in performing a drill-down to analyze the data deeper or look at it from different aspects. 


ZoomCharts custom visuals are known for their interactive approach to data visualization and analysis. We strive to provide stellar interactive charts through our custom visuals and report design services. 

If you would like to have your business data turned into highly engaging and productive reports, ZoomCharts offers a report overhaul service, where we can help take the next step into the world of BI.
Get better reports

See full report here


Subscribe to news

Subscribe to our newsletter and be among the first ones to receive updates about latest developments, releases and other useful information that will help you get the most of our visuals.

Power BI Waterfall Charts: A Detailed Guide

Do you know how to make a waterfall chart? Here are 7 tips you should know when building user friendly Power BI waterfall charts. Customize it to tell a data story that helps you make data driven decisions.

Read More

May 12, 2022

Announcement: Microsoft Applies ZoomCharts Solutions for Latest Product

We are excited to announce the collaboration between Microsoft’s latest product Dynamics 365 Supply Chain Insights – and technologies provided by ZoomCharts the Network and Map visuals.

Read More

Mar 28, 2022

Power BI Bar Chart

It is likely that, before hearing about Power BI, almost everyone’s first encounter with a bar chart happened all the way back in pre-school. After all,... Read More

Feb 14, 2022

How We Turned Many Excel Files Into an Interactive Power BI Report about Latvia’s Export landscape

How We Turned an Excel Sheet Into an Interactive Report: Latvia Export Barometer. ZoomCharts took part in a widescale project that created a full report of... Read More

Dec 16, 2021

Power BI Donut Chart

The donut and pie charts are some of the most ubiquitous charts around. Instantly recognizable by people who have very little to do with charts, every report... Read More

Oct 27, 2021

Improving UX with Power BI Custom Visuals

How do I make sure my Power BI reports end up getting used? The answer is – standardization. A quick Wikipedia search will tell you - standardization means... Read More

Sep 16, 2021