Ventas Ketal
2024-01-08
DESCRIPCION DEL LA BASE DE DATOS
Este documnyo esta basado en la validaciones que se hace a diario (Validación de carga de ventas POS - SAP 2023.xlsx) para el resumne de ventas:
resumen de variables de la Tabla
## Fecha Sala V_Pos
## Min. :2022-01-01 00:00:00.0 Length:10736 Min. : 0
## 1st Qu.:2022-07-08 00:00:00.0 Class :character 1st Qu.: 0
## Median :2022-12-30 00:00:00.0 Mode :character Median : 0
## Mean :2023-01-03 00:11:32.0 Mean : 6144
## 3rd Qu.:2023-07-05 00:00:00.0 3rd Qu.: 543
## Max. :2024-01-06 00:00:00.0 Max. :11832960
## NA's :4
## V_Loc V_Eba V_Sedem V_CLN
## Min. : 0 Min. : 0 Min. : 0.0 Min. : 0.00
## 1st Qu.: 11206 1st Qu.: 0 1st Qu.: 0.0 1st Qu.: 0.00
## Median : 29075 Median : 0 Median : 0.0 Median : 0.00
## Mean : 49341 Mean : 1194 Mean : 761.2 Mean : 65.67
## 3rd Qu.: 80450 3rd Qu.: 0 3rd Qu.: 0.0 3rd Qu.: 0.00
## Max. :411105 Max. :31770 Max. :31053.3 Max. :9054.83
## NA's :2 NA's :2 NA's :2
## V_STUMSA V_Total VV_Pos Rebaja
## Min. : 0.0 Min. : 0 Min. : 1 Min. :-20172.53
## 1st Qu.: 0.0 1st Qu.: 22182 1st Qu.: 22260 1st Qu.: -374.74
## Median : 0.0 Median : 34142 Median : 34272 Median : -155.38
## Mean : 584.7 Mean : 58078 Mean : 58353 Mean : -274.14
## 3rd Qu.: 407.8 3rd Qu.: 86397 3rd Qu.: 86748 3rd Qu.: -50.86
## Max. :31642.1 Max. :11832960 Max. :11832960 Max. : 13.30
## NA's :14
## V_Sap Iteration file_anio ianio
## Min. : 1 Min. : 0.00 Min. :2022 Length:10736
## 1st Qu.: 22189 1st Qu.: 6.00 1st Qu.:2022 Class :character
## Median : 34151 Median :11.00 Median :2022 Mode :character
## Mean : 58079 Mean :11.61 Mean :2023
## 3rd Qu.: 86388 3rd Qu.:18.00 3rd Qu.:2023
## Max. :11832960 Max. :24.00 Max. :2024
##
## Quarter Month (name) Week Day of week (name)
## Min. :1.000 Length:10736 Min. : 1.00 Length:10736
## 1st Qu.:2.000 Class :character 1st Qu.:13.00 Class :character
## Median :3.000 Mode :character Median :27.00 Mode :character
## Mean :2.516 Mean :26.61
## 3rd Qu.:4.000 3rd Qu.:40.00
## Max. :4.000 Max. :52.00
##
## fecha_tra mes day weeknum
## Min. :1.641e+09 Min. : 1.000 Min. : 1.00 Min. : 1.00
## 1st Qu.:1.657e+09 1st Qu.: 4.000 1st Qu.: 8.00 1st Qu.:13.00
## Median :1.672e+09 Median : 7.000 Median :16.00 Median :27.00
## Mean :1.673e+09 Mean : 6.536 Mean :15.66 Mean :26.61
## 3rd Qu.:1.689e+09 3rd Qu.:10.000 3rd Qu.:23.00 3rd Qu.:40.00
## Max. :1.704e+09 Max. :12.000 Max. :31.00 Max. :53.00
## Cuadro Comparativo Ventas Anuales
You can also embed plots, for example:
Cuadro Comparativo Ventas Anuales por Sucursal
Note that the echo = FALSE parameter was added to the code
chunk to prevent printing of the R code that generated the plot.