《商务数据统计与分析》课件——学习单元五 商品销售分析.pptx

学习单元5商品销售分析订单分析交易分析主题theThemesDT订单分析订单分析订单量分析品类分析产品偏好分析客单分析区域分析动销率分析5.1.1订单量分析1分仓分析2分时段分析订单量分析内容分仓分析某店铺分仓单量预测仓库单量仓库A140仓库B700仓库C1,530仓库D520仓库E210仓库F2,200仓库G630汇总5,9305.1.1订单量分析之分仓分析订单量分析分时段分析仓库单量2018-9-162018-9-172018-9-182018-9-192018-9-202018-9-212018-9-22星期一星期二星期三星期四星期五星期六星期日仓库A14020202020202020仓库B7001501508080808080仓库C1,53010010010094090100100仓库D5201001507050505050仓库E21030303030303030仓库F2,200100100100--1,300600仓库G630150808080808080汇总5,9306506304801,2003501,660960某店铺分仓分时单量预测分时段分析某店铺分仓分时单量预测分时段分析timeUVBuyerOrderPCTCRAmount占比2017年占比同比00:00-01:0013,4904,1915,15433431%1,400,42321.75%36.95%-41.13%01:00-02:006,8675,2536,73438376%2,011,70731.25%22.86%36.73%02:00-03:002,58041250531516%129,6982.01%1.91%5.53%03:00-04:001,14019622531817%62,3950.97%0.85%13.98%04:00-05:0078318621129424%54,6230.85%0.85%0.02%05:00-06:0083726130132831%85,5621.33%1.11%19.89%06:00-07:004,87866374933214%220,2493.42%2.86%19.74%07:00-08:008,3548771,01033310%292,2874.54%4.06%11.85%08:00-09:007,0419441,11234913%329,0295.11%3.75%36.41%09:00-10:006,43977892033212%258,5734.02%3.74%7.39%10:00-11:005,01462972633113%208,1153.23%2.95%9.50%11:00-12:003,74743551033012%143,7672.23%1.28%74.23%12:00-13:003,49136543629910%108,9711.69%1.23%37.67%13:00-14:003,45134940527110%94,5351.47%1.12%30.93%14:00-15:002,76629135329911%86,9701.35%1.24%9.24%15:00-16:002,47928634329012%83,0271.29%0.82%56.38%16:00-17:002,37427831128812%80,0881.24%1.11%12.58%17:00-18:002,21723327329611%69,0631.07%1.00%7.23%18:00-19:002,46124227833510%81,1651.26%1.18%6.86%19:00-20:002,69130739731211%95,7511.49%1.24%20.37%20:00-21:002,96236245331212%113,1231.76%1.68%4.55%21:00-22:003,33537244028211%104,8201.63%1.73%-6.04%22:00-23:003,59849260630314%148,9382.31%2.00%15.92%23:00-24:002,99074491923525%174,6542.71%2