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
→ R Language Course: RStudio, Reporting
→ Python Training for Data Science | scientific python
→ Python Training – Data Science (Numpy Pandas Matplotlib)
Formation en ligne
Vidéos de formations sur les logiciels en bureautique
“ I want to thank you both for providing my resources some excellent training(Cobol) 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 customised and personalised training course. We’ll look forward to continuing our partnership for future training needs. “
“J’ai grandement apprécié les méthodes d’enseignement du prof. Le fait que nous soyons un petit groupe a grandement facilité les apprentissages. Il s’adapte à son audience et les exercices sont formateurs. Je recommande fortement. “
“ 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!“