Introducing Dashboard filters

This week we introduced a new feature that will revolutionize the way you use your dashboard. With the dashboard filters, you can change the data that is used across a dashboard, filtering it for a particular value or date range. You will be able to change the time interval but also drill down to narrow the scope of your data with just a flick of a switch. Check out how easy it is to create and use filters in these two short videos: Creating a Date Range filter Creating a text filter from an SQL query Viur is easy Business Intelligence....

Read More »

Meet The Team

What sort of minds can make sense of the myriad of data and analytics platforms and cloud services available to business owners today? What sort of minds can simplify and aggregate those platforms into one simple interface? Viur didn't happen overnight, but from the dedication and hard work of a team who complement each other, making sure all the right slots are filled, and the right questions are answered. Discover the people behind Viur, making business intelligence easy for your business. "The secret of getting ahead is getting started." - Mark Twain Based in Coimbra in central Portugal, Viur is the brainchild of Pedro Almeida and David Custódio, who started developing the platform in 2013. Pedro has a background in...

Read More »

Analysing Crude vs Petrol prices

Crude price is at an all-time low. It has been falling since 2012 but the car owners perception is that petrol prices don’t always accompany this fall. For this analysis, I used crude and dollar CSV data sets you can find with a simple google search and my car’s consumption data set that I have used in other blog posts. By the way, you can learn how to use CSV files in this post. Let’s load the data in Viur and let’s see what we can do with it. The first thing that I want to see the Crude Price evolution. Impressive rise and fall! Now I’m going to check the price per liter to...

Read More »

Connecting to a Heroku Postgres database

Heroku launched what they call the “SQL database service for developers”.  It relieves the burden of database management by providing a set of features and tools that save a lot of time and effort.  These Heroku Postgres databases can accept outside connections so you are able to connect them to the business intelligence tool of your choice. Let me show you how you can quickly connect a business intelligence tool to a Database. On your Heroku Dashboard choose “Databases” Then choose the Database you want.  Click to get the connection details. Now, we have to configure this database in a business intelligence tool. I’ll show you how to do it in Viur. Go to the...

Read More »

Starting with CSV data analysis

Every day we produce huge amounts of data that can be used by apps and other services. Personal finances, fitness apps, home control & automation, work loggers… There is an app for pretty much everything we can think of. Some applications that we use every day allow us to export data as a CSV file. This is great because it means we can explore data with a finer detail and eventually get better insights than those that most applications give by default. All we need is a proper Data Visualization tool that can take these CSV files and lets us play a bit with the data.  So, let me show you how Viur works with CSV data. For...

Read More »