Two-day training: Manipulate data efficiently

Free up time for analysis by automating data manipulations

Business and data analysts often find themselves joining data files from multiple source systems before they can start their analyses. Some of these data manipulations are one-off actions, others need to be repeated several times over the course of a year.

As a result, many analysts will recognize that most of their working day is spent on the tiresome preparations for the analyses, rather than on the actual analyses and the presentation of the findings.  It is also work that is difficult to time-box ... how long will it take this time?

During the Cropland Seeds training you will learn how to leverage the programming language R to automate the data combination and transformation process, effectively freeing up time for analysis. We will also teach you how to analyze your own data using R and how you can share the conclusions with your colleagues, your "internal" customers.

 
Croplandseeds_icon_blauw.png

Goals

Thanks to this training:

  • you will learn to gather, combine, and transform your own data in a structured and automatic way

  • you will free up time in your working day to focus on what really matters: the analysis

  • you will make it easier for yourself to repeat analyses with new data

  • you will learn how to distribute analyses in the form of PDF reports, PowerPoint presentations, and HTML dashboards.


Target audience

Cropland Seeds targets analysts who deal with csv or txt files, Excel files, large or small databases, dashboards, etc. on a daily basis and who lose much time by (manually) updating and connecting source systems and files.

Ideally, you already have some experience with some form of programming.  For example, you may have already written a macro in Excel or you may have experimented with a scripting language (e.g., python, R, ...). Don’t worry if you’re not expert in any of this, a basic understanding of how a programming language works is all you’ll need!

You may find some inspiration here:

https://www.codecademy.com/learn/learn-how-to-code

https://www.datacamp.com/courses/free-introduction-to-r


fatos-bytyqi-535528-unsplash.jpg

What makes this training so special?

Cropland Seeds is a hands-on training. This means that you bring your own data and research question with you to Cropland Seeds. During the exercises, we guide you through the process of developing an analysis to answer that research question. You walk away from the training with a nicely formatted report that you can show to your colleagues.

In addition, we provide a cloud data science environment, where you can perform the exercises. You may continue to use our data science platform for up to 3 months after the course, free of charge. This way, you can revisit exercises, or maybe even regenerate your report with new data!

Cropland Seeds is very different from online trainings, in three ways. Firstly, we will assist you while you perform the exercises, so can ask questions and you never get stuck. Secondly, as seasoned data science consultants, we can also share our best practices and lessons learned. Thirdly, you get to work with your own data (no Iris or Titanic datasets at Cropland Seeds!). As a result, you do not only walk away with new knowledge and insights, but also with a report that you can show to your colleagues.


Price

The participation fee for this two-day program is € 1,749 excl. 21% VAT. This amount includes lunch and drinks during the course days.

In addition, you will receive a documentation folder that you can consult as a reference work and we will also provide you with 3 months complementary access to the Cropland Seeds data science platform.

Cropland grants an additional discount of 5% per extra participating colleague on the total amount, with a maximum discount of 20% (= 5 participants or more) during the same calendar year.

Instructor

Jeroen Claes (° 1986) left Academia in October 2016, after a period of eight years as a researcher at the University of Antwerp and K.U. Leuven. Since then he has been working as a full-time data scientist at Cropland, where he focuses on analysis, modeling, and reporting with R. But nothing could ever stop him from teaching. In 2018 he taught a course in statistics with R at the Université Catholique de Louvain (Louvain-La-Neuve), after previous teaching assignments at the Spanish departments of Ghent University and CVO Kempen. As a teacher, Jeroen prefers hands-on, interactive sessions, in which the students expand their own knowledge by working with the subject matter themselves.

 

Location and venue

  • Berchem (Antwerpen)

Dates

There will be three Cropland Seeds trainings in 2019:

  • Thursday 25 & Friday 26 April

  • Thursday 23 and Friday 24 May

  • Thursday 19 and Friday 20 September

The number of participants to each course is limited to 10. The training will be organized in English, except when the entire group speaks Dutch fluently, in which case the courses will be in Dutch

 

Programme 

  • 8h30 Reception, registration, and coffee

  • 9h00 Start training

  • 12h30 Lunch

  • 17h00 End training

Module A

  • What is R? What is RStudio?

  • The cloud data science environment

  • Programming 101:

    • Objects, variables, functions, and data types in R

    • How to use R as a calculator

    • Installing and loading packages

    • Importing and exporting data

    • Data frames: the R alternative to spreadsheets

Module B

  • Data manipulation with tidyr, dplyr (and some stringi)

Module C

  • Plotting with ggplot2 and interactive HTML plots with plotly

Module D

  • Reporting: rmarkdown (docx, PDF, PowerPoint) and flexdashboard (HTML-dashboards)