Carsharing 데이터 분석: MAU, DAU
2019-03-17
Table: dump table
| 필드 이름 | 유형 |
|---|---|
| id | INTEGER |
| created | TIMESTAMP |
| updated | TIMESTAMP |
| deleted | TIMESTAMP |
| status | INTEGER |
| pickup_time | TIMESTAMP |
| return_time | TIMESTAMP |
| options | INTEGER |
| purpose | STRING |
| car_id | INTEGER |
| exemption_id | STRING |
| paycard_id | STRING |
| pickup_spot_id | INTEGER |
| return_spot_id | INTEGER |
| user_id | INTEGER |
- MAU(Monthly Active User)
- DAU(Daily Active User)
1. MAU(Monthly Active User)
SELECT COUNT(DISTINCT user_id)
FROM `carsharing_data.dump`
WHERE pickup_time >= '2019-02-01' and pickup_time <= '2019-02-28';
2. DAU(Daily Active User)
SELECT COUNT(DISTINCT user_id)
FROM `carsharing_data.dump`
WHERE pickup_time = '2019-02-01';
Tableau Visualization
Proportion of customers
Peaks
Peaks Weekdays Or weekends
