Hi All! Kembali lagi pada modul data visualisasi bagian ke-2.

Kita akan mengenali lebih dalam berbagai visualisasi jenis data dan tujuannya.

Ada banyak sekali jenis visualisasi data, dari yang sederhana hingga yang kompleks. Setiap jenis visualisasi biasanya lebih tepat digunakan untuk suatu tujuan tertentu. Secara garis besar, ada empat tujuan visualisasi yang disampaikan oleh Andrew Abela sesuai gambar berikut.

Berikut penjelasannya:

1. Perbandingan/Komparasi

Jika ingin membandingkan suatu sekumpulan nilai dengan nilai lainnya, ingin melihat mana yang lebih besar, mana yang lebih tinggi, mana yang naik, dsb. Untuk data yang terkait dengan waktu, visualisasi yang digunakan biasanya berupa line-chart. …


Source:https://www.1point21gws.com/

Hi all! Welcome back!

In analysing the data, we often use data visualization to understand the characteristics inlcuding trends in our data.

One of the libraries in python that is commonly used for data visualization purposes is matplotlib.

So, let’s start!

Pengenalan Dataset

Pertama, kita akan membuka data dari:

‘https://dqlab-dataset.s3-ap-southeast 1.amazonaws.com/retail_raw_reduced.csv'


SCALAR VS AGGREGATE FUNCTION

Functions are methods used to perform data operations on the database. These operations can be numerical calculations such as sum, count, avg, etc; or non-numeric operations such as string concatenations and sub-strings. SQL functions can be divided into 2 categories, namely scalar functions and aggregate functions.

Scalar functions in SQL are used to return a single value from a given input value, while aggregate functions in SQL are used to perform calculations on a group of values ​​and then return a single value. So, to make it easier to understand, let’s discuss and practice the functions of these two categories.

Scalar Functions (Numeric Value)


Hello all! I am starting my journey on exploring more about data analyst.

Let’s start with SQL!

What is SQL ?

SQL is the abbreviation of Structured Query Language, which is a standard computer language used to interact with a database system — or rather a Relational Database Management System (RDBMS).

So, user can insert, alter, update, searching, and delete data from database system using SQL

There are two categories of SQL Interaction:

  • Data Definition Language (DDL) -> various commands that have function to manipulate database structures, such as create (CREATE), change (ALTER), and delete (DROP) data storage structures, namely…

Welcome back on my journey of learning SQL with DQLab!

Let’s explore more !

Source: https://www.geeksforgeeks.org/

Suppose we got a sales transaction report of kotak pensil and flashdisk 32 GB for branch X. However, we found that the sales data table did not contain a product name column, so I was very confused to identify each product category.

If you are already proficient in SQL this will be easy. To get a product name column, you only need to combine the sales data table with another table in the database that contains product details including nama_produk, this merging mechanism is called JOIN.

Cindy Wanady

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store