Icon

Solutions

This directory contains 9 workflows.

Icon01_​Data_​Access 

Exercise 1: Data Access. In this exercise you access data available in different file types. The data that you read in this exercise is stored in the "data" […]

Icon02_​Data_​Merging 

Exercise 2: Join and Concatenate. In this exercise you combine data by concatenating and joining tables.

Icon03_​Data_​Cleaning 

Exercise 3: Data Cleaning. In this exercise you explore data, check the data for outliers, and handle missing values.

Icon04_​Data_​Transformation 

Exercise 4: Table Restructuring. In this exercise you change data structure by unpivoting columns to rows.

Icon05_​Data_​Manipulation_​optional 

Exercise 5: Data Manipulation. In this exercise you add a trasaction type and merge all data into one table.

Icon06_​DateTime_​Manipulation 

Exercise 6: Date and Time Manipulation. In this exercise you convert string values to Date&Time, extract granularities from Date&Time values, and filter […]

Icon07_​Data_​Aggregation 

Exercise 7: Data Aggregation. In this exercise you generate new columns by aggregating data by groups and create pivot tables that show aggregated values by […]

Icon08_​Visualization 

Exercise 8: Data Visualization. In this exercise you generate interactive views to visualize data, add a slider to filter the data, and change the colors in […]

Icon09_​Deployment 

Exercise 9: Deployment. In this exercise you write preprocessed data into an Excel file and to a database.