Use case 2 – sales performance management dashboards

Scenario:

We have a request from sales to create a data model for their analyst team to create interactive dashboards for the worldwide sales organization. The dashboards contain sales of all products and services for every customer, in every channel, and every region. The range of users goes from sophisticated sales analysts to sales representatives who aren’t always tech-savvy.

The data comes from many sources, but the data engineering team has consolidated all sources into a Snowflake database. The data is messy as the company uses different customer relationship management software in different regions of the world. The rules for data entry validation vary wildly, resulting in messy data in some regions and cleaner data in others. The data engineering team does not have the mandate, resources, and time to clean the data. They will leave this cleaning task to a data steward who works with the business. Finally...