Premiere Products Dashboard

Row

# Display the first few rows of each data frame to verify

SalesRep Table:

# A tibble: 3 × 9
  REP_NUM LAST_NAME FIRST_NAME STREET      CITY     STATE ZIP   COMMISSION  RATE
  <chr>   <chr>     <chr>      <chr>       <chr>    <chr> <chr>      <dbl> <dbl>
1 20      Kaiser    Valerie    624 Randall Grove    FL    33321     20542.  0.05
2 35      Hull      Richard    532 Jackson Sheldon  FL    33553     39216   0.07
3 65      Perez     Juan       1626 Taylor Fillmore FL    33336     23487   0.05


Customer Table:

# A tibble: 6 × 9
  CUSTOMER_NUM CUSTOMER_NAME       STREET CITY  STATE ZIP   BALANCE CREDIT_LIMIT
  <chr>        <chr>               <chr>  <chr> <chr> <chr>   <dbl>        <dbl>
1 148          Al's Appliance and… 2837 … Fill… FL    33336   6550          7500
2 282          Brookings Direct    3827 … Grove FL    33321    432.        10000
3 356          Ferguson's          382 W… Nort… FL    33146   5785          7500
4 408          The Everything Shop 1828 … Crys… FL    33503   5285.         5000
5 462          Bargains Galore     3829 … Grove FL    33321   3412         10000
6 524          Kline's             838 R… Fill… FL    33336  12762         15000
# ℹ 1 more variable: REP_NUM <chr>


Product Table:

# A tibble: 6 × 6
  PART_NUM DESCRIPTION    ON_HAND CLASS WAREHOUSE PRICE
  <chr>    <chr>            <dbl> <chr> <chr>     <dbl>
1 AT94     Iron                50 HW    3          25.0
2 BV06     Home Gym            45 SG    2         795. 
3 CD52     Microwave Oven      32 AP    1         165  
4 DL71     Cordless Drill      21 HW    3         130. 
5 DR93     Gas Range            8 AP    2         495  
6 DW11     Washer              12 AP    3         400.


Order Table:

# A tibble: 6 × 3
  ORDER_NUM ORDER_DATE          CUSTOMER_NUM
      <dbl> <dttm>              <chr>       
1      4339 2019-10-12 00:00:00 524         
2      7338 2019-10-12 00:00:00 687         
3      8892 2019-10-12 00:00:00 282         
4      8922 2019-10-12 00:00:00 356         
5      9187 2019-10-12 00:00:00 462         
6      9247 2019-10-12 00:00:00 687


OrderItem Table:

# A tibble: 6 × 4
  ORDER_NUM PART_NUM NUM_ORDERED QUOTED_PRICE
  <chr>     <chr>          <dbl>        <dbl>
1 21608     AT94              11         22.0
2 21610     DR93               1        495  
3 21610     DW11               1        400. 
4 21613     KL62               4        330. 
5 21614     KT03               2        595  
6 21617     BV06               2        795.

```

Column

Excel file path

Row

# Display the first few rows of each data frame to verify