|
|
Line 34: |
Line 34: |
| [[Image:CEM-BANK-Notes.jpg]] | | [[Image:CEM-BANK-Notes.jpg]] |
| | | |
− | === Step 4 - Modify the My Portal complaints overview === | + | === Step 6 - Update diagram shown in monitor site === |
− | | |
− | There is a complaint overview on the My Portal page, which should be sorted <font color="#ff0000">descendingly</font> on the percentages of complaints:
| |
− | | |
− | <font color="#ff0000">CEM Bank Intelligece - Complaints</font><br>[[Image:CEM-BANK-Overview.jpg]]<br><br>Spreadsheet: <font color="#ff0000">CEM Bank Intelligence - Complaints</font>. [[Image:CEM-BANK-Overview-Spreadsheet.jpg]]<br><br>After rebuiling the DCS, the data is now updated, which causes the percentages of complaints to change, we need to sort the rows in the spreadsheet based on their calculated values. When moving the rows, remember to change the expressions in Klager column to have the correct cell references.
| |
− | | |
− | === Step 5 - Update realtime elements (Automated) ===
| |
− | | |
− | | |
− | [[Image:CEM-BANK-realtime.jpg]]
| |
− | | |
− | *Portal elements:
| |
− | **CEM Bank - Realtime kundeklager
| |
− | **CEM Bank - Realtime Market FBI
| |
− | **CEM Bank - Realtime rådgiver input
| |
− | **CEM Bank - Realtime kundeklager - Arbejdernes Landsbank
| |
− | **CEM Bank - Realtime rådgiver input - Arbejdernes Landsbank
| |
− | | |
− | Rebuild the below data caches every week:
| |
− | | |
− | *Data caches:
| |
− | **<span style="color: #ff0000">8386cat - CEM Bank Intelligence - OPEN</span>: gets only data in the last 2 weeks
| |
− | **<span style="color: #ff0000">CEM BANK Intelligence - OPEN - Arbejdernes Landsbank </span>
| |
− | **<span style="color: #ff0000">CEM Bank - Jyske Bank </span>
| |
− | **<span style="color: #ff0000">CEM Bank - Nordea </span>
| |
− | **<span style="color: #ff0000">CEM Bank - Nykredit Bank </span>
| |
− | **<span style="color: #ff0000">CEM Bank - Sparnord Bank </span>
| |
− | **<span style="color: #ff0000">CEM Bank - Sydbank </span>
| |
− | | |
− | === Step 6 - Update diagram shown in monitor site ===
| |
| | | |
| *Path in Monitor: <br>[[Image:Forventninger.png]] | | *Path in Monitor: <br>[[Image:Forventninger.png]] |
− |
| |
− |
| |
| | | |
| *Diagram: <span style="color: #ff0000">8386cat - Årsager til valg af bank, Forventninger (bars) </span> | | *Diagram: <span style="color: #ff0000">8386cat - Årsager til valg af bank, Forventninger (bars) </span> |
Line 77: |
Line 46: |
| *Sort the brands in the previous order (Tips: use export/import feature to save time) | | *Sort the brands in the previous order (Tips: use export/import feature to save time) |
| | | |
− | [[Image:Forventninger (bars) - 2.png]]<br>
| + | [[Image:Forventninger (bars) - 2.png]]<br> |
− | | |
− | <br>
| |
− | | |
− | === Step 7 - Modify the My Portal distribution ambassador score ===
| |
− | | |
− | *There is a distribution ambassador score on the My Portal page, which should be sorted <span style="color: #ff0000">descendingly from the left to the right</span> on the detractors of ambassador score:
| |
− | | |
− | *Portal element: <span style="color: #ff0000">Fordeling ambassadørscore</span>
| |
− | | |
− | [[Image:'Fordeling ambassadørscore' portal element.png]]
| |
− | | |
− | <br>
| |
− | | |
− | *Spread sheet: <span style="color: #ff0000">CEM Bank - Danske Bank - Ambassadørscore </span>
| |
− | | |
− | <br>[[Image:CEM Bank - Danske Bank - Ambassadørscore.png]]
| |
− | | |
− | *After rebuiling the DCS, the data is now updated, which causes the detractors of ambassador score to change, we need to sort the rows in the spreadsheet based on calculated values from Detractors column.
| |
− | | |
− | ''<span style="color: #ff0000">Tip:</span>'' When sorting rows, only move in range of column A to D, keep the order of rows in column E.
| |
− | | |
− | == Expanding steps ==
| |
− | | |
− | These steps will be done every <span style="color: #ff0000">2</span> weeks beside weekly steps.<br>
| |
− | | |
− | <br>
| |
− | | |
− | === Step 1 - Modify NPS/ Kundeklager ===
| |
− | | |
− | Portal element: <span style="color: #ff0000">CEM Bank - Danske Bank - NPS/complaints</span>
| |
− | | |
− | [[Image:CEM Bank - Danske Bank - NPScomplaints.png]]<br>
| |
− | | |
− | Spreadsheet: <span style="color: #ff0000">CEM Bank - Danske Bank - Stay in Bank/Complaints</span>
| |
− | | |
− | [[Image:CEM Bank - Danske Bank - Stay in Bank - Complaints.png]]
| |
− | | |
− | *This diagram needs to be updated every <span style="color: #ff0000">2</span> weeks, a new row of the last couple of weeks will be added to the diagram.<br>
| |
− | | |
− | *There must be always <span style="color: #ff0000">10 </span>weeks data used in the diagram.<br>
| |
− | | |
− | *Week ranges in Detractors and Promoters must be updated.<br>
| |
− | | |
− | === Step 2 - Modify Blive i bank/Personlig kontakt ===
| |
− | | |
− | Portal element: <font color="#ff0000">CEM Bank - Danske Bank - Stay in Bank/Personal contact</font><br>[[Image:CEM-BANK-Skifte bank-innovation.jpg]]<br><br>Spreadsheet: <span style="color: #ff0000">CEM Bank - Danske Bank - Stay in bank - Personal contact</span>
| |
− | | |
− | [[Image:CEM Bank - Danske Bank - Stay in bank - Personal Contact - spreadsheet.jpg]]<br><br>
| |
− | | |
− | *This diagram needs to be updated every <font color="#ff0000">2</font> weeks, the first row in the diagram will be removed, the new row of the last couple of weeks will be added.<br>
| |
− | *There must always be <font color="#ff0000">5</font> rows in the diagram.<br>
| |
− | *Week ranges must be changed in the other columns<br>
| |
− | | |
− | === Step 3 - Modify NPS Udvikling ===
| |
− | | |
− | Portal element:<font color="#ff0000">CEM Bank - Danske Bank - NPS udvikling</font><br>
| |
− | | |
− | [[Image:CEM-BANK-NPS Udvikling.jpg]]<br>
| |
− | | |
− | Spreadsheet: <font color="#ff0000">CEM Bank - Danske Bank - NPS udvikling</font><br>
| |
− | | |
− | [[Image:CEM-BANK-NPS Udvikling - Spreadsheet.jpg]]
| |
− | | |
− | *This diagram needs to be updated every <font color="#ff0000">2</font> weeks, a new row of the last couple of weeks will be added to the diagram.<br>
| |
− | | |
− | *There must be always <font color="#ff0000">10</font> weeks data used in the diagram, which means that there are always <font color="#ff0000">5</font> rows in column A.<br>
| |
− | | |
− | *Week ranges in Detractors and Promoters must be updated
| |
− | | |
− | <br>
| |
− | | |
− | *Update the same for spreadsheets below
| |
− | **<span style="color: #ff0000">CEM Bank - Sydbank - NPS udvikling </span>
| |
− | **<span style="color: #ff0000">CEM Bank - Sparnord Bank - NPS udvikling </span>
| |
− | **<span style="color: #ff0000">CEM Bank - Jyske Bank - NPS udvikling </span>
| |
− | **<span style="color: #ff0000">CEM Bank - Nykredit Bank - NPS udvikling </span>
| |
− | **<span style="color: #ff0000">CEM Bank - Nordea Bank - NPS udvikling </span>
| |
− | | |
− | <br>
| |
− | | |
− | === Step 4 - Modify Forventer sund bankøkonomi ===
| |
− | | |
− | Portal element:<font color="#ff0000">CEM Bank - Danske Bank - Forventer sund bankøkonomi</font>
| |
− | | |
− | [[Image:CEM Bank Forventer sund bankøkonomi.png]]
| |
− | | |
− | Spreadsheet: <font color="#ff0000">CEM Bank - Danske Bank - Sund økonomi</font>
| |
− | | |
− | <font color="#ff0000"></font>
| |
− | | |
− | *This diagram should be updated every <span style="color: #ff0000">2</span> weeks together with the other portal elements.<br>
| |
− | | |
− | *It should contain data of the current <span style="color: #ff0000">4 </span>weeks compared to the last <span style="color: #ff0000">4</span> weeks' data.
| |
− | | |
− | <u>Example<br></u>=(count() where (Participation_week == [<span style="color: #ff0000">200851-200902</span>]) && (Q27_2_SQ_3 == [4,5]) && (Q4==[17]))/(count() where (Participation_week == [<span style="color: #ff0000">200851-200902</span>]) && (Q27_2_SQ_3 == [1-5]) && (Q4==[17]))*100<br><br>=(count() where (Participation_week == [<span style="color: #ff0000">200847-200850</span>]) && (Q27_2_SQ_3 == [4,5]) && (Q4==[17]))/(count() where (Participation_week == [<span style="color: #ff0000">200847-200850</span>]) && (Q27_2_SQ_3 == [1-5]) && (Q4==[17]))*100
| |
− | | |
− | <br>
| |
− | | |
− | *Update the same for spreadsheets below
| |
− | **<span style="color: #ff0000">CEM Bank - Sydbank - Sund økonomi</span>
| |
− | **<span style="color: #ff0000">CEM Bank - Sparnord Bank - Sund økonomi</span>
| |
− | **<span style="color: #ff0000">CEM Bank - Jyske Bank - Sund økonomi</span>
| |
− | **<span style="color: #ff0000">CEM Bank - Nykredit Bank - Sund økonomi</span>
| |
− | **<span style="color: #ff0000">CEM Bank - Nordea Bank - Sund økonomi</span>
| |
| | | |
| [[Category:Production_guidelines]] | | [[Category:Production_guidelines]] |