Have you ever run into the following warnings? If yes, you need to compile the R source code to binary (two type of R packages, binary/source). Then you need to have RTools installed. Select your Rtools based on your R version.

Reactivity is one of the most important and confusing concepts of R Shiny Programming. This article is going to explain the definition and different between: Reactive : define reactive expression that is impacted by input Observe : similar with print function, which allow the user to observe what is happening…

As a programmer, data scientist, or anyone who write code sometimes, you should not be unfamiliar with ‘Bugs’. Often, people tried to avoid them as much as possible, however, it is impossible. The best approach would be, to understand what are the typical bugs and tried to avoid them in…

How many times that the code does not behave the way that you expected? This article will keep track of the hidden mistakes that I’ve struggled with. Hope it will be helpful to you, too. ifelse() Supposing one retail chain decided to increase the price of its ice cream by 10%…

In the last post SQL 101, we’ve discussed creating a database/table and query data. Let’s keep exploring SQL in this chapter Parameter and Stored Procedure Stored Procedure could be compared to functions in other programming languages. …

When I learn something, I like to summarize the structure of the knowledge so that I can focus on the essential instead of falling deep into the rabbit hole. What is SQL? SQL is a language to operate databases; it includes database creation, deletion, and query. SQL is an ANSI…

Here I am going to create a list of the most frequently used tableau functions. Hope it could be helpful to Tableau Beginners. Function Fixed Calculation Format 1. Color Code…