CRM dashboard using google sheets

CRM dashboard for total gross profit and total transactions

revenue comparison between 2016,2017

revenue by regional office (central , east ,west)

opportunity stage analysis (won vs lost )

revenue trend over time

most profitable and top-performing sales agents

the main challenge was building relations between four different tables and creating a professional dashboard that supports business decision-making