Bootcamp Analytics Engineer

This repository is for the Analytics Engineer bootcamp. The idea of this bootcamp is create a data warehouse layer with DBT and Google BigQuery.

Introduction of database Northwind Traders (OLTP)

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

Northwind Traders Entity-Relationship Diagram (ERD)

Requirements of business processes

Sales overview

• 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

Sales agent follow-up

• Track sales and performance of each sales agent to adjust commissions, reward high performers and empower low performers

Product inventory

• 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.

Customer report

• 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.