Business Scenario
The Analytics team of a pharmaceutical company wants to design a dashboard to analyze the sales of products across various regions and brands. It wants to create a chart with User control functionality, so users can easily see the total Sales and “commission of external agents” categorized by brands and region.
The company’s database keep’s track of following data fields:
Brand Name, Company Name, Disease Medical Use, Invoice date, Company code, Ship-to-Country, Ship-to-Country Full Name, Sold-to party- Code, Sold-to party Country, Sold to party Country Full Name, Delivery Plant, Payment terms, External Agent, Sales quantity, Price TC /Kg, Revenue, External commissions, Month.
Overview
Attached is the dataset and the business Scenario for your Reference