PTO Tracker

-
I built this project using R. The project came from my friend need of tracking PTO so he can plan for vacation.


Project repo: https://github.com/Anhsnotes/PTOCalculation

Comments

Post a Comment

Popular posts from this blog

R and Shiny App, a path from data engineering to web app deployment in one language

-
Image
In data analytics, nowadays, R and Python are the most popular languages among data professional beside SQL. I am struggling myself to identify which language to focus. I also saw a lot of questions about this topic and there is no clear answer. The general idea is to pick one and be good at it then traverse to the other if needed. In my opinion, R and Python are pretty compatible in analytic field. Recently, this changed when RStudio came up with Shiny App. This allows us to create data layer and UI layer (HTML, Javascript) with only R. After that, without standing up a web server to house your application, you can publish your app to shinyapp.io and ready for consumption. With this, my love for R grew bigger than Python ... at the moment :D I have developed the following simple Guessing Game , deployed and ready for consumption within 30 mins. To my fellow developer coming from business side, it is true that you can now develop and deploy a web app, dashboard by yourself with R. Plea
Read more

PostgreSQL Date table

-
Image
Using recursive in SQL, I can create a sequence that make up a date table. Basic recursive With   recursive  a  as   ( Select   1   as  Num union Select  Num +  1 From  a Where  Num +  1  <  11 ) Select  *  from  a Postgres SQL bucket date to 5 mins interval WITH   recursive  dimdatecreator( date )  AS   (          SELECT  (to_timestamp( '2020-01-01' , 'YYYY-MM-DD HH24:MI:SS' ))  AS   date   -- Start Date          UNION ALL           SELECT   date  + interval  '00:05'           FROM    dimdatecreator          WHERE    date  <= (to_timestamp( '2020-01-31' , 'YYYY-MM-DD HH24:MI:SS' ))  -- End Date  )  SELECT   date ,         date_part( 'hour' , date )+ 1         AS  hr,         (date_part( 'minute' , date )/ 5 )+ 1   AS  bucket  FROM    dimdatecreator;
Read more