Skip to content

ETL online sales data into analytical DB for forecasting, reporting, and further analysis

Notifications You must be signed in to change notification settings

leaflettuce/tdwpDB

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

45 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

tdwpDB

Goals

1 - Collect and aggregate unit sales of tour merchandise into a mySQL database.
2 - Analyze historic sales trends to forecast sales and enhance stock mgmt.
3 - More accurately predict merchandise sales for tour budgeting.

Overall Process

1 - Collect data (internal, scrapers, etc.)
2 - Generate features 
3 - store processed data into mySQL
4 - EDA FTW
5 - Explore models
6 - Report findings and methods of implementation

Loading Data

(1) upload new data files from atvenue into appropriate _data/raw/_ dirs.
	|--> summaries from _report/tour summary_ 
	|--> sales from _report/sales report_ 
	|--> daily from _tours/shows/completed_
		|--> (NOTE) New tours require creation of new 'daily' cleaner!

(2) RUN src/data/**process_data.bat**

(3) RUN src/features/**generate_features.bat**

About

ETL online sales data into analytical DB for forecasting, reporting, and further analysis

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published