Here is present my expirience in data analysis and visualization using R based on course Analyzing and Visualizing Data With Excel.

I solved tasks from this course with next packages and libraries:

• manipualation and trasformation data using dplyr and tidyr libraries from tidyverse package;
• data visualization with ggplot2 library;
• make excel-like readable reports with conditional formatting (color, icons, sparklines) using formattable, sparklines, htmlwidgets;
• and finaly use bookdown for creating technical documents (like this) with R markdown.

Solving the objectives of this course helped me better understand how to convert data for further analysis, how to create pretty good and informative charts and tables. Hope you can find something useful for yourself as you browse through this work :)