Statistician. Data Analyst. SQL Addict.

Hello, my name is Riza Purnaramadhan, I was born in 1999, I’m from Indonesia.

I am a graduate of statistics from Islamic University of Indonesia, and now waiting for graduation, and I am currently also working as a Data Analyst freelance worker at autocare services company. I love data science, data science is like my daily food, I’m very greedy to keep learning data, some of the skills I have about data analysis are such as Customer Segmentation, Overall Analysis, Growth Analysis, Burn Rate Analysis, Market Basket Analysis, Twitter Analysis, Exploration Data Analysis, Statistics Hypothesis, Data Visualization, Data Storytelling, etc…


A brief explanation

Lately, the Data Analyst profession is in great demand, even people who don’t have a data background are interested in it and want to switch to profession data analyst. In order not to find many mistakes in the field later, it is better if you first know the role of a data analyst before starting a career as a data analyst.

It is important to know the role of a Data Analyst before starting a career as a professional Data Analyst. Following are the roles of a Data Analyst:

1. Analyze complex data

A Data Analyst usually analyzes large and complex data. Usually, the…


Exploration Data Example in R using dplyr Package

Bismillahirrahmanirrahim, Assalamu’alaikum Warahmatullahi Wabarakatuh, pada kali ini saya ingin membahas tentang eksplorasi data di R menggunakan package dplyr.

Install dan Load Package

Tentunya package yang digunakan adalah dplyr yaitu package yang digunakan untuk manipulasi data, ketik pada r console Install.packages(“dplyr”) lalu tekan enter.

Load Package dplyr

Setelah tahap installasi selesai, langkah pertama adalah load package untuk bisa menggunakan package, ketikan perintah seperti berikut:

library(dplyr)

Memasukan data ke dalam R

Data yang saya gunakan adalah data sample super store training yang saya dapatkan dari perkuliahan hehe, datanya bisa kalian download disini, kemudian untuk memasukan data ke dalam R maka ketikkan perintah berikut :
training=read.csv(file = "D:\\Data_Tableau\\SampleSuperstoreTraining.csv")

lokasi filenya sesuaikan tempat kalian menyimpan file…


Mengenal Analisis Cluster

Bismillahirrahmanirrahim, Assalamu’alaikum Warahmatullahi Wabarakatuh. Pada kesempatan kali ini saya akan membahasa sedikit tentang analisis cluster.

Clustering

Pada dasarnya analisis cluster akan menghasilkan sejumlah kelompok. Analisis cluster merupakan salah satu teknik yang bertujuan untuk mengidentifikasi secluster obyek yang mempunyai kemiripan (similarity) karakteristik tertentu yang dapat dipisahkan dengan cluster obyek lainnya, sehingga obyek yang berada dalam cluster yang sama relative lebih homogen daripada obyek yang berada pada cluster yang berbeda. Menurut buku Supranto (2004) yang berjudul “Analisis Multivariat, Arti dan Interpretasi”, cluster analysis merupakan suatu teknik yang digunakan untuk mengklasifikasi objek atau ke dalam cluster yang relatif homogen disebut cluster. …


Initial SQL lessons a Data Analyst should know

Currently, if we observe, most of the job vacancies as a data analyst in companies who have implemented IT systems, require SQL as analysis tool expertise, therefore SQL skills are skills that must be mastered by someone who wants to work as a data analyst.

In this article, I intend to introduce an initial SQL lesson for someone who is looking for a career as a data analyst.

Table of Contents

  1. About SQL
  2. Types of SQL Commands
  3. Relational Database Management System (RDBMS)
  4. Query Example

About SQL

What is SQL?

SQL which stands for Structured Query Language is the standard computer language used for a database system — or…


A brief explanation and case examples

In this article I intend to briefly explain Prediction Using Monte Carlo Simulation with some examples of cases using Excel, remember that Excel is only a tool! The most important thing is how you can understand the concept well and dig deeper!

Table of Contents

  • What is simulation?
  • What is Monte Carlo Simulation?
  • Monte Carlo Simulation Algorithm
  • Case Examples

What is Simulation?

Okay, before going into the Monte Carlo simulation, we must first understand what simulation is.

There are several meanings about simulation which are essentially the same:

“Simulation is to imitate a real process, called a system, through a model to understand how the system…

Riza Purnaramadhan

Statistician | Data Analyst at Speedwork Indonesia | SQL Addict

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