This repository is for the Analytics Engineer bootcamp. The idea of this bootcamp is create a data warehouse layer with DBT and Google BigQuery.
The Northwind database is a sample database created by Microsoft. The database contains all sales data from Northwind Traders, a fictitious specialty food export and import company. The Northwind database is an excellent tutorial schema for a small-business ERP, with customers, orders, inventory, purchasing, suppliers, shipping, employees, and single-entry accounting. For this bootcamp I used a MySQL version of the Northwind sample database which can accessed with this link: http://github.com/dalers/mywind
- General sales reports to better understand our customers what is being sold, what sells more where and what sells less, the objective is to have an overview of how the business is doing
- Track sales and performance of each sales agent to adjust commissions, reward high performers and empower low performers
- Understand current inventory levels, how to improve inventory management, which suppliers we have, how much is being purchased. This will allow you to understand inventory management and potentially negotiate better deals with suppliers.
- Enable customers to understand their purchase orders, how much and when they are buying, empowering them to make data-driven decisions and use the data to unite their sales data.