dashboards | Responsive dashboard templates 📊✨ | Dashboard library

To answer your workflow questions

1. rmarkdown::run("filename.Rmd", shiny_args = list(launch.browser = TRUE))

is what you can use, which uses a shiny argument, which will render your Rmarkdown file and send it directly to the browser when ran. answer found here

1. in your chunks, you want the eval=FALSE/eval=TRUE which tells R to evaluate the chunk or not. You can also use echo=FALSE to hide code in the chunk from displaying. Rstudio has added a GUI option to easily select these options with a click of a mouse

Where only the selected chunk I chose to knit, was actually knitted(1 plot instead of 2.

Prometheus doesn't implement it's own authentication|authorization.

Your best approach is to secure access to all host(s) running all software and, in this case, to the hosts running these Docker containers and all targets that you scrape etc.

All cloud providers provide ways by which you may limit access to the resources you create with their platforms. You'll want to become familiar with your preferred platforms' mechanisms and you should establish confidence, in part, by proving to yourself that you're able to restrict access to your services when you deploy then to these platforms.

Perhaps start with a simple test web site, secure it, then test that it is secure. Once you're confident in doing this, deploy your Prometheus services.

See this document on Prometheus security

Query parameters are sent as strings. Therefore it needs to be casted to assign to a number type.

Use plotlyOutput instead of plotOutput and add library(plotly)

1.- In case query speed is a must, loading the data into BigQuery instead of setting up an external data source would be the most efficient way. Nevertheless, there are some things you can do to improve BigQuery, or BigTable performances.

2.- This connector is still in the Beta stage, and has some performance considerations. We should also take into consideration that BigTable is a noSQL (non relational) database and is not intended for SQL queries. In case you are exploring the data model you want to use in your application, I recommend you consider all these options and choose the one that fits better with your needs.

3.- I would say it is not a good choice if you want to query your data using SQL. Understanding de non relational architecture of BigTable, the most effective way to read your data would be sending read requests. You can find some code samples about this, in different languages in the official documentation.

You can do this with a Guard. Here is an example.

Power BI's strength is data visualisation, and it is likely to be well suited for for using on top of you retail data warehouse.

I'm not sure which research paper you are referring to, but Microsoft has been topping Gartner's Magic Quadrant for Analytics and Business Intelligence Platform for several years now, followed by Tableau and Qlik. If you are interested in reading further around the various platforms, you can download from https://info.microsoft.com/ww-Landing-2021-Gartner-MQ-for-Analytics-and-Business-Intelligence-Power-BI.html?LCID=EN-US

Power BI does not require SSAS or SSRS to run. If you already have SSAS, Power BI can use SSAS as a data source, and it works very well with a live connection, alternatively you can model the semantic layer directly within Power BI itself. Power BI, especially now Paginated reports are included is seen as a cloud based alternative to SQL Server Reporting Server

Use align = "center", as shown below.

You were almost there: