In the realm of digital marketing and media campaigns, establishing a robust data infrastructure is crucial. There’s a common misconception that the role of an analytics team is primarily about cleaning data. However, their real value lies in building a solid data infrastructure using ETL (Extract, Transform, Load) tools like Funnel or Supermetrics, and warehousing this data in solutions such as BigQuery. This foundational work ensures that when client onboarding begins, the process is seamless and efficient, allowing campaigns to go live with accurate and actionable reporting....

So you are looking at numbers everyday. These can be in excel sheets / google sheets while cleaning data or trying to get some insights out of the tables in various dashboards you see daily. These numbers might be currency , rates or just volume of any metrics you want to track. So how would you find the outliers across these tables, the best peforming KPI’s , correlations between various metrics....

This R shiny app is for all the home chefs out there looking to try different recipes, especially now that we are all social distancing and looking at ways to keep us sane! (Yes, cooking is a form of meditation wherein the end, you have something to eat :D). From a database of 28000 + recipes, just enter the ingredients you wish to filter on and the type of cuisine and you will see all the recipes with your specified ingredients from your favorite cuisine!...

Most of the shiny apps have tables as the primary component. Now lets say you want to prettify your app and style the tables. All you need understand how tables are built using HTML. This is how the default datatable looks like in the app. In order to build the html table I have used a function table_frame which can be used as a container in DT::renderdatatable. This function basically uses htmltools....

Tables are very much the standard way of representing data in dashboard along with visualizations. Wouldnt it be more useful if you could edit the values in the tables to trigger some calculations and update the values on the fly . These can be used for adjusting allocations or budgets in a project. Libraries The libraries which we will be using are shiny for the app itself, dplyr and DT for displaying and editing the tables....