✔ 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 the Store: https://leanexcelsolutions.com/product/customer-analytics-dashboard-in-powerbi/
The purpose of this tutorial is to demonstrate how to create an interactive customer analytics dashboard using Power BI using data from MS Forms or Google Forms.
From the initial setup in MS Forms or Google Forms to designing a highly visual and interactive dashboard in Power BI.
Learn more about What is Net Promoter Score? And how it is calculated.
Join this channel to get access to perks:
https://www.youtube.com/channel/UC_B0oWPRDqkXqDJkMBv6jkA/join
Timestamp:
00:00 Introduction
01:20 Set up survey in MS Forms
08:30 Share & collect Feedback online
11:40 Set up survey in Google Forms
13:05 Overview of Input Data
15:05 Import data to Power BI
15:45 Data transformation in Power Query Editor
19:50 Setup Dashboard Background
21:30 NPS calculation using the columns & measures
23:17 Add Visuals to Dashboard
25:58 Set-up Dashboard Theme
27:27 Format Visuals
34:50 Organize Visuals
36:54 Overall Rating Visualization
41:52 Dashboard formatting
44:01 Dashboard Header Section
Recommended Videos:
✔ Sales Dashboard in Power BI: https://youtu.be/CGgXHsD19Ek
✔ Sales Distribution Dashboard in Power BI: https://youtu.be/C-Cvaqmchq0
✔ Merge Shapes in PowerPoint: https://youtu.be/-W1AAfu5Xe0
Recommended Playlist:
Sales & Marketing Dashboard: https://youtube.com/playlist?list=PLYjYcSjCw_LVe8dNqdE3u_KVWIdAecvXH
Be sure to follow the links to stay in touch:
◼ 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/
◼ Pinterest: https://www.pinterest.ca/leanexcelsolutions/
◼ LinkedIn: https://www.linkedin.com/company/lean-excel-solutions
✔ Share this Video:
https://youtu.be/0mwToWeybS0
#customerexperience
#powerbi
#powerbidashboard
#dashboard
#leanexcelsolutions
#powerbitutorials
