Automation & Reporting

Load Packages

library(tidyverse)   # data wrangling and ggplot2
library(lubridate)   # handling dates
library(openxlsx)    # optional: export to Excel
library(rmarkdown)   # render reports
library(janitor)
library(flextable)

Load Data

data <- read_csv("C:/Users/ADMIN/Desktop/Data Science/Datasets/Business Intelligence/Sample - Superstore.csv")

Convert dates to proper format

data <- data %>%
  mutate(
    `Order Date` = mdy(`Order Date`),
    `Ship Date`  = mdy(`Ship Date`)
  )
data = clean_names(data)

glimpse(data)  # quick inspection

## Rows: 9,994
## Columns: 21
## $ row_id        <dbl> 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 1…
## $ order_id      <chr> "CA-2016-152156", "CA-2016-152156", "CA-2016-138688", "U…
## $ order_date    <date> 2016-11-08, 2016-11-08, 2016-06-12, 2015-10-11, 2015-10…
## $ ship_date     <date> 2016-11-11, 2016-11-11, 2016-06-16, 2015-10-18, 2015-10…
## $ ship_mode     <chr> "Second Class", "Second Class", "Second Class", "Standar…
## $ customer_id   <chr> "CG-12520", "CG-12520", "DV-13045", "SO-20335", "SO-2033…
## $ customer_name <chr> "Claire Gute", "Claire Gute", "Darrin Van Huff", "Sean O…
## $ segment       <chr> "Consumer", "Consumer", "Corporate", "Consumer", "Consum…
## $ country       <chr> "United States", "United States", "United States", "Unit…
## $ city          <chr> "Henderson", "Henderson", "Los Angeles", "Fort Lauderdal…
## $ state         <chr> "Kentucky", "Kentucky", "California", "Florida", "Florid…
## $ postal_code   <chr> "42420", "42420", "90036", "33311", "33311", "90032", "9…
## $ region        <chr> "South", "South", "West", "South", "South", "West", "Wes…
## $ product_id    <chr> "FUR-BO-10001798", "FUR-CH-10000454", "OFF-LA-10000240",…
## $ category      <chr> "Furniture", "Furniture", "Office Supplies", "Furniture"…
## $ sub_category  <chr> "Bookcases", "Chairs", "Labels", "Tables", "Storage", "F…
## $ product_name  <chr> "Bush Somerset Collection Bookcase", "Hon Deluxe Fabric …
## $ sales         <dbl> 261.9600, 731.9400, 14.6200, 957.5775, 22.3680, 48.8600,…
## $ quantity      <dbl> 2, 3, 2, 5, 2, 7, 4, 6, 3, 5, 9, 4, 3, 3, 5, 3, 6, 2, 2,…
## $ discount      <dbl> 0.00, 0.00, 0.00, 0.45, 0.20, 0.00, 0.00, 0.20, 0.20, 0.…
## $ profit        <dbl> 41.9136, 219.5820, 6.8714, -383.0310, 2.5164, 14.1694, 1…

Transform Data → Weekly Summary

Example: Weekly sales & profit by region.

weekly_summary <- data %>%
  mutate(week = floor_date(order_date, "week")) %>%
  group_by(week, region) %>%
  summarise(
    total_sales  = sum(sales, na.rm = TRUE),
    total_profit = sum(profit, na.rm = TRUE),
    orders       = n(),
    .groups = "drop"
  )
flextable(weekly_summary) %>% theme_box()

week	region	total_sales	total_profit	orders
2013-12-29	Central	304.5080	-60.4389	4
2014-01-05	Central	127.7020	-61.0441	4
2014-01-05	East	29.4760	7.9654	2
2014-01-05	South	4,442.4900	1,371.3749	10
2014-01-05	West	19.4400	9.3312	1
2014-01-12	East	402.7700	-48.6475	7
2014-01-12	South	1,983.1500	479.8956	7
2014-01-12	West	1,744.6130	255.6358	4
2014-01-19	Central	714.5560	183.5546	9
2014-01-19	South	1,951.8420	389.8349	8
2014-01-19	West	457.3340	-253.6764	7
2014-01-26	Central	862.0400	262.7346	5
2014-01-26	East	3.9280	1.3257	1
2014-01-26	South	944.6100	105.5586	7
2014-01-26	West	717.3360	13.1023	4
2014-02-02	Central	8.9520	-14.7708	1
2014-02-02	East	180.3200	59.3488	2
2014-02-02	South	520.8560	92.6021	5
2014-02-02	West	258.4060	94.0419	7
2014-02-09	Central	551.4460	112.8571	7
2014-02-09	South	1,508.1300	186.7374	3
2014-02-09	West	711.4780	97.0254	5
2014-02-16	Central	192.5120	-5.0731	8
2014-02-16	West	32.4000	15.5520	2
2014-02-23	Central	1,751.0070	-266.5641	10
2014-02-23	East	25.3960	5.0086	2
2014-02-23	West	513.2400	70.2657	3
2014-03-02	Central	176.7720	-459.6072	1
2014-03-02	East	1,431.2580	167.0930	15
2014-03-02	South	389.9080	23.4826	3
2014-03-02	West	2,187.4140	110.6657	9
2014-03-09	Central	605.7380	169.4294	3
2014-03-09	East	127.7040	53.0024	3
2014-03-09	South	2,384.3880	574.4314	11
2014-03-09	West	1,021.7720	48.4868	10
2014-03-16	Central	291.3840	122.3598	9
2014-03-16	East	3,595.2100	-987.7259	8
2014-03-16	South	28,982.8790	-641.5249	31
2014-03-16	West	4,834.1920	822.8942	6
2014-03-23	Central	2,081.6810	-43.2144	3
2014-03-23	East	722.2740	-66.3454	3
2014-03-23	South	9.9120	3.2214	1
2014-03-23	West	1,515.4980	223.1798	13
2014-03-30	Central	1,949.7600	303.4783	16
2014-03-30	East	189.6820	55.5630	6
2014-03-30	South	7,274.5940	712.4686	18
2014-03-30	West	1,298.6760	394.7994	12
2014-04-06	Central	790.7520	280.9752	2
2014-04-06	East	498.8720	-146.9927	5
2014-04-06	South	2,974.2900	750.7447	10
2014-04-06	West	4,194.0590	755.6231	23
2014-04-13	Central	697.0740	61.7937	4
2014-04-13	East	638.5760	-384.7942	5
2014-04-13	South	168.4020	70.6854	3
2014-04-13	West	694.3180	242.7927	7
2014-04-20	Central	1,207.1380	-217.8412	5
2014-04-20	East	852.8220	101.4939	7
2014-04-20	South	1,131.2160	37.7970	2
2014-04-20	West	2,468.9280	387.7667	10
2014-04-27	Central	21.5600	10.3488	1
2014-04-27	East	1,013.1640	197.7752	13
2014-04-27	South	2,260.1280	457.0428	8
2014-04-27	West	1,679.9600	125.9970	1
2014-05-04	Central	263.2290	20.5705	5
2014-05-04	East	3,291.0650	254.0181	8
2014-05-04	South	246.5700	90.4802	9
2014-05-04	West	2,531.6000	422.5319	13
2014-05-11	Central	1,733.3620	-242.6796	9
2014-05-11	East	735.9660	-120.3147	2
2014-05-11	South	716.3360	-306.2464	3
2014-05-11	West	782.2060	108.1287	6
2014-05-18	Central	356.7560	-29.0895	10
2014-05-18	East	2,295.3820	327.8462	16
2014-05-18	South	3,549.0300	1,505.3337	5
2014-05-18	West	44.8000	16.7280	2
2014-05-25	Central	1,673.5990	-265.1673	8
2014-05-25	East	850.4820	272.4731	6
2014-05-25	South	787.3200	237.1017	3
2014-05-25	West	3,211.8320	326.1754	12
2014-06-01	Central	4,595.3750	986.2809	16
2014-06-01	East	1,962.7600	-188.9511	11
2014-06-01	South	1,572.9810	436.9018	7
2014-06-01	West	649.0080	154.9272	3
2014-06-08	Central	846.8340	315.5073	5
2014-06-08	East	1,745.3600	109.5240	2
2014-06-08	South	1,611.6520	255.6680	2
2014-06-08	West	4,479.4360	444.8395	14
2014-06-15	Central	3,481.7796	-86.3276	15
2014-06-15	East	3,827.4430	850.7010	17
2014-06-15	South	425.6700	98.9298	3
2014-06-15	West	3,466.5680	1,060.4683	6
2014-06-22	Central	669.8300	12.7564	3
2014-06-22	East	2,832.8570	87.7662	9
2014-06-22	South	639.2600	78.2058	5
2014-06-22	West	1,002.0100	101.2122	7
2014-06-29	Central	554.6800	-61.4284	5
2014-06-29	East	470.2960	143.2519	7
2014-06-29	South	1,690.1760	389.9328	12
2014-06-29	West	443.2480	150.5808	5
2014-07-06	Central	1,224.9180	66.6556	10
2014-07-06	East	2,465.9380	641.8881	12
2014-07-06	West	2,764.6230	154.5920	16
2014-07-13	Central	77.7140	-38.5792	4
2014-07-13	East	637.6040	110.6902	11
2014-07-13	West	672.3680	-13.0226	4
2014-07-20	Central	4,935.7420	-4,004.0770	16
2014-07-20	East	319.2640	40.1752	5
2014-07-20	South	256.4800	104.1415	3
2014-07-20	West	16,078.5940	1,366.9310	36
2014-07-27	Central	886.2800	248.0276	3
2014-07-27	East	71.4600	34.1492	2
2014-07-27	South	396.0480	92.3432	7
2014-07-27	West	1,901.8720	304.8828	4
2014-08-03	Central	1,598.9550	478.0360	6
2014-08-03	East	2,350.0500	754.7333	12
2014-08-03	South	412.3020	42.6160	4
2014-08-03	West	9,092.7690	1,922.1558	29
2014-08-10	Central	30.9600	-52.6320	1
2014-08-10	East	1,487.5820	-80.4080	4
2014-08-10	South	987.9940	224.2982	10
2014-08-10	West	1,473.3380	202.6706	10
2014-08-17	Central	467.9240	14.6136	4
2014-08-17	East	172.4320	-20.0023	6
2014-08-17	South	2,893.5020	944.6666	10
2014-08-17	West	832.6400	164.5384	9
2014-08-24	Central	38.0640	-59.6184	2
2014-08-24	East	566.7040	145.5664	16
2014-08-24	South	2,559.9125	57.7418	8
2014-08-24	West	1,737.2120	246.1224	12
2014-08-31	Central	1,318.0620	21.2601	6
2014-08-31	East	844.0040	137.4781	9
2014-08-31	South	1,825.9640	845.1696	2
2014-08-31	West	246.8200	73.7774	4
2014-09-07	Central	15,480.4290	-1,764.5578	36
2014-09-07	East	8,270.7500	661.8044	27
2014-09-07	South	1,892.5220	-400.0811	10
2014-09-07	West	4,315.4360	711.3417	24
2014-09-14	Central	6,806.2060	-1,380.8848	11
2014-09-14	East	9,910.5050	2,936.1088	24
2014-09-14	South	2,923.4410	-860.3619	9
2014-09-14	West	1,045.6800	243.1380	20
2014-09-21	Central	10,803.9928	4,546.9797	15
2014-09-21	East	1,393.6900	305.2390	22
2014-09-21	South	4.6080	1.6704	1
2014-09-21	West	5,200.8670	1,194.3818	20
2014-09-28	Central	316.1870	-93.3839	6
2014-09-28	East	5,676.2020	133.1576	18
2014-09-28	South	596.5600	73.6512	7
2014-09-28	West	5,192.2300	1,074.1213	23
2014-10-05	Central	1,997.9140	189.9124	7
2014-10-05	East	1,033.2740	68.4943	8
2014-10-05	South	128.4700	43.4171	4
2014-10-05	West	1,591.6140	237.8772	13
2014-10-12	Central	2,505.7020	684.8804	9
2014-10-12	East	2,891.5740	362.2963	13
2014-10-12	South	3,227.2640	629.2831	9
2014-10-12	West	1,843.6860	509.6287	10
2014-10-19	Central	1,074.1620	106.4697	6
2014-10-19	East	679.7440	-105.3447	5
2014-10-19	South	1,367.9400	-31.6729	8
2014-10-19	West	761.1440	166.4856	10
2014-10-26	Central	3,087.4880	458.4640	5
2014-10-26	East	4,442.1140	2.3516	15
2014-10-26	South	1,141.9200	156.7297	8
2014-10-26	West	6,217.1780	518.9427	24
2014-11-02	Central	1,321.9560	101.1149	11
2014-11-02	East	8,250.4640	2,242.3992	24
2014-11-02	South	2,650.9230	12.5440	12
2014-11-02	West	2,901.9000	405.5473	17
2014-11-09	Central	5,364.6712	-827.5807	28
2014-11-09	East	1,837.3720	186.5141	10
2014-11-09	South	402.4480	53.8352	5
2014-11-09	West	7,957.0200	1,585.6409	29
2014-11-16	Central	3,480.4080	79.2368	22
2014-11-16	East	17,514.4950	3,099.1138	26
2014-11-16	South	2,580.9800	968.6175	12
2014-11-16	West	3,217.7405	667.6342	17
2014-11-23	Central	3,874.8370	-152.0311	22
2014-11-23	East	5,382.2160	-230.4601	20
2014-11-23	South	668.1600	163.7071	6
2014-11-23	West	6,271.8920	261.1007	33
2014-11-30	Central	4,923.6820	644.3110	18
2014-11-30	East	4,651.0740	469.1421	24
2014-11-30	South	190.5680	33.7590	6
2014-11-30	West	3,420.5080	466.3792	12
2014-12-07	Central	644.7760	-398.2785	8
2014-12-07	East	1,228.3520	178.0282	4
2014-12-07	South	141.3820	61.9909	3
2014-12-07	West	6,956.5545	649.4944	30
2014-12-14	Central	2,965.0840	495.8948	19
2014-12-14	East	8,237.3940	2,133.3830	8
2014-12-14	South	7,221.9610	1,073.0791	19
2014-12-14	West	5,320.6060	710.2345	21
2014-12-21	Central	1,163.7200	34.7884	10
2014-12-21	East	2,299.8180	285.6343	15
2014-12-21	South	1,169.5760	196.1186	9
2014-12-21	West	5,999.4060	-163.3905	27
2014-12-28	Central	2,706.5256	-237.3264	17
2014-12-28	East	10,275.4140	655.5440	28
2014-12-28	South	39.1280	-8.8038	1
2014-12-28	West	3,909.5630	205.4104	15
2015-01-04	Central	72.2400	35.4732	2
2015-01-04	East	1,108.2720	-345.0052	4
2015-01-04	South	556.2900	200.2789	5
2015-01-04	West	236.6420	42.1024	5
2015-01-11	Central	254.7440	-312.0614	1
2015-01-11	East	861.2940	64.8088	7
2015-01-11	South	98.7800	14.8198	2
2015-01-11	West	612.4580	155.4968	3
2015-01-18	Central	301.7420	-21.7122	2
2015-01-18	South	13.1200	2.1320	1
2015-01-18	West	43.6600	20.8106	2
2015-01-25	Central	113.5640	43.9130	4
2015-01-25	East	769.3320	-191.6432	3
2015-01-25	South	4,297.6440	-1,862.3124	1
2015-01-25	West	5,133.9760	381.8981	4
2015-02-01	Central	870.5840	-64.2876	5
2015-02-01	East	1,649.3020	365.6968	4
2015-02-01	South	575.2600	204.0049	5
2015-02-01	West	154.3440	46.7058	3
2015-02-08	Central	602.7420	87.2575	7
2015-02-08	East	1,265.1840	85.2674	9
2015-02-08	West	203.9200	22.9410	1
2015-02-15	Central	974.9000	287.3705	3
2015-02-15	East	2,864.6500	1,361.7014	3
2015-02-15	South	29.9900	2.9990	1
2015-02-15	West	906.9940	303.2342	11
2015-02-22	Central	79.3600	20.6336	1
2015-02-22	East	683.9970	-6.0781	8
2015-02-22	South	551.2640	15.5664	2
2015-02-22	West	538.9200	80.8380	1
2015-03-01	Central	1,872.1604	-396.8145	13
2015-03-01	East	2,399.4050	309.2092	13
2015-03-01	South	58.7200	27.0112	1
2015-03-01	West	2,543.5100	619.5473	5
2015-03-08	Central	3,014.9600	632.5558	9
2015-03-08	East	797.7200	357.8918	4
2015-03-08	South	55.6240	11.6684	5
2015-03-08	West	1,407.7040	244.7002	5
2015-03-15	Central	522.2656	-17.2782	5
2015-03-15	East	1,597.9340	477.2525	9
2015-03-15	South	8,196.5750	3,683.7298	10
2015-03-15	West	5,450.5640	2,088.2555	14
2015-03-22	Central	628.9020	-106.9521	5
2015-03-22	East	1,199.0420	321.5350	7
2015-03-22	South	758.7360	99.7436	7
2015-03-22	West	5,891.4100	1,115.2534	12
2015-03-29	Central	2,105.0300	173.1363	14
2015-03-29	East	228.6320	66.3163	5
2015-03-29	South	1,252.4400	160.7101	3
2015-03-29	West	528.7360	213.2782	7
2015-04-05	Central	939.2520	-1,149.6426	7
2015-04-05	East	2,779.0160	120.2687	19
2015-04-05	South	327.6340	-75.1142	4
2015-04-05	West	2,231.4760	352.7705	7
2015-04-12	Central	3,316.2460	444.1688	19
2015-04-12	East	574.0800	7.7769	12
2015-04-12	South	2,405.4000	439.4798	5
2015-04-12	West	5,886.9380	790.0953	21
2015-04-19	Central	1,307.6080	-426.0986	8
2015-04-19	East	232.4200	98.3663	2
2015-04-19	South	1,789.4000	610.5555	7
2015-04-19	West	188.2000	38.7925	4
2015-04-26	Central	4,833.1310	1,907.2468	9
2015-04-26	East	3,982.2880	810.6588	10
2015-04-26	South	1,473.5315	-177.8060	8
2015-04-26	West	762.9420	130.3959	12
2015-05-03	Central	1,900.4140	257.6224	8
2015-05-03	East	4,515.7980	1,094.8434	15
2015-05-03	South	94.4900	44.9297	2
2015-05-03	West	1,145.8200	276.4900	7
2015-05-10	Central	1,115.1620	-70.3652	7
2015-05-10	East	659.0900	112.9144	9
2015-05-10	South	273.9080	40.7866	2
2015-05-10	West	3,064.0595	263.7703	11
2015-05-17	Central	993.9660	167.3382	5
2015-05-17	East	163.1380	27.1043	4
2015-05-17	South	356.2340	103.2235	3
2015-05-17	West	4,040.9200	440.8131	8
2015-05-24	Central	1,644.7730	-165.9631	11
2015-05-24	East	1,768.3780	234.8496	15
2015-05-24	South	971.1680	209.4080	6
2015-05-24	West	1,628.0580	318.1276	7
2015-05-31	Central	3,635.3540	1,057.9188	12
2015-05-31	East	1,963.3780	359.3098	8
2015-05-31	South	10.2720	1.1556	1
2015-05-31	West	3,128.8400	749.7428	11
2015-06-07	Central	183.0240	-379.7619	4
2015-06-07	East	255.6840	47.1016	10
2015-06-07	South	5,638.3460	368.1217	30
2015-06-07	West	539.8800	117.5331	4
2015-06-14	Central	488.0520	-1.4155	5
2015-06-14	East	3,567.5240	1,278.6540	6
2015-06-14	South	1,741.7750	312.7089	10
2015-06-14	West	1,590.7460	269.6231	16
2015-06-21	Central	1,939.1330	-411.8574	7
2015-06-21	East	1,369.9840	465.4746	4
2015-06-21	South	911.7360	314.0648	8
2015-06-21	West	1,192.3100	154.2965	9
2015-06-28	Central	2,708.5340	233.7775	8
2015-06-28	East	1,154.4300	-313.5963	10
2015-06-28	South	900.0880	311.6579	10
2015-06-28	West	650.5120	56.0502	3
2015-07-05	Central	88.7520	-106.0500	3
2015-07-05	East	4,630.1880	1,050.8123	29
2015-07-05	South	34.0300	0.8046	5
2015-07-05	West	341.9600	41.6045	5
2015-07-12	Central	2,114.8310	79.6561	11
2015-07-12	East	3,085.7960	716.4111	12
2015-07-12	South	270.8000	24.4604	2
2015-07-12	West	3,625.1980	-177.4085	8
2015-07-19	Central	2,693.1680	109.8482	10
2015-07-19	East	233.4480	56.1386	4
2015-07-19	South	982.9900	262.6832	6
2015-07-19	West	1,914.8330	128.8097	6
2015-07-26	Central	270.2620	60.9262	3
2015-07-26	East	3,430.2400	484.2693	4
2015-07-26	South	269.6700	105.7677	2
2015-07-26	West	2,196.6830	-148.6925	11
2015-08-02	Central	808.8592	-53.9861	11
2015-08-02	East	1,314.0200	422.5865	10
2015-08-02	South	520.0300	160.2692	2
2015-08-02	West	1,023.3960	-121.2729	8
2015-08-09	Central	1,485.0800	255.1325	9
2015-08-09	East	4,112.5700	927.1320	15
2015-08-09	South	121.0800	24.5775	4
2015-08-09	West	1,291.7340	154.0095	8
2015-08-16	East	2,772.1500	-555.9640	20
2015-08-16	South	53.2800	18.2472	2
2015-08-16	West	3,829.2940	416.5091	14
2015-08-23	Central	6,986.5520	823.6215	16
2015-08-23	East	1,265.0320	118.3324	7
2015-08-23	South	4,890.3600	1,970.0774	10
2015-08-23	West	2,811.4020	548.5805	14
2015-08-30	Central	295.6960	-10.3266	8
2015-08-30	East	2,509.6520	383.2099	11
2015-08-30	South	1,188.4340	333.3187	6
2015-08-30	West	4,855.8640	870.0691	19
2015-09-06	Central	242.3420	2.4156	3
2015-09-06	East	5,556.9230	763.0764	35
2015-09-06	South	305.3800	62.8821	6
2015-09-06	West	1,998.9960	325.7264	14
2015-09-13	Central	2,163.6600	412.7752	9
2015-09-13	East	16,312.0940	19.1177	33
2015-09-13	South	3,476.8640	760.3235	16
2015-09-13	West	3,272.2500	568.1148	21
2015-09-20	Central	4,816.0940	1,183.4629	12
2015-09-20	East	4,460.8180	1,180.7476	32
2015-09-20	South	6,680.0290	-104.9707	23
2015-09-20	West	5,621.2970	869.5538	31
2015-09-27	Central	193.4480	-19.9424	6
2015-09-27	East	1,380.1720	357.9468	15
2015-09-27	South	2,034.1600	625.8570	3
2015-09-27	West	2,536.4400	486.5304	24
2015-10-04	Central	1,480.5890	172.1956	9
2015-10-04	East	1,160.1500	402.5298	7
2015-10-04	South	2,350.9140	-266.2352	8
2015-10-04	West	968.8680	-66.3160	7
2015-10-11	Central	3,631.7940	-219.8719	11
2015-10-11	East	2,735.5780	413.6621	8
2015-10-11	South	1,351.6055	-279.3292	4
2015-10-11	West	177.7400	7.2950	3
2015-10-18	Central	1,406.3230	2.0929	15
2015-10-18	East	59.0000	28.7632	2
2015-10-18	South	88.4080	-8.9857	4
2015-10-18	West	4,788.5080	816.3913	17
2015-10-25	Central	370.0200	96.0110	2
2015-10-25	East	1,568.6300	423.0362	5
2015-10-25	South	287.4200	89.9131	5
2015-10-25	West	6,276.4780	765.9552	32
2015-11-01	Central	1,148.1500	-115.4617	11
2015-11-01	East	7,809.0140	1,842.2521	20
2015-11-01	South	2,455.4470	-893.7287	6
2015-11-01	West	3,942.3200	374.8357	15
2015-11-08	Central	5,938.4732	1,447.2885	23
2015-11-08	East	15,541.1160	5,086.5139	28
2015-11-08	South	2,917.9630	422.4925	21
2015-11-08	West	3,730.5980	389.4748	23
2015-11-15	Central	6,537.2508	1,254.7401	27
2015-11-15	East	4,386.6200	-247.1225	18
2015-11-15	South	436.0380	-71.9172	6
2015-11-15	West	4,816.0900	377.8210	30
2015-11-22	Central	2,575.7660	119.3509	14
2015-11-22	East	6,024.4480	1,236.1551	31
2015-11-22	South	1,262.3005	51.4605	8
2015-11-22	West	1,892.4040	549.1431	18
2015-11-29	Central	3,047.7780	696.4708	17
2015-11-29	East	5,778.0710	678.4738	24
2015-11-29	South	2,879.2300	-959.2025	17
2015-11-29	West	8,039.8610	1,117.8168	21
2015-12-06	Central	4,842.2780	1,032.1779	17
2015-12-06	East	5,046.7060	854.5618	23
2015-12-06	South	949.8880	284.4280	8
2015-12-06	West	5,387.8040	583.7661	44
2015-12-13	Central	1,780.5220	297.9984	13
2015-12-13	East	8,951.1800	-1,583.0573	17
2015-12-13	South	407.0760	69.5045	7
2015-12-13	West	5,217.1240	1,446.6018	27
2015-12-20	Central	7,771.6080	2,535.5673	17
2015-12-20	East	3,851.9070	321.4754	20
2015-12-20	South	821.8180	227.9068	10
2015-12-20	West	4,838.5440	49.2058	18
2015-12-27	Central	1,998.8612	184.9648	14
2015-12-27	East	2,420.3860	-233.6366	8
2015-12-27	South	986.3400	344.4658	10
2015-12-27	West	4,867.0240	824.5078	11
2016-01-03	Central	3,702.2960	812.9542	9
2016-01-03	East	124.4200	-75.8020	3
2016-01-03	South	1,403.1000	158.6208	7
2016-01-03	West	876.9180	299.3492	4
2016-01-10	East	851.3670	221.2058	12
2016-01-10	South	405.3440	64.0460	2
2016-01-10	West	276.9680	71.3618	5
2016-01-17	East	2,596.3080	602.2561	10
2016-01-17	South	846.2720	-25.3024	4
2016-01-17	West	1,414.9560	167.1350	7
2016-01-24	Central	2,224.3080	-344.3048	4
2016-01-24	East	858.7120	-65.8542	6
2016-01-24	South	31.3600	15.6800	1
2016-01-24	West	922.6880	70.3970	7
2016-01-31	Central	89.3360	-72.0300	2
2016-01-31	East	231.8000	41.1028	3
2016-01-31	South	13,331.9740	4,430.1757	19
2016-01-31	West	1,298.1660	124.7751	9
2016-02-07	Central	311.4300	0.6993	2
2016-02-07	East	30.3520	10.6232	1
2016-02-07	South	2,601.8460	334.4971	5
2016-02-07	West	892.6100	163.1453	4
2016-02-14	Central	167.1820	-224.6094	4
2016-02-14	East	1,947.1690	240.8808	13
2016-02-14	South	604.5560	111.8530	4
2016-02-14	West	70.8800	33.3136	1
2016-02-21	Central	563.3320	158.8180	3
2016-02-21	East	816.2760	266.1861	7
2016-02-21	South	471.0780	2.9494	3
2016-02-21	West	1,004.7980	103.1665	7
2016-02-28	Central	6,400.2860	-718.4783	13
2016-02-28	East	7,527.6360	2,766.5212	10
2016-02-28	South	10.0800	3.5280	1
2016-02-28	West	237.6040	38.5259	4
2016-03-06	Central	797.8060	-177.9002	12
2016-03-06	East	1,968.8550	149.6316	18
2016-03-06	South	2,037.5200	244.3102	5
2016-03-06	West	9,325.0020	901.3571	11
2016-03-13	Central	1,588.5530	-148.4737	9
2016-03-13	East	4,967.2930	-192.9823	19
2016-03-13	South	1,792.4080	246.1286	8
2016-03-13	West	7,105.5000	215.2708	11
2016-03-20	Central	2,664.7880	398.0983	9
2016-03-20	East	839.5960	-203.2896	4
2016-03-20	South	274.0660	25.9601	3
2016-03-20	West	797.0250	51.2553	9
2016-03-27	Central	3,170.2700	419.2474	5
2016-03-27	East	3,688.8070	420.4161	23
2016-03-27	South	131.1400	46.7730	5
2016-03-27	West	155.6040	16.6863	4
2016-04-03	Central	2,639.6040	-1,489.2928	9
2016-04-03	East	4,423.9540	395.3661	19
2016-04-03	South	766.4400	175.4809	7
2016-04-03	West	1,914.6530	423.1690	7
2016-04-10	Central	55.0960	11.9973	3
2016-04-10	East	9,169.1540	2,386.4082	5
2016-04-10	South	1,787.9740	149.6153	14
2016-04-10	West	4,490.5340	341.2248	18
2016-04-17	Central	2,602.8260	-315.4164	11
2016-04-17	East	1,616.3360	259.5481	18
2016-04-17	South	404.2560	98.6353	6
2016-04-17	West	2,483.7860	-609.2450	18
2016-04-24	Central	696.9360	69.9121	5
2016-04-24	East	550.7780	27.6346	5
2016-04-24	West	1,531.3320	188.7324	7
2016-05-01	Central	629.5800	-175.2863	11
2016-05-01	East	6,411.8490	1,269.9064	21
2016-05-01	South	1,085.8620	32.8371	12
2016-05-01	West	2,361.9400	367.0665	8
2016-05-08	Central	1,040.0000	-41.7376	7
2016-05-08	East	2,966.7280	357.4477	14
2016-05-08	South	229.8380	-25.4596	9
2016-05-08	West	530.9980	168.9426	9
2016-05-15	Central	173.7400	25.1399	8
2016-05-15	East	1,767.7820	220.7269	12
2016-05-15	South	2,658.4880	502.2781	9
2016-05-15	West	4,170.6390	543.3116	13
2016-05-22	Central	8,062.1080	1,081.1285	13
2016-05-22	East	10,292.1640	1,514.1612	18
2016-05-22	South	2,463.7480	360.4951	12
2016-05-22	West	2,549.6420	341.5269	13
2016-05-29	Central	2,516.4860	24.6508	21
2016-05-29	East	2,778.2380	554.1051	9
2016-05-29	South	5,598.1770	1,434.5971	12
2016-05-29	West	1,245.1760	98.2131	11
2016-06-05	Central	1,043.3240	177.0610	5
2016-06-05	East	2,193.0620	472.3142	13
2016-06-05	South	1,374.5700	252.9777	8
2016-06-05	West	6,851.0220	524.8853	19
2016-06-12	Central	2,538.4250	78.4592	14
2016-06-12	East	3,135.7340	263.4557	25
2016-06-12	South	374.7750	38.0929	5
2016-06-12	West	4,664.7870	815.9929	17
2016-06-19	Central	739.3420	124.4815	9
2016-06-19	East	3,372.7520	178.8011	19
2016-06-19	West	6,390.9940	840.0884	17
2016-06-26	Central	2,124.0100	287.3967	11
2016-06-26	East	1,544.8100	353.5371	14
2016-06-26	South	1,723.8600	403.6162	8
2016-06-26	West	2,224.7740	530.1387	10
2016-07-03	Central	1,251.2360	78.4393	6
2016-07-03	East	1,502.2350	307.9410	9
2016-07-03	South	885.5280	61.6207	3
2016-07-03	West	5,932.0310	1,427.1328	21
2016-07-10	Central	1,198.8560	121.8896	7
2016-07-10	East	1,705.5550	-394.6132	13
2016-07-10	South	316.3300	111.6012	9
2016-07-10	West	1,211.2440	153.2207	10
2016-07-17	Central	2,072.6960	295.6018	17
2016-07-17	East	1,600.8790	498.4610	19
2016-07-17	South	1,945.8810	302.5429	12
2016-07-17	West	4,097.4160	555.2518	21
2016-07-24	Central	2,490.7440	-5.4780	14
2016-07-24	East	3,579.0980	-757.0509	7
2016-07-24	South	3,321.4800	452.1159	8
2016-07-24	West	1,479.4340	372.6952	8
2016-07-31	Central	1,583.4780	362.8554	8
2016-07-31	East	128.5320	52.1712	3
2016-07-31	South	355.8600	122.4606	5
2016-07-31	West	2,977.6880	185.5747	10
2016-08-07	Central	2,128.7040	-7.5801	12
2016-08-07	East	1,983.2440	214.8538	4
2016-08-07	South	1,483.7305	-110.8451	13
2016-08-07	West	1,196.1540	241.1628	4
2016-08-14	Central	115.5840	25.0120	5
2016-08-14	East	1,631.1460	208.4726	8
2016-08-14	South	946.3920	98.5272	3
2016-08-14	West	1,090.7700	163.8754	14
2016-08-21	Central	4,099.9260	196.5964	22
2016-08-21	East	3,763.9330	395.1226	19
2016-08-21	South	264.0280	62.4668	5
2016-08-21	West	6,905.3120	586.8116	23
2016-08-28	Central	2,879.2148	-125.0283	25
2016-08-28	East	9,059.8660	630.1933	34
2016-08-28	South	1,941.5210	203.2204	7
2016-08-28	West	3,678.3900	715.9332	16
2016-09-04	Central	7,396.9816	-256.8537	37
2016-09-04	East	2,834.2520	275.8251	22
2016-09-04	South	3,355.1980	621.7710	20
2016-09-04	West	4,158.7940	1,340.8776	20
2016-09-11	Central	2,808.8760	835.5625	16
2016-09-11	East	4,077.9220	774.0094	15
2016-09-11	South	3,313.7700	1,305.0593	9
2016-09-11	West	6,427.0720	1,107.6977	30
2016-09-18	Central	1,558.9420	-646.7865	11
2016-09-18	East	4,863.7750	1,121.9648	26
2016-09-18	South	2,650.3260	270.4358	16
2016-09-18	West	4,973.1200	619.5756	27
2016-09-25	Central	3,444.6978	-390.2220	20
2016-09-25	East	1,515.3670	-208.5953	7
2016-09-25	South	799.0000	47.6991	8
2016-09-25	West	5,089.4045	576.7414	28
2016-10-02	Central	18,590.9260	8,759.7857	11
2016-10-02	East	6,454.4420	2,728.0794	7
2016-10-02	South	451.9680	-45.4932	3
2016-10-02	West	2,914.7620	-740.4107	14
2016-10-09	Central	3,133.8180	722.5373	16
2016-10-09	East	1,859.5040	393.1287	10
2016-10-09	South	672.7110	235.4378	11
2016-10-09	West	1,803.3600	-417.8628	19
2016-10-16	Central	2,986.5300	1,070.7583	10
2016-10-16	East	2,767.9720	169.6942	12
2016-10-16	South	287.0120	25.0855	5
2016-10-16	West	6,447.9800	1,771.0345	17
2016-10-23	Central	153.5240	43.3014	4
2016-10-23	East	3,016.4220	478.2457	15
2016-10-23	South	1,685.1150	156.3314	9
2016-10-23	West	1,770.7840	439.0048	13
2016-10-30	Central	3,333.7348	-192.0806	21
2016-10-30	East	1,202.6800	13.1432	6
2016-10-30	South	3,498.3140	175.6568	16
2016-10-30	West	8,286.6590	1,350.9392	36
2016-11-06	Central	4,822.5760	695.1399	18
2016-11-06	East	7,329.9980	683.2416	36
2016-11-06	South	2,085.6240	336.2948	9
2016-11-06	West	6,402.1040	1,168.2831	36
2016-11-13	Central	2,219.6800	155.1905	20
2016-11-13	East	5,373.1540	1,132.1815	25
2016-11-13	South	2,534.1200	461.6013	7
2016-11-13	West	2,514.7620	665.2782	18
2016-11-20	Central	5,533.0980	1,009.7129	31
2016-11-20	East	8,588.5160	-6,708.8000	38
2016-11-20	South	4,345.4620	1,649.4887	14
2016-11-20	West	8,900.6400	1,583.9441	19
2016-11-27	Central	3,676.1820	-86.9027	21
2016-11-27	East	8,699.2710	1,770.5221	32
2016-11-27	South	6,178.9810	1,121.5678	12
2016-11-27	West	5,115.7980	1,235.4433	23
2016-12-04	Central	6,862.7750	1,388.3245	22
2016-12-04	East	4,579.2770	1,293.7208	27
2016-12-04	South	2,991.3360	505.5660	10
2016-12-04	West	5,680.4660	952.4574	30
2016-12-11	Central	12,860.3280	5,490.0027	11
2016-12-11	East	3,366.0410	378.9953	21
2016-12-11	South	578.7300	123.2835	7
2016-12-11	West	8,751.7710	-6.4702	34
2016-12-18	Central	1,705.7260	233.5679	11
2016-12-18	East	7,572.3130	1,736.2669	12
2016-12-18	South	3,193.4560	-68.2801	11
2016-12-18	West	5,476.7520	173.0119	34
2016-12-25	Central	1,979.4780	163.3020	8
2016-12-25	East	4,552.5760	414.5723	16
2016-12-25	South	1,119.6180	395.2067	12
2016-12-25	West	8,408.5130	1,000.6175	30
2017-01-01	Central	5,341.2340	139.4295	13
2017-01-01	East	48.8960	8.5568	1
2017-01-01	South	776.7620	-47.9608	5
2017-01-01	West	2,894.0920	990.0359	9
2017-01-08	Central	5,739.0100	-823.6382	13
2017-01-08	East	352.2510	-193.6785	3
2017-01-08	South	204.7500	27.9620	7
2017-01-08	West	1,395.3480	154.9247	5
2017-01-15	Central	7,476.2650	3,029.9348	15
2017-01-15	East	4,190.3250	379.0207	13
2017-01-15	South	383.9920	1.8410	2
2017-01-15	West	1,648.1860	312.2675	12
2017-01-22	Central	532.0320	165.8646	5
2017-01-22	East	781.8240	159.0924	5
2017-01-22	South	3,030.9500	796.5697	5
2017-01-22	West	5,131.2800	1,644.8698	16
2017-01-29	Central	3,114.4830	500.6374	19
2017-01-29	East	493.1690	67.2262	8
2017-01-29	South	538.3140	-30.3440	3
2017-01-29	West	1,766.5620	252.5688	14
2017-02-05	Central	648.8560	-862.5388	6
2017-02-05	East	705.8720	129.2430	6
2017-02-05	South	359.9700	79.1934	1
2017-02-05	West	3,695.0510	679.5568	9
2017-02-12	Central	2,104.2364	-282.2178	11
2017-02-12	East	2,313.1730	43.2448	13
2017-02-12	South	29.1600	8.4564	1
2017-02-12	West	1,201.4460	429.6871	6
2017-02-19	Central	69.3620	-0.7226	4
2017-02-19	East	1,448.6760	249.3929	3
2017-02-19	South	1,674.5640	344.9592	3
2017-02-19	West	1,317.1500	-54.7010	15
2017-02-26	Central	531.8460	33.6433	10
2017-02-26	East	663.6280	173.5790	7
2017-02-26	South	72.8000	19.6560	1
2017-02-26	West	5,276.0440	967.0045	17
2017-03-05	Central	2,298.5140	397.8879	9
2017-03-05	East	1,488.4360	-118.1511	16
2017-03-05	South	1,569.6660	508.7810	8
2017-03-05	West	1,608.7940	425.9262	12
2017-03-12	Central	2,297.9200	22.7568	17
2017-03-12	East	2,324.4050	441.4700	21
2017-03-12	South	45.0180	20.2590	2
2017-03-12	West	4,111.7880	470.1372	20
2017-03-19	Central	5,042.9780	1,283.3470	13
2017-03-19	East	1,975.5060	455.7859	14
2017-03-19	South	64.3840	8.0480	1
2017-03-19	West	18,955.9760	7,437.9651	28
2017-03-26	Central	5,455.9208	353.9072	17
2017-03-26	East	1,308.5310	262.9868	9
2017-03-26	South	5,289.2020	1,838.1380	20
2017-03-26	West	7,329.2500	747.2819	19
2017-04-02	Central	1,078.0760	251.1790	5
2017-04-02	East	3,094.7320	705.1924	9
2017-04-02	South	5,513.3805	1,139.8800	13
2017-04-02	West	465.4200	219.3471	3
2017-04-09	Central	625.2040	238.3795	6
2017-04-09	East	2,064.3320	352.0896	25
2017-04-09	South	557.9570	44.1865	11
2017-04-09	West	1,855.3040	409.8907	7
2017-04-16	Central	1,019.9440	-319.9921	16
2017-04-16	East	2,695.2360	229.3394	11
2017-04-16	South	1,178.2800	98.8614	3
2017-04-16	West	3,717.9240	-3,312.8113	17
2017-04-23	Central	493.9276	-12.4850	6
2017-04-23	East	1,563.1120	26.1527	13
2017-04-23	South	1,517.0960	67.3764	9
2017-04-23	West	1,718.4970	321.8879	19
2017-04-30	Central	2,057.6968	-159.2645	7
2017-04-30	East	1,484.7910	-262.2413	16
2017-04-30	South	5,928.9090	-167.1243	22
2017-04-30	West	2,570.4530	350.9031	23
2017-05-07	Central	4,576.8540	1,249.1342	16
2017-05-07	East	1,235.1060	115.1858	12
2017-05-07	South	293.0000	50.2272	3
2017-05-07	West	5,667.5150	1,097.1556	18
2017-05-14	Central	3,133.5940	519.9100	24
2017-05-14	East	2,296.1040	464.4695	18
2017-05-14	South	3,499.1000	887.1571	14
2017-05-14	West	5,642.8200	1,077.9492	23
2017-05-21	Central	803.5060	12.7731	9
2017-05-21	East	1,344.0700	306.2026	6
2017-05-21	South	950.6020	246.0144	9
2017-05-21	West	1,259.0140	131.2201	11
2017-05-28	Central	5,597.4834	1,475.2224	19
2017-05-28	East	1,601.2020	-70.2801	15
2017-05-28	South	1,728.0300	138.9127	14
2017-05-28	West	2,127.4900	529.1090	15
2017-06-04	Central	2,042.4470	97.9636	14
2017-06-04	East	72.9220	24.9949	4
2017-06-04	South	1,651.4440	205.8018	8
2017-06-04	West	2,714.5770	123.2193	15
2017-06-11	Central	888.1520	-96.2254	12
2017-06-11	East	5,028.1800	1,978.5840	9
2017-06-11	South	5,224.8900	708.9069	20
2017-06-11	West	3,954.0340	525.8206	27
2017-06-18	Central	1,536.6390	-239.0060	12
2017-06-18	East	2,970.6390	491.5291	25
2017-06-18	South	578.4320	154.5695	4
2017-06-18	West	1,551.9035	278.2191	8
2017-06-25	Central	4,602.4452	148.7400	18
2017-06-25	East	6,018.1440	764.6466	17
2017-06-25	South	306.9440	-3.6278	3
2017-06-25	West	6,333.6590	1,444.9761	18
2017-07-02	Central	1,684.5420	-80.8951	11
2017-07-02	East	2,812.8160	236.7270	24
2017-07-02	South	584.7520	106.0458	5
2017-07-02	West	6,507.7320	1,808.4693	20
2017-07-09	Central	1,525.3980	40.5948	8
2017-07-09	East	4,791.5970	163.1206	21
2017-07-09	South	1,126.5900	232.5426	5
2017-07-09	West	2,555.2560	461.3170	13
2017-07-16	Central	2,674.9920	395.7178	15
2017-07-16	East	2,170.0180	220.5450	16
2017-07-16	South	1,202.2360	212.8858	9
2017-07-16	West	5,093.5230	47.9631	17
2017-07-23	Central	2,138.0020	501.3115	13
2017-07-23	East	1,167.7740	145.6872	12
2017-07-23	South	347.0960	18.1934	5
2017-07-23	West	6,160.8580	1,785.7726	14
2017-07-30	Central	2,498.8680	-48.9459	13
2017-07-30	East	1,396.1380	357.4129	8
2017-07-30	South	327.1440	31.6119	3
2017-07-30	West	999.9980	264.3394	12
2017-08-06	Central	2,445.2300	547.4069	12
2017-08-06	East	3,307.3100	831.2514	10
2017-08-06	South	739.3780	279.6204	5
2017-08-06	West	4,636.6120	1,113.9362	19
2017-08-13	Central	424.6920	-136.3312	10
2017-08-13	East	8,426.7520	-253.9163	16
2017-08-13	South	2,664.5800	-1,099.0243	11
2017-08-13	West	10,706.5300	2,931.6201	22
2017-08-20	Central	206.2000	5.2060	5
2017-08-20	East	5,928.6740	1,554.1808	13
2017-08-20	South	5,769.9960	672.5502	11
2017-08-20	West	3,691.7220	520.1557	20
2017-08-27	Central	5,165.6040	1,539.2009	17
2017-08-27	East	5,714.8820	504.9844	25
2017-08-27	South	2,489.8000	1,062.0757	6
2017-08-27	West	8,278.8460	1,857.0326	38
2017-09-03	Central	4,636.3250	96.7657	26
2017-09-03	East	4,485.2560	65.6524	34
2017-09-03	South	1,902.1320	115.4535	16
2017-09-03	West	6,648.3350	713.2381	36
2017-09-10	Central	2,753.9740	-998.2954	21
2017-09-10	East	6,986.3590	724.4390	42
2017-09-10	South	1,714.7400	353.2397	11
2017-09-10	West	9,625.0720	2,272.0049	31
2017-09-17	Central	3,147.5160	171.2265	23
2017-09-17	East	14,274.3310	1,120.5996	29
2017-09-17	South	3,274.2200	1,130.5745	21
2017-09-17	West	5,408.3660	541.0141	43
2017-09-24	Central	2,527.7740	552.7119	12
2017-09-24	East	4,034.4800	123.0054	26
2017-09-24	South	1,731.4880	127.1825	15
2017-09-24	West	4,099.6200	941.9993	30
2017-10-01	Central	2,638.2480	958.8682	14
2017-10-01	East	8,944.0240	2,566.3166	19
2017-10-01	South	3,508.5140	-1,006.6442	15
2017-10-01	West	6,763.6400	393.0115	38
2017-10-08	Central	2,957.4590	-604.8824	15
2017-10-08	East	4,597.3200	411.8424	19
2017-10-08	South	1,908.8540	474.4565	6
2017-10-08	West	7,056.1580	2,402.4307	16
2017-10-15	Central	3,163.7602	266.2544	11
2017-10-15	East	2,762.1040	129.7205	18
2017-10-15	South	4,688.5580	-2,056.0569	16
2017-10-15	West	2,656.3960	-37.3364	22
2017-10-22	Central	2,517.5510	7.8777	21
2017-10-22	East	15,473.3200	4,557.0310	23
2017-10-22	South	1,826.0450	306.6886	10
2017-10-22	West	1,718.3540	-77.8042	8
2017-10-29	Central	1,206.7540	19.1506	19
2017-10-29	East	2,508.1110	-271.6775	17
2017-10-29	South	15,278.2860	-2,674.4272	28
2017-10-29	West	10,024.3160	1,486.4647	32
2017-11-05	Central	1,554.7960	-195.9826	19
2017-11-05	East	7,721.7560	1,925.5529	29
2017-11-05	South	2,786.8520	207.9998	11
2017-11-05	West	7,952.1460	807.0044	40
2017-11-12	Central	2,707.1760	-66.5806	26
2017-11-12	East	16,224.5770	4,996.8675	32
2017-11-12	South	3,177.5860	376.9978	19
2017-11-12	West	8,749.1980	1,030.7406	42
2017-11-19	Central	6,304.4880	-2,572.4962	35
2017-11-19	East	6,968.5290	1,493.4914	29
2017-11-19	South	4,711.1710	945.5052	21
2017-11-19	West	4,452.1610	424.1126	29
2017-11-26	Central	7,945.9000	1,322.2202	26
2017-11-26	East	16,703.1610	1,411.3496	46
2017-11-26	South	3,831.5120	-290.5259	14
2017-11-26	West	7,518.3270	609.3889	40
2017-12-03	Central	5,974.7280	-1,832.5470	32
2017-12-03	East	3,803.8540	495.8022	37
2017-12-03	South	3,077.9680	630.4967	15
2017-12-03	West	8,680.6910	1,370.5868	46
2017-12-10	Central	2,509.2800	-380.2052	18
2017-12-10	East	4,240.2630	1,038.6981	25
2017-12-10	South	1,797.0050	-77.7456	11
2017-12-10	West	3,795.2160	590.6946	31
2017-12-17	Central	4,764.9200	805.7970	21
2017-12-17	East	6,128.4050	1,379.2584	27
2017-12-17	South	5,518.7740	382.9815	21
2017-12-17	West	3,044.9690	412.3032	27
2017-12-24	Central	1,915.3248	113.0758	19
2017-12-24	East	1,947.8310	118.9848	25
2017-12-24	South	3,952.9840	1,239.5292	16
2017-12-24	West	7,394.7460	1,484.0853	23

Create Report (R Markdown)

Weekly Sales by Region

knitr::kable(head(weekly_summary, 10))

week	region	total_sales	total_profit	orders
2013-12-29	Central	304.508	-60.4389	4
2014-01-05	Central	127.702	-61.0441	4
2014-01-05	East	29.476	7.9654	2
2014-01-05	South	4442.490	1371.3749	10
2014-01-05	West	19.440	9.3312	1
2014-01-12	East	402.770	-48.6475	7
2014-01-12	South	1983.150	479.8956	7
2014-01-12	West	1744.613	255.6358	4
2014-01-19	Central	714.556	183.5546	9
2014-01-19	South	1951.842	389.8349	8

ggplot(weekly_summary, aes(x = week, y = total_sales, color =region)) +
  geom_line(size=1) +
  labs(title = "Weekly Sales by Region", y = "Sales ($)", x = "Week")

Profit Trends

ggplot(weekly_summary, aes(x = week, y = total_profit, color = region)) +
  geom_line(size=1) +
  labs(title = "Weekly Profit by Region", y = "Profit ($)", x = "Week")