There are 6 types of tableau filters. Understanding operational order of filters can of vital importance. This article is going to briefly explain the 6 types of filters and share 3 examples to differentiate the subtle details of different filters. Extract Filters and Data Source Filters applied on extract or…

In this article, I am going to discuss two ways of deploying the R Shiny App as a desktop app There are two ways of deploying the R Shiny Apps: Web Application Desktop Application Though the first method is convenient, and easy to share, it requires multiple approvals from IT/Finance…

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…