Quarterly Sales Performance - Maven Tech [Finalist]

Gerard Duggan Avatar

Gerard Duggan

KBR

Quarterly Sales Performance - Maven Tech [Finalist]

Power BI Quarterly Dashboard

Additional project images

Gerard Duggan Avatar

Gerard DugganKBR

More projects by Gerard

The Race to the Top of the World [Winner]

17 Likes

0 Comments

MTA Post-Pandemic Ridership Trending Report

21 Likes

4 Comments

Network Rail Journey Analysis [Finalist]

26 Likes

11 Comments

Discussion and feedback(16 comments)

comment-1158-avatar

Luis Alberto Méndez

about 1 year ago

As always, outstanding and inspiring, at this time you should be an invited judge in the challenge.

comment-1183-avatar

Omar Mokhtar

about 1 year ago

Clean & useful.

comment-1186-avatar

Rob Stover

about 1 year ago

Are you open to sharing some of the measures used to calculate the filtered measures for team vs region vs all KPIs as well as conditionally formatting the agent colors?

comment-1188-avatar

Gerard Duggan

Project owner

about 1 year ago

Project owner

Yes, sure Rob. I'll try and get some time to update the write up to include some of the generic calculations

comment-1206-avatar

Vince McSkimmings

about 1 year ago

Great work Gerard, and thanks for including the DAX! I can see myself referring back to this as a resource in the future! :)

comment-1232-avatar

ehasan shakib

about 1 year ago

This report/dashboard provides valuable insights that are highly beneficial for managers.

comment-2751-avatar

ATOLAGBE JAMIU ADEBAYO

3 months ago

Thank you for sharing.

comment-2882-avatar

Nguyễn Hòa

about 15 hours ago

Thank you for sharing such a detailed and insightful dashboard — it has been incredibly valuable for my learning. I truly appreciate the effort you've put into making this accessible for others. At the moment, I'm having some difficulty replicating one of the calculations — specifically, the Average Variance from RRP. My current approach is to calculate the percentage variance using this formula and I already filter this calculation by "Won" deals and certain Quarter Period: (SalesPrice - CloseValue) / CloseValue * 100 Then, I average these percentage variances. However, my result doesn't match what you've shown on your dashboard. Would you mind sharing your method for calculating this metric? I'd greatly appreciate any guidance you can provide.