🇧🇷 Este projeto consiste em um CRM de vendas que gera valor através de dados e Inteligência Artificial, ao qual está dividido em três partes:
🇺🇸 This project consists of a sales CRM that generates value through data and Artificial Inteligence, which is divided into three parts:
- 📃 CRM Project
- 📁 DBT Project 📌
- 🤖 AI Project
🇧🇷 Contém o dbt do banco de dados, utilizando de uma arquitetura medalhão para limpar os dados.
🇺🇸 Contains the database dbt, using a medallion architecture to clean the data.
- Project website: https://pipeline-ai.streamlit.app/
- Project documentation: https://jeperico.github.io/crm-sales/
Dbt is used to do a medallion architecture that clean the data into db views:
- Raw: The origin data, all the db register;
- Bronze: The first version of medallion, where contains all data;
- Silver: The layer where clean all the wrong data;
- Gold Sales for Seller: A totally cleaned view to get the sales data for a specific seller;
- Gold Sales Seven days: A totally cleaned view to get the last seven days sales data;
To install Briefer in your Python project:
pip install briefer
To run Briefer:
briefer
Money per Day:
Sales Quantity per Product:
Sales Quantity per Cost:
Technologies used in this project:
- Briefer: Notebook that transform data into dashboards.
- DBT: See this topic bellow.
- Postgres: The database used.
- Render: The open source host to database.
- Makefile: Used to do prompt shortcuts.