Customer Analytics Dashboard in Power BI | MS Forms | Google Forms | Power BI Dashboard

Показать описание

✔ Link to download the Excel data file for Practice:

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:

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:

Recommended Playlist:

Be sure to follow the links to stay in touch:

✔ Share this Video:

#customerexperience
#powerbi
#powerbidashboard
#dashboard
#leanexcelsolutions
#powerbitutorials

Рекомендации по теме

Комментарии

Thank you very much, your projects are excellent to learn and practice. Keep it up. Greetings from Chile.🤗

waldoh

Valoro todo lo que nos compartes abrazos maestra 🇲🇽👍🤝

grijalvaescobedo

Hello, and many thanks for the video. When merging the Feedback table with the Rating Range table (at 18:19 in the movie), the selection matches with 15583 rows out of 15584. As a result, there is a null value in one row that is not visible after merging. In the data, I saw a null value. Kindly provide guidance on how to resolve this.

Deepthi-ym

Nice tutorial, would have been great if you provided the icons used.

rochellerobinson

Hey, I cant find option likert on google form. Are they "delete" this option?

ernaldi

hi have question..how many dashboards can we create in one project

bnavatha

Thanks!! Im getting blank in the slicer list
Can anyone help me out

sembhaiamman

At 19.35 sec General and feedback not connected in my case after close and apply 😢

mdmozammil_

By loading ID column it's giving from 1 . How home in video it's showing from 594. Please reply

karthikawarrier

I don't have power bi. I would very much like to follow this build though.

billgyrotech

How do I do this method in word at 1:20 minute?

msmrd

Hi thanks a lot. Just checking, I might be wrong. Isn't the measure NPS Detractors % supposed to be with General[NPS Rating]<7, instead of General[NPS Rating]<8? Thanks again, success!!!

joseluismartincenjor