Відео

​@@Natnatnatnatnatnatnat Thank you for the encouragement 🙏

@@user-tv6dx6no9oGlade this helps

@@user-tv6dx6no9o Glade this helps.👍 All the best with your project

Hi Doreen Probably, at the Home tabe in Power Query Editor, you did't select the "close and load" option. The dialog box that appear for you option to select how you what you want to do with the data from power query edit will only appear if you did select "close and load" option when loading your data from the power query editor. Could you reload the data to power query editor and proceed accordingly with the "Close and load" option. Should you need further assitance you can reach out to me via email to understand the issue and how I can assist. msurveypoint@gmail.com

Yes i did click the "close and load" ... but it didn't show the "pivot table report"

Can you check if you did have a column named ID in your survey data? The ID column can be any column that column with entries that uniquely identifies each respondent or data entry in your data like telephone number, student Id number, survey submission Id, etc. You can use any similar column in your data that uniquely identifies each respondent. If not captured, you can add this manually in excel (insert column in your data table and number each row from 1, 2, ...n) or in power query using the Index feature from 1,... (Add column>>Index column....)

Yes. However, here the standard Chi-Square test is not appropriate since there is within group dependency as respondents had the option to select more than one item in each of the multiple response questions. Marginal Chi-Square test is recommended in this case.

Yes, you can apply slicers to the analysis table. Click anywhere in the table: Under the Pivotable Analyze table at the top.... Select Insert Slicer... Select the Unpivoted Data table.... Check the respective variable (like age group, gender, region, etc) for your Slicer and Okay. If you have other pivot tables created from your main Data Table in the model... Insert the Slicer from that... Then establish relationship or connect that table to the Unpivoted Data Table using the ID column.

Could you check if the new data is showing in your source data table in power Bi? before the duplicated table. If it is showing, you may consider unpivoting directly in that table. Maybe the duplicated table is not calling the new data from the updated source data table

Entries in the ID column are unique identifiers for each respondent in your survey. Could be autogenerated by the survey platform, contact numbers of respondents, student/staff Id, etc. If you do not already have such a column in your data, you can add a custom column in your data (before Loading to power query): 1. Insert a column in your data table. Usually should be first or second column. Ensure that column is your table with features of a table. 2. Number you respondents starting from 1, 2 , 3.....n. If you already generated pivot table. You can Refresh All to get the Id in your data model. Then you can use the column in your analysis as in video Alternatively, use the custom column Id feature in power query to do that; ideally before unpivoting

Hi Juliana You should see that once you load your data to power query. Not sure. But should be available in Excel 2016 and later

Thanks for the feedback. Noted. I will add this up in my upcoming videos

Thanks for your feedback. Happy to know this helps.

Glade to hear you found it helpful.

He sounds Ghanian

Agreed, I mentioned it in the video. You can first split into columns, then unpivot. But that will also still give you multiple rows. That is why we count by Distinct. Unfortunately, I am yet to find any better & efficient way to go about this without getting multiple rows. For some reason, the multiple rows have nearly no impact on analysis as far as you count by Distinct. I am curious to know why stacking the data doesn't work for you.

​@@MSurveyPoint I have a column 'Total Sales" - 10000, Country = "India,China, Japan". After creating multiple rows the sum(total Sales) is giving me 10000* 3 = 30000. Earlier it was just giving 10000 This is just an examoke

@@Rehan________________khan582 I understand your concern. But since you are adding to data model, the data will be stored in power query. Power query can handle as many rows there are unlike excel spreadsheet which has 1m rows limitation. Only the speed of the data processing may be affected subject to your PC's capability. Like in the video, I got 50k+ rows and still proceeded speedly. Check this video I explained this for Excel and possible precautions. ua-cam.com/video/WjmTNEmfJ2s/v-deo.html

@@MSurveyPoint how do I get the sum of column for distinct ID? In a measure?

Since the value column is numeric and you want total sales for each country: You will use Show values as Average. to take care of the multiple rows.

Thanks for the feedback. Glad to hear that helped. Subscribe to stay updated

Thanks for the feedback. Happy to know this helped. There are always more than one way to represent data, depending on the story you want to communicate with the data. And the format of the final output of your analysis/report: word, PPT, infographic, dashboard, etc. For percentages like we have in the video, and which part of the scale is most important to you; other considerations are 1. Table: well formated, sorted or key numbers highlighted. etc. as 2. Conditional formatting, highlighting high & low scoring. 3. Single column bar chart , focusing on the top 2 scores( Etc.

Hi Godfred From 8:10 onwards Can you check if you selected "Close and Load to data model" from the Power Query Editor? Check also if the "add to model was checked" in the add to data model dialog box.

@@MSurveyPoint Yhyh...I did but it doesnt allow me to check the add this data to data model

The ✅ is enabled depending on the option you select at the top; pivot chart, connection only, etc. It will be automatically selected and grey out for some options. Can you check that. Also, are you able to proceed to generate a pivot table or chart and do your analysis? Lastly, you may consider starting over and following steps in the video closely

Hi Tinah Happy to hear this helped. Subscribe to stay updated

Thanks for letting me know. On the surface, you can generate a chart from the pivot table, move to your dashboard and link to other charts via a slicers. You can book my calendar for tomorrow to align on what you want to achieve and how I can support.

@@MSurveyPoint I tried to do that but the slicer was not responding. Let me send you an email

@@norahmutale4391 Alright. Sounds good

Hi Nora. Glade you find it helpful. This could be what you are looking for. ua-cam.com/video/ODtWvSKUSIo/v-deo.html Do subscribe to support my channel

Glad you found it helpful

You can apply the same approach. But here, One way is to: >>Select the set of statements for topic 1 and unpivot like in this video. You can name the attribute column as Topic 1_statements. >>In the same table, select the set of statements for topic 2 and do the same >>Repeat for the rest of the topics you have. Caution: Your model could be come bigger with this approach (number of rows could run into millions because of the several unpivoting) Alternatively, >Duplicate your data for each of the topics >>Then apply the previous steps for each separately. >>You may name each table for example _Topic 1_Company culture >>Afterwards you the load all the tables into your data model. And proceed with your visualization like in the video. I hope this helps. Do remember to subscribe to support my channel

@@MSurveyPoint thank you very much, finnaly i have solution now

@@arthautami9999 Glade this helped

Thanks for sharing your feedback Glade to hear this helps.

Thank you for the feedback. Happy to know this helps. Kindly support my channel by sharing with your team. Thank you

Thanks for the feedback. I am glad you found it helpful. I will continue to share more relevant videos. Best regards

You're welcome!

This is inspiring to hear. Thank you for the feedback

Glad you like them!

Glad you found this helpful!

Thanks for the feedback. Ideally, the surveys alone only help you understand & estimate customer attitudes and their likely behaviours this could influence (E.g. A customer who feel you care about them vs competition could be more likely to repurchase or recommend others to you). To some extent surveys can help you estimate the proportion of your customers who feel positively about your brand and their intention to repurchase, However, their action to actual repurchase in the future could change and is driven by so many factors - including past purchase patterns & behaviours. So to effectively predict who would return and who is likely to churn, you will need to consolidate the survey data with the Operational data of your customers (like past purchases, amount, frequency of purchases,....etc. that) 1. Then build a model using these covariables to predict the retention probability of each customer. Note: Not all your customers will ever share their feedback. So you will need to apply the appropriate missing data approach for those who do that have survey data points. 2. Or do cohort/cluster analysis that help you identify the common behaviours of customer who are likely to return or churn. 3. Using this insights you can then tailor communications or target the right customers with the appropriate messaging or resolve the issues that could be driving their decision to churn...... and maintain what is driving retention behaviours Lastly as new customer data come in and more customer data gather, you can keep updating the model accordingly as it trained on additional data

Me alegro que esto haya ayudado

I'm so glad this helps.

Glad this helps, Faith.

Encouraging to hear this helped.

Okay. Check back on the custom column you created (LikertscaleSortOrder). You probably assigned two values for one likert scale response. That is two conditions were created for the same Likert scale response. You need to remove one, if that is the case. The right assignment should be E.g: using 1-5 points Strongly disagree=1 Disagree=2 Neutral=3 Agree=4 Strongly agree=5 Each Likert label response to take only one value

@@MSurveyPoint I have the same problem, and have the correct orders from 1-5. Do you know of another potential solution to the problem?

​@@andreathorsheim2621Same here. Even tried a different approach with a dimension table of responses with the response text as the primary key and a unique constraint on the order value. There is no way there are duplicates and yet here we are...

Glade this helps

Hi Shamera, Probably you didn't add your data to the Data model. When you closed and load from Power query, and in the dialog box that come the "add data to the data model ✅" needs to be selected (if not automatically selected) for the distinct count feature to enabled. Please check that.

Hi Ali Melli. I have covered videos for those cases separately. You can check them out below. Once you get around that, you can repeat (in the same table) like I covered in this video if you need to crosstabulate two multiple response questions. Subscribe to support my work 1. 1/0: ua-cam.com/video/kdeT4O01nmU/v-deo.htmlsi=rOg3GyiO-OroCZuO 2. yes/no: ua-cam.com/video/_e_RX4e2Y5w/v-deo.htmlsi=O2sgUNq08hqgju9p

thank you so much@@MSurveyPoint

by excel and power bi

Here is the Power Bi version for the Yes/no ua-cam.com/video/9cTQ3vUWh4k/v-deo.htmlsi=Om7mKL9oMmZ8k-jP I haven't covered the 1/0 version for Power Bi yet. But you can apply the same steps in Power Bi

Should you need further assistance, you can connect with me Email: msurveypoint@gmail.com Book appointment here 👉 calendar.app.google/MMasAbZPDuwCCux76 1. Survey questionnaire design 2. Online survey scripting 3. Survey data Analysis 4. Research report writing 5. Data analysis in Excel 6. Survey Dashboard in Excel 7. Survey Dashboard in Power Bi The scope of my services includes but not limited to the areas of Market Research, Customer Experience Research, Product Research, User Experience Research, Employee Engagement Surveys, NPS, CSAT & Voice of the customer, Monitoring & Evaluation, etc.

Yes, >>click anywhere in the column you want to sort the statements by (Eg. Strongly agree) >>right click>sort>descening order This will arrange the statements from Most strongly agreed to least strongly agreed

Glad to hear it helps

@@MSurveyPoint Great help thank you. the difference is i have longer questions.

Okay. You can book my calendar here to go through your data: Book appointment here 👉 calendar.app.google/MMasAbZPDuwCCux76

Okay. I will upload this tomorrow in the Power Bi playlists. You may like to subscribe to be notified when I upload it In the meantime you can check out the recent video on Likert scale survey data in Power Bi ua-cam.com/play/PLoR189xZ0hCMfW7rP0o_lI3BnH8QJ0VuD.html&si=FfffIJqk8vMnU3UI

@@MSurveyPoint Thank you for fast response , I've turned on notifications bell too.

Hi Ndlovu Here is the link to the video. I hope this helps ua-cam.com/video/9cTQ3vUWh4k/v-deo.html

Thanks for the feeeback. I am glade this helps. Please subscribe for more.