David Custódio - Page 2

Key Performance Indicators

Anyone working on projects or an organization surely has heard of KPIs - Key Performance Indicators. Some even contribute to their calculation and are evaluated by it. What are Key Performance Indicators and why are they useful? KPI is simply the name given to a metric that is used to measure certain factors that are crucial to the success of an organization. Each KPI is usually associated with a goal or objective to be achieved. Regular determination of the value of KPI intends to measure the degree of progress towards objectives and their evolution over time: Are we moving in the right direction? Will we achieve the target if we continue? The KPIs can differ from organization to organization since...

Taking the most of databases without SQL

Small Data still has a major role in company's day-to-day activities and databases are still here to stay. Database engines are more powerful than ever and handle really well calculations, so why should we not take the most of what they have to offer? fig 1 - a database schema with its tables and columns Viur has a feature that lets you perform advanced calculations and/or apply functions over your data without having to know any SQL or scripting language. You can use your table columns to create new attributes that are called “Formulas”. When composing a new Formula you can use mathematical operators: +: Addition -: Subtraction * : Multiplication / : Division ^ : Power and functions: ABS: Absolute COUNT: Count COUNTD: Count Distinct...

Measuring Customer Satisfaction with Google Analytics

In a global market where competition is tight, you must make sure your customers are happy. There are many ways to measure customer satisfaction, and we found one that is quick to implement, uses a platform that almost every site uses and is free. It even works with Net Promoter Score if you want, as we explain below. In order to put this example in practice, you must have Google Analytics on your site. You can learn here how to set it up. Without further ado this is how we did it: Where we wanted to know if the user liked something we placed some thumbs up and thumbs down buttons. Whenever the user clicks one of the thumbs a...

New Features

Our vision is to create a product so simple that anyone can use, hiding all the complex processes in data analysis. This week we focused on improving the user onboarding. The biggest change is the “help” button that allows you to immediately authorize Google Analytics and add widgets to the dashboard in a heartbeat. This help page also has other topics regarding database widgets and data exploration. With time, we will add more useful topics, and refine the existing. Clicking the help will open a friendly modal: Feel free to give a thumbs up! Another big new feature is that you can now edit widgets from the dashboard. Editing the widget will open it in the “Widget Creator” where you...

Launch Day + Analytics

The big day has come, and we finally released the Beta version of Viur for a selected few. This post describes what tools we used and how we used them. Since day one we have a subscription form on the landing page to capture early adopters. This allowed us to have a good user pool to start working as soon as we had something to show. For this, we used Mailchimp, which has a generous free tier and allows you to set up email campaigns and track opens and clicks among other things. In the main site we use two awesome tools: Google Analytics to track specific metrics (like bounce, exit rate,etc...), goals and specific events we...