X Vehicle Company Service

class: center, middle, inverse, title-slide

# X Vehicle Company Service
### MadagaskaR
### MEF University
### 2020/12/30

---

class:left, bottom

.pull-left[

### GROUP MEMBERS

**Barış SİVAS** 
**Neriman GÜRSOY** 
**Ozan Barış BAYKAN** 
**Sena KALEMCİ** 
**Tuğba ÜNAL** 
]

.pull-right[

### AGENDA

**1. Data Information** 
**2. Exploratory Data Analysis** 
**3. Shiny App** 
**4. Conclusion** 
]

---

## 1. Data Information

- [X Vehicle Company Service]("https://github.com/pjournal/mef04g-madagaskar/blob/gh-pages/Data/x_vehicle_company_service_dataset_v4.rds")
 - 561,142 row and 19 feature
- Data check
  - CSV to RDS
  - NA and Duplicated Values
  - Outliers
  - Renaming of the columns
  - date conversion
- Packages
  - tidyverse, lubridate, rio , shiny, etc.

```
##  [1] "Material_id"              "Vehicle_id"              
##  [3] "Dealer_id"                "Job_order_number"        
##  [5] "material_type"            "process_type"            
##  [7] "beginning_date"           "ending_date"             
##  [9] "quantity"                 "price"                   
## [11] "Model"                    "production_date"         
## [13] "job_closed_date"          "vehicle_km"              
## [15] "dealer_city"              "warranty_beginning"      
## [17] "warranty_ending"          "Garanti Baslangic tarihi"
## [19] "Garanti Bitis tarihi"
```

---

## 2. Exploratory Data Analysis

Vehicle Operation Trend

<img src="presentation_28.12_files/figure-html/unnamed-chunk-3-1.png" width="90%" style="display: block; margin: auto;" />
 
- Trend charts were created by comparing process volumes in services for 2019 and 2020. 
- While 2019 monthly data show a similar trend, 2020 transaction volumes show highly volatility due to the pandemic effect.

---

## 2. Exploratory Data Analysis

Proportion of Process Types

<img src="presentation_28.12_files/figure-html/unnamed-chunk-4-1.png" width="55%" style="display: block; margin: auto;" />
 
- The process types in the data set were shown by proportionally according to their volume. 
- Among the total data for two years, it was seen that the most transactions were made in fault type with 83%.

---

## 2. Exploratory Data Analysis

Distribution in Fault Type

<img src="presentation_28.12_files/figure-html/unnamed-chunk-5-1.png" width="90%" style="display: block; margin: auto;" />
 
- The most processed fault type was filtered and the model distribution was created. 
- The most processed model type with fault type is seen as model 23 from the graphic.

---

## 2. Exploratory Data Analysis

Analyzing Min, Max and Mean of The Vehicle Kms

.pull-left[

]

.pull-right[

<img src="presentation_28.12_files/figure-html/unnamed-chunk-7-1.png" width="90%" style="display: block; margin: auto;" />
]

- The distribution of the vehicle kms was plotted according to the models.

---

## 2. Exploratory Data Analysis

The Usage Amount of The Material Types

<img src="presentation_28.12_files/figure-html/unnamed-chunk-8-1.png" width="90%" style="display: block; margin: auto;" />
 
- It was seen that the "diğer", "parça" and "oil" materials were ranked in order of high to low, respectively, according to their usage amounts.

---

## 2. Exploratory Data Analysis

The Most Popular Dealers

<img src="presentation_28.12_files/figure-html/unnamed-chunk-9-1.png" width="90%" style="display: block; margin: auto;" />
 
- The calculated rates was observed that the transactions were concentrated in the Marmara Region, where industry and transportation are intense, and in the **Akdeniz** and **Ege** regions, where tourism activities are intense.

---

## 2. Exploratory Data Analysis

The Total Price According to Types of Model

<img src="presentation_28.12_files/figure-html/unnamed-chunk-10-1.png" width="90%" style="display: block; margin: auto;" />
 
- The dataset is grouped according to the model production date variables, and it is aimed to find the model with the highest service expenditure. 
- **Model 23** was seen to be the most costly model.

---

## 3. Shiny App

![](https://github.com/pjournal/mef04g-madagaskar/blob/gh-pages/Group_Project/Images/Shiny_Capture.JPG?raw=true){#id .class width=300 height=150px}

---

## 4. Conclusion

1. The operation trend was changed in 2020 due to the pandemic issue.It should not be overlooked that this situation may change the demands in the next few years.
2. Almost 83% of the transactions made in the services consist of “Ariza”.
3. Model 23 is the most expensive vehicle model, as it is the most frequently visited to the dealers.
4. It was seen that the “diğer”, “parça” and “yag” materials were ranked in order of high to low, respectively, according to their usage amounts in whole process types.
5. It was observed that the transactions were concentrated in the Marmara Region(Istanbul), where industry and transportation are intense, and in the Akdeniz and Ege regions(Antalya, İzmir), where tourism activities are intense.

---

class: center, middle

.pull-bottom[
**THANK YOU**
]