Faisal Afif – Medium

Published in

·Pinned

Intermediate SQL (Part 1)

A beginner guide for learning SQL from scratch So far we have already learned some basic SQL queries, such as SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, and LIMIT. If you would like to review them, please visit this Introduction to SQL series. Introduction to SQL (Part 1) A beginner guide for learning SQL from scratchmedium.com The intermediate SQL series will cover…

MySQL

9 min read

MySQL

9 min read

Pinned

Logistics and Supply Chain Analytics by Utilizing Tableau Dashboards

This article is part of Business Analytics course final project — Pacmann. Introduction Have you ever wondered what happens to your order after you click “place order” on an e-commerce website or marketplace? In e-commerce, supply chain refers to the network of organizations and processes involved in getting products from manufacturers…

Tableau

16 min read

Tableau

16 min read

Pinned

Sales Strategy Analysis on New Product Launch

Background Pens and Printers has been providing high quality office products to large organizations since 1984. As the way in which consumers buy products is changing, the sales strategy have to change too. New Product Sales Methods Six weeks ago, a new line of office stationery has been launched. …

Data Analysis

14 min read

Sales Strategy Analysis on New Product Launch

Data Analysis

14 min read

Published in

Data Science Indonesia

·Pinned

Introduction to SQL (Part 1)

A beginner guide for learning SQL from scratch SQL, also known as Structured Query Language and pronounced as “sequel”, is a programming language designed to query, analyze and transform data from a relational database. Due to its simplicity, SQL is one of the most powerful and widely used tools in…

Sql

5 min read

Sql

5 min read

Published in

Data Science Indonesia

·Oct 16

Introduction to SQL (Part 3)

A beginner guide for learning SQL from scratch In this section, we will explore aggregate functions in SQL that allow us to summarize data on a selected column. These functions can be used to answer questions like: “How many customers churned this week?” “What is the total revenue for each…

MySQL

5 min read

MySQL

5 min read

Published in

Data Science Indonesia

·Oct 9

Introduction to SQL (Part 2)

A beginner guide for learning SQL from scratch Why is there a cinema photograph in SQL tutorial? You might have this question on your mind. Today we’re going to solve several SQL exercises about movie from SQL Bolt. Let’s get started. In SQL, you can use the WHERE clause to…

MySQL

6 min read

MySQL

6 min read

Sep 13

Data Wrangling dan Data Analysis pada Olist Ecommerce Dataset

Tulisan ini merupakan salah satu outcome final project course SQL & Data Wrangling — Pacmann. Objectives Melalui tulisan ini akan dipaparkan hasil proses data wrangling dan data analysis dari dataset Olist Ecommerce yang dapat menjawab pertanyaan berikut: Top 5 region atau states dengan revenue terbesar, apa saja? Bagaimana revenue trend di…

Data Wrangling

13 min read

Data Wrangling

13 min read

Sep 4

Exploratory Data Analysis dan Hypothesis Testing tentang Pola Hidup Masyarakat dan Penyakit Tidak Menular

Tulisan ini merupakan salah satu outcome final project course Probability — Pacmann. Introduction Walaupun pola hidup sehat sudah diajarkan sejak kecil, ternyata kesadaran masyarakat Indonesia untuk menjalani hidup sehat masih terbilang rendah. Beberapa indikator tersebut tercantum di dalam hasil Riset Kesehatan Dasar (Riskesdas) yang dilakukan oleh Kementerian Kesehatan Republik Indonesia: Persentase…

Exploratory Data Analysis

18 min read

Exploratory Data Analysis

18 min read

Jul 5

Polusi Udara : Sektor Penyebab Polusi, Dampak Polusi, dan Kualitas Udara baik di Indonesia maupun di Berbagai Belahan Dunia

Tulisan ini merupakan salah satu outcome project dari course Data & Visualization — Pacmann. Introduction Dalam beberapa bulan terakhir semenjak bulan Mei-Juni 2023, di Indonesia terutama di kawasan Jabodetabek kita dapat mengamati polusi udara secara kasat mata. Ketika berada di sekitar kabut polusi udara tersebut, kita tidak merasakan segar dan nyaman…

Data Visualization

12 min read

Polusi Udara : Faktor Penyebab Polusi, Dampak Polusi, dan Kualitas Udara baik di Indonesia maupun…

Data Visualization

12 min read