/Sales_Agent_Tracker

sales agent analysis with tableau dashboard

Primary LanguageJupyter NotebookMIT LicenseMIT

Wizard Mart

Sales Analytics

The Wizard Mart have expanded into the USA and their busniss model involves placing Sales Agents in every state in the USA. These sales agents are responsible for briging in sales for the state that they are assigned to.

The Sales Manager wants a dashboard to track how Sales Agents are doing. He wants it to be comparable where he selects a timeframe this year (Ex. Jan - March 2021) and he wants sales data for the same period last year.

Additionally, he wants a breakdown of sales per category and subcategory as well as the top performing products.

To achive this goals, this project must to contain

  • Dataset clean and explore
  • Dynamic dashboard using as a filter the date selection between 2018-2021 and the sales agent name
  • Sales per Month Graph
  • Annual Sales
  • Sales by Sales Agent and their Top Products sold
  • Sales per Category and Sub-category

  • The dashboard is available on Gabb-tableau Tableau