Dana Annisa Riefina

Apr 17, 2021

Forecasting Monthly Electric Production using ARIMA and Prophet (Part 1)

The Data of industrial production of electric and gas utilities in the United States were recorded from the years 1985–2018. This data measures the real output of all relevant establishments located in the United States, regardless of their ownership, but not those located in U.S. territories. We can find the…

Timeseries

9 min read

Forecasting Monthly Electric Production using ARIMA and Prophet (Part 1)

Mar 28, 2021

SQL Challenge from DQLab Project

This is one of SQL project in DQLab. There are four tables: ms_pelanggan, ms_produk, tr_penjualan, tr_penjualan_detail with fields and data type written below. Show list of products from ms_produk table which has price between 50000 to 150000. Column that must be displayed: no_urut, kode_produk, nama_produk, and harga. SELECT no_urut, kode_produk…

Sql

6 min read

Mar 11, 2021

E-commerce Customer Segmentation

Problem Definition During the Covid-19 pandemic in 2020, total sales in e-commerce increased by 37%. Due to increasingly fierce competition between competitors, you and your Product Manager discussed how to stay afloat and compete in e-commerce industry. After that, you choose to create innovation or offers for users to keep choosing you…

Data Analysis

9 min read

E-commerce Customer Analysis with RFM and K-Means Segmentation