David Custódio - Page 1

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...

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...

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...

5 Essential Google Analytics Metrics

In this small article I’ll cover some metrics that can give additional insights on your marketing efforts and how do you get to them on Google Analytics. Plus some example charts I use in Viur for visualizing them. Traffic Sources Traffic sources are the channels that you have open to the web. You want to keep them effective and constantly bringing new people to your site. You should pay particular attention to the organic ones (all but the paid search) and keep them growing week after week. You can achieve this by creating new (quality!) content and distributing it in a blog post, newsletter, and social media. If people love your content they’ll share. also, if you are...

How Facebook calculates the Engagement Rate

If you manage a Facebook page and you like to see how people are engaging with your content you’re probably a big fan of the Facebook Page Insights. It allows you, among other things to: View metrics about your Page's performance Learn which posts have the most engagement See data about when your audience is on Facebook One of the most useful metrics over there is the Engagement Rate that in a certain way allows you to see how popular or viral a post was. According to their help center the Engagement Rate is: The number of people your post reached who then liked, commented, shared or clicked on your post. If you do a quick google search you’...