This event has passed.

Automated data preparation and analysis with R

Name: Automated data preparation and analysis with R
Start: 2023-12-04T00:00:00+01:00
End: 2023-12-05T23:59:59+01:00
Location: Nuremberg

4. December 2023 - 5. December 2023

Further training for up-and-comers in quality, production and logistics and for anyone who regularly deals with data

This training is carried out together with our cooperation partner Grundig Academy. The flood of data is constantly increasing in day-to-day business. Data records need to be processed quickly, visualized and searched for anomalies in order to derive suitable measures. Particularly in the areas of quality, production and logistics, the data records are often constantly updated with consistent structures. The handling of spreadsheet programs can take up a considerable amount of daily working time. In situations like these, scripts for data preparation and data analysis are used. This allows standard tasks to be completed quickly, conveniently and, above all, error-free. Scripts also allow best practices to be shared within a team. With the advent of freely available artificial intelligence, there are also constantly available helpers for creating these scripts. The insights gained from the analyses also often need to be summarized in reports. Instead of generating these by “copying and pasting” from one document to the next, these reports can be made available by script or even fully automated. This not only saves working time and avoids errors. It also opens up new possibilities for process monitoring and control.

Target group

This training is aimed at

Anyone who works with data on a daily basis. The more time you spend using spreadsheet programs every day, the greater your benefit will be.
Experts in quality, production and logistics, but also in controlling and other areas that use ever larger and more complex data volumes.
Students and anyone who wants to prepare for tasks in order to be able to carry out data analyses effectively, quickly and reliably.

Prerequisites

You will get the most out of this training if you have a lot to do with data and data analysis in your day-to-day business and are familiar with spreadsheet programs. Statistical or knowledge of programming or macro languages is not required.

To participate in this course

you need your own laptop
have installed the R language, ideally RStudio, and
have registered with ChatGPT or similar language models.

After registering, you will receive the necessary instructions. You may need the approval of your IT department or your own laptop for these installations. R, RStudio and access to ChatGPT are available free of charge.

It is an advantage and useful for you, but not necessary, if you bring your own data set (for example, the production of a day or a week). You do not have to share this data set with others. It is helpful if you have the permission to talk about the structure of the data (column names, number of rows, …) and to show your evaluations to the participants.

Your benefit

Participants learn through extensive exercises to create scripts and reports independently, to adapt existing script blocks (such as those provided in help forums) for their own questions and to use large language models such as ChatGPT for the creation of scripts.

Fast and error-proof analysis of data
Create standard reports from complex data “at the touch of a button”
Free access to the best analysis tools and help forums
Use of artificial intelligence for everyday data analysis work.

This program is primarily aimed at employees of companies that

want to meet the challenges of digitization proactively and cost-effectively and who
recognized the increasing importance of handling data and want to “democratize” the skills required to do so.

The following skills are taught in the training:

Data preparation with R scripts, graphically and statistically
Creation of analysis reports using R-Markdown
Data preparation with the dplyr package
Create professional graphics with the ggplot package
Use of artificial intelligence and ChatGPT in data analysis.

Focal points

You will receive all data sets and scripts for the training. The training also deals specifically with questions from participants about their own data sets.

Expectations of the participants
“The light at the end of the tunnel”: ChatGPT creates a complete analysis script
Introduction to the use of R and RStudio
Data formats and functions in R
Read data into R and save results from R
Create your own functions
Basics of data preparation with dplyr
Basics of creating graphics with ggplot
Data analysis: creating, modifying and professionally documenting scripts
Create professional reports with R-Markdown
Outlook and demo: Web applications with R-Shiny
Processing a case study or your own data set.