R with RStudio forms a great duo for reporting. Thanks to a special source code, a R Markdown file, we combine programming blocks (the R language) with a text (the Markdown language). It is possible to create a report without even seeing the code in the text. As in a show, the entire technical team, remains behind the scenes. Only the results - images, tables, charts and maps - occupy the scene with the text.
links to demos:
Like Word or a PowerPoint presentation, the document includes titles and divisions, bold and italic passages, web links, and more. Unlike Word or a PowerPoint presentation, tables and figures are automated because they are part of the calculations and modeling hidden in the document.
In the process, the data is imported: spreadsheets, CSV, SQL, web, Spark, etc. Just run the analyzes: clean, filter, sort, group, aggregate, select, add, etc. The R language is designed for descriptive statistics analysis and * machine learning * algorithms. The results can also come from other languages including Python or SQL. The big work can be done downstream and the finishing is done in RStudio. Once everything is modeled, transformed or integrated, all that remains is to generate tables and figures to finalize the report. With a stand-alone R Markdown file, automation makes it easy to update or adapt for a new month, for example.