✔ Link to download the excel data file for Practice: https://leanexcelsolutions.com/customer-analytics-dashboard-in-power-bi/
✔ Link to download the complete dashboard from Store:: https://leanexcelsolutions.com/product/customer-analytics-dashboard-in-excel/
The purpose of this tutorial is to demonstrate how to create an interactive customer analytics dashboard in Microsoft Excel using data from MS Forms or Google Forms.
Additionally, we will demonstrate how to use power query and power pivot in Excel to design the dashboard.
Learn more about What is Net Promoter Score? And how it is calculated.
Timestamp:
00:00 Introduction
00:54 Net Promoter Score
18:20 General Rating
22:24 Source of Information
25:15 Purpose of Visit
29:47 Source Trend
Recommended Videos from Tutorials:
✔ How to create an Excel Dashboard with Power Query and Power Pivot? | Tutorial 01: https://youtu.be/J-m0HePOxOY
✔ Customer Analytics Dashboard in Power BI: https://youtu.be/0mwToWeybS0
Learn more:
✔ Sales Dashboard in Power BI: https://youtu.be/CGgXHsD19Ek
✔ Sales Distribution Dashboard in Power BI: https://youtu.be/C-Cvaqmchq0
Recommended Playlist:
✔ Excel Dashboard: https://youtube.com/playlist?list=PLYjYcSjCw_LVDPyjNfCrlryE7i6sklJ7T
✔ Sales & Marketing Dashboard: https://youtube.com/playlist?list=PLYjYcSjCw_LVe8dNqdE3u_KVWIdAecvXH
Check the Links:
◼ Channel: https://www.youtube.com/c/LeanExcelSolutions
◼ Channel: https://youtube.com/@LeanExcelSolutions
◼ Website: https://leanexcelsolutions.com
◼ Facebook: https://www.facebook.com/LeanExcelSolutions/
◼ Instagram: https://www.instagram.com/leanexcelsolutions/
✔ Share this Video: https://youtu.be/PkTPec30ttA
#powerquery
#excel
#exceldashboard
#dashboard
#leanexcelsolutions
#customerexperience
