Week 5

On the weekend and this week our team focused especially on enriching our database. We continued the manual one by one research from last week. Due to the fact that our database has tons of tuples, we used our statistical knowledge to save time. Therefore we will use a spot check out of our database and then grossing up this number to the actual population. So we started and searched the information we were asked for. Even though it was just a spot check, it took us numerous hours because it still was a large number of users.

After the missing information was found and the manual research was completed, we added our additional information to our database and further to the business analytics tool. The database was now enriched and ready for the first query shoot.

After a short discussion with Diego, the software developer of Transifex, we had some more inputs to continue our work. We now separate the projects in opens-source and proprietary projects. Finally, we set the five different costumer group:

• Paying customer

• Open Source costumer

• Downgraded costumer

• Trial customer

• Trial expired customer

Now we analyze our database with Access/Excel (one-dimensional) and Microsoft Business Analytics (multidimensional).