icon icon

Tidyverse in R – effective data analysis, cleaning, and presentation

icon

Training process

Training needs analysis

If you have specific requirements regarding the training programme, we will carry out a training needs analysis for you. This will guide us on which aspects of the programme should receive greater emphasis, so that the training programme meets your specific needs.

What will you gain?

icon

Confident start with R and RStudio - You will set up R and RStudio step by step, so you can prepare your own working environment and start analyzing data faster without confusion or common technical roadblocks.

icon

Reliable data importing - You will learn how to load data from CSV files, Excel sheets, and databases, convert it into tibbles, and immediately inspect structure, missing values, and key summaries.

icon

Effective data manipulation - You will use dplyr to filter, select, sort, group, and summarize data with clear code that is easy to extend, reuse, and apply in your everyday analytical work.

icon

Tidying data without manual fixes - You will learn tidyr and turn messy datasets into tidy structures without tedious spreadsheet editing, making your data ready for analysis, reporting, and further processing.

icon

Clear charts with ggplot2 - You will build bar, line, scatter, and box plots, then customize them so your analytical results are easier to explain and more convincing for both business and technical audiences.

icon

Combining multiple data sources - You will learn how to join tables safely with different types of joins, helping you create richer datasets and avoid common mistakes that often appear when merging information.

icon

Hands-on real-world cases - You will practice sales analysis, survey data cleaning, and dashboard creation, so after the course you can transfer the techniques directly into your own analytical projects.

icon

Reporting and presenting results - You will learn to prepare analyses and dashboards in RMarkdown, allowing you to present results in a structured way and reduce the time needed to create reports for your team.

Training programme

1. Introduction to the R Environment and Tidyverse

  • basic information about the R language,
  • installation and configuration of the environment (R, RStudio),
  • what is tidyverse and why is it worth using?
  • discussion of the key tidyverse packages (dplyr, ggplot2, tidyr, readr, tibble).

2. Loading and preparing data

  • loading data from CSV files, Excel, databases,
  • transforming data into tibbles,
  • data inspection: overview, filtering, summaries.

3. Transforming and manipulating data with dplyr

  • selecting and filtering data (select(), filter()),
  • sorting and grouping data (arrange(), group_by()),
  • creating new variables (mutate()),
  • summarizing data (summarise()),
  • joining data sets (join() – left, inner, right, full joins).

4. Tidying data with tidyr

  • separating and combining columns (separate(), unite()),
  • transforming data format (pivot_longer(), pivot_wider()),
  • working with data in tidy data form.

5. Data visualization with ggplot2

  • the philosophy of creating charts in ggplot2 (grammar of graphics),
  • creating bar, line, scatter, and box plots,
  • customization of charts: titles, colors, styles,
  • faceting – creating grids of charts for different categories.

6. Practical projects and case studies

  • Project 1: Sales analysis and trend visualization,
  • Project 2: Cleaning and transforming survey data,
  • Project 3: Building an analytical dashboard in RMarkdown.

What are the prerequisites for participating in the training?

icon

Basic computer skills - You should be comfortable installing software, working with files and folders, and using your operating system so you can set up the R environment and training materials smoothly.

icon

Understanding tabular data - You should understand columns, rows, headers, and data formats, because these ideas will be used throughout the course when importing, cleaning, and analyzing datasets.

icon

Basics of data analysis - You should know core analytical concepts such as filtering, sorting, grouping, and summarizing, so you can follow the logic of the operations performed in tidyverse more easily.

icon

Readiness to work with code - You should be willing to write and run simple text-based commands, even if you have never programmed before, because the training is built around hands-on work in R.