Using RSQLite package to make queries to a SQLite database.

Conectando a um banco de dados com SQLite/RSQLite, criando e consultando objetos de banco de dados a partir de um bloco de anotações R no Jupyter e usaremos ggplot2 para plotar os dados usando bibliotecas R.

Report of a project concerning database construction, management and manipulation that uses various .xml and .csv files from open sources with semi-structured and unstructured data. The analysis is visualised by RShiny dashboard.

Shiny Coffee app - keeps control of who made the most pots of coffee at the office :)

SQL in R with various packages

Convenient wrapper functions around the RSQLite package

As most of my projects involves getting data from multiple sources, SQL querying is important. This repos contain some of the SQL projects i have worked on together with R Markdown.

The European Soccer Database contains data on more than 25.000 national football matches from the best European leagues. The aim of this exercise is to present interesting relationships in R using explorative data analysis and visualization.

Mock data analysis to influence a business decision.

Text mining of customer reviews extracted from TrustPilot

Text mining project to analysis changes in customer perception of Airbnb due to pandemic

A next word prediction app ala Swiftkey