Consumer Tool Dashboard

	C	D	E	F	G	H	I	N	O	P	S	T	U	V	W	X
1
2
3
4	The data showcased in this dashboard is not authentic. It consists of fictitious data that I've utilized to illustrate the structure of the real dashboard and the methodology behind the data analysis process I employed.
5
6
7
8
9		Mortgage Calculator									Account Comparison Tool
10
11
12
13
14			Year	Detractors	Passives	Promoters	NPS Score
15			2022	8%	8%	8%	8%
16			2023	9%	69%	19%	9%
17												Year	Promoters	Passives	Detractors	NPS Overall
18												2022	38%	48%	8%	38%
19												2023	19%	69%	9%	19%
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36	Consumer Suggestions and Compliments								Consumer Suggestions and Compliments
37
38
39
40	Feedback Category	Feedback Subcategory	% of Occurence					Feedback Category	Feedback Subcategory	% of Occurence
41	Data Fields	Want to enter bank credit protection information	1%					Result Presentation	Missing new credit unions	4%
42		Want to enter fixed vs. variable interest rate	4%						Missing online-only banks	6%
43		Want to enter the start of mortgage	6%						Want to see comprehensive account benefits	18%
44		Want to enter 2+ prepayment frequency	7%						Want to select a # of results to display	13%
45		Want to enter insurance provider	11%					Navigation	Have to scroll too much to compare results	22%
46		Want to enter downpayment	16%						Unclear how to go back to filter section page	12%
47	Result Presentation	Found report presentation clear/comprehensive	0%					Ease of Use	Easy to use	19%
48		Understood better the implications of different interests	0%					Search Visibility	Hard to find the tool using Google	4%
49		Present principal and interest amount as sum	1%
50		Liked information tooltip	1%
51		Liked easy-to-understand graphs	3%
52		Liked comprehensive summary report	4%
53		Want to specify the year to view in a summary table	6%
54		Use real dates to communicate payment dates	9%
55	Ease of Use	Easy to use	15%
56	Calculation	Don't calculate interest using 2-decimal place interest rate	1%
57		Want calculation formula	7%
58	Save Option	Want to save in PDF/spreadsheets	0%
59		Lked having a 'print' button directly on website	2%
60		Liked being able to 'share' summary table via email	2%
61		Liked being able to download in PDF	2%
62