This data engineering blueprint examines a salesperson’s performance using CRM data. This data engineering project has a real-world application when a sales manager wants to know if their salespeople are meeting their targets with the leads they have received. The company can use lead forecasts as input to a report. The report can then, over time, optimize operations like contact and planning capacity.
The big data stack used in this data engineering project is as follows:
1. Azure Blob storage for historical files from the CRM.
2. Stitch ELT to orchestrate data ingestion.
3. Google BigQuery as a Datawarehouse.
4. Power BI dashboard to display and drill down the predictions.