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.
Introduction
What is R?
Discover the analytical aspect
The business intelligence side of R / RStudio
The areas of use of R
Discover RStudio
Install RStudio
Configure RStudio
Use the console
Install a package
Use of aids
Discover the Markdown
The variables
The functions
Calculations
Evaluate flow conditions and controls
curls
Create custom features
Calculate the execution time
Data structure: matrix
Data structure: ts
Data structure: Date and time
Data structure: factor
Work environments
The vectors
The lists
Matrices
DataFrames
Adapt in R / RStudio spreadsheet operations.
Adapt the spreadsheet functions to R / RStudio.
Import and export data (spreadsheet versus R / RStudio)
Exploit the best of both software.
Importing data
Exporting data
Selection and grouping of data
Using tidyverse for more efficiency
Tidyverse modules: dplyr, ggplot2, tibble, readr, tidyr, purrr
Data preparation
Import (and export) datasets.
Understanding the data (Explore and visualize)
Process missing values
Process outliers.
Model: select, filter, sort, modify, add, delete.
Manipulate categorical data.
Manipulate time series.
Produce PDF, HTML, etc. reports
Realization of graphs with R software
Customize graphs with R software
Draw maps with R software
Python Training for Data Science
→ R Language Course: RStudio, Reporting
→ Python Training – Data Science (Numpy Pandas Matplotlib)
📄 Download course outline (PDF)
Registration detailsFR
« Je tiens à vous remercier tous les deux d’avoir offert à mes ressources une excellente formation COBOL au cours des trois derniers jours.
Mamadou, merci d’avoir été si accommodant malgré le court préavis et d’avoir envoyé votre formateur à Gatineau pour ce cours personnalisé.
Nous avons hâte de poursuivre notre collaboration pour de futurs besoins de formation. »
(Traduit de l’anglais)
EN
“I want to thank you both for providing my resources with excellent COBOL training over the past 3 days. Mamadou, thank you for being so accommodating on such short notice and for sending your facilitator to Gatineau for this customized and personalized training course. We look forward to continuing our partnership for future training needs.”
FR
« Mamadou est venu nous aider à réorganiser notre panneau d’arrêt via un outil de rapport, Crystal Reports. Mamadou a réussi avec succès le travail de précision, au pixel près, puisque nous voulions un rapport similaire au design graphique original. Il nous a aidés à découper le projet par cycle et à intégrer le rapport à notre logiciel corporatif. La qualité que nous avons appréciée était le souci du détail et la constance. Mamadou a été très professionnel et connaît plusieurs autres technologies. Merci. »
EN
“Mamadou helped us reorganize our stop panel using a reporting tool, Crystal Reports. He successfully delivered precise, pixel-perfect work,
as we needed a report that matched the original graphic design. He helped us break the project down into cycles and integrate the report
into our corporate software. What we appreciated most was his attention to detail and consistency. Mamadou was very professional and
is knowledgeable in many other technologies. Thank you.”
(Translated from French)
FR
« Ce fut un plaisir de faire affaires avec Doussou Formation. Ce qui fait LA différence est le service personnalisé totalement à l'écoute des participants ainsi que l'adaptation aux besoins de formation. Flexibilité / Adaptabilité / Professionnalisme / Courtoisie. Merci ! »
EN
“It was a pleasure doing business with Doussou Formation. What truly makes THE difference is the personalized service, fully attentive
to participants, as well as the ability to adapt the training to their needs. Flexibility / Adaptability / Professionalism / Courtesy. Thank you!”
(Translated from French)