[Apache Superset] Topic #3, Visualization data from CSV data file

Hello, it's me again - Duc Nguyen (Duke)

Before starting this tutorial, you should have mastered the previous two tutorials in the Apache Superset tutorial series.

• Topic #1, What is Apache Superset used for and how to install it on Windows 11 here
• Topic #2, Superset ARCHITECTURE here

Okay, let's get started with today's topic: How to get data from CSV files and visualization them

First thing, you need to have sample data in CSV format, here I use insurance claim information data here

Okay, now let's import this CSV file into Superset and then visualize the data through charts.

Click the + button then find and select Upload CSV to database

and we have many settings here like Delimiter, Decimal Character, If Table Already Exists

Next, click the Edit icon button in the DucNguyen dataset and you will see the dialog box shown below

then click the Add item in the Calculated columns

CASE WHEN CLMSEX = 1 THEN 'Male' ELSE 'Female' END

Next, click the Create chart button in the Chart tab

And here is the result you get a pie chart showing the number of insurance claims by gender, the settings here are very easy to understand, you can refer to my settings in the image below

Do you have any questions? See you in the next topic!