Пікірлер
@canepazzoTannen84
@canepazzoTannen84 13 күн бұрын
Thank you so much sir. You spared me a lot of work and time. For some reason, I do not have the "PivotTabel Report" Option at 4:26 but I can only import it as "Table". However I found a workaround as I can then transform it into a Pivot. It's just important to tick "Add this data to the Data Model" when creating the Pivot from the Table as otherwise it won't allow "Distinct Count" later on.
@nathalinalmeida
@nathalinalmeida 14 күн бұрын
How can I show 0% results in table? There questions with only negative responses and these questions don't are visible in table. Thank you so much
@MSurveyPoint
@MSurveyPoint 14 күн бұрын
Hi @@nathalinalmeida Thank you for feedback. Could you please clarify your question? I am not sure I get it. Alternatively you can connect with via email to better assist you.
@emmanuelaigbomian5976
@emmanuelaigbomian5976 20 күн бұрын
Much appreciated man, but can you analyze likert quantitative data like this using MATLAB?
@jessiki5711
@jessiki5711 Ай бұрын
your videos are great! but I have one issue, if I go to "close & load to" it only shows me in the window of Import Data "Table" and "Only Create Connection". How can I get the option for "Pivot Table Report"?
@MSurveyPoint
@MSurveyPoint Ай бұрын
@@jessiki5711 This could happen depending on the Excel version. You can still create Pivot Tables from there anyway. However, with few additional steps From there.... Select create connect and check; add to data model. .. wait for it to load Now proceed as follows Insert>Pivot Tables>External connect>Select Unpivoted or data table you loaded>>add>Ok Then create your pivot table
@joyhardy2467
@joyhardy2467 Ай бұрын
Hi, Thank you so much for this video. I have a multiple choice question in which most responses are blank for every option. This results in the grand total being less than the total number of survey respondents Is there a way to get the % of the total number of survey respondents without manually adding a formula? I am using MS Excel 2016.
@MSurveyPoint
@MSurveyPoint Ай бұрын
@@joyhardy2467 Do you get the reduced total after you filtered the Blank label in the rows of the pivot table? If you don't have Blank label (or if had not filtered it out at all) but the total is still less than expected: Do this 1. Go back to power query 2. Before you Unpivot; 3. And an index column (starting from 1....). Let's name it Dummy 4. When selecting columns to Unpivot, add the Dummy column too 5. Then Unpivot . However, this will result in many values when you do crostab. 6. So you need to filter out the dummy label in the rows of your pivot table. Alternative to the long list of values in the dummy column: 1. Add a conditional column: Name Dummy column 2. Condition: If ID is not equal to 0 return 1 else return 0 3. That way will will only have 0 or 1 in your dummy column. Let me know if this helps If this doesn't help, you can send me an email to connect and understand the issue better
@joyhardy2467
@joyhardy2467 Ай бұрын
Hi, Thank you so much for this video. I have a multiple choice question in which most responses are blank for every option. Is there a way to get the % of the total number of survey respondents without manually adding a formula? I am using MS Excel 2016.
@joyhardy2467
@joyhardy2467 Ай бұрын
Adding to my previous question. This situation results in the grand total being less than the total number of survey respondents.
@ahmedabdulahimahamud3272
@ahmedabdulahimahamud3272 Ай бұрын
Very helpful and supportive to me. Can you please help powerBi analysing a full survey data. Descriptive data analysis in PowerBI
@MSurveyPoint
@MSurveyPoint 26 күн бұрын
Thanks for the feedback. Will add this up in my content plan.
@gostudy2377
@gostudy2377 Ай бұрын
you have saved me from rewriting all my data! thank you very much, sir!
@dajanabushpepa4389
@dajanabushpepa4389 Ай бұрын
why do you unpivot, an not only Data - Sapparete from comma - Select data to appear in rows - Transform Trim - And add to data model?
@MSurveyPoint
@MSurveyPoint Ай бұрын
@@dajanabushpepa4389 That's another way to o handle it. I have used that approach too in a separate video. Thanks for the reminder
@vinamwa
@vinamwa Ай бұрын
Good day. I am having trouble pasting the data back into my Excel sheet; the Import Data dialog is not popping up.?//?
@ian-th7rd
@ian-th7rd Ай бұрын
Hi...I´m following along...at 17:34 on "Values" you left the "Top-2-box score"....should it be Bottom-2-box score....just to make sure if it was a mistake or i'm missing something...Thanks!
@MSurveyPoint
@MSurveyPoint Ай бұрын
Thanks for this. Missed that. The column label should have been Bottom-2-box too as the tittle. Values are Bottom-2-box, anyway.
@tamandanichimguba9766
@tamandanichimguba9766 2 ай бұрын
one of the best videos i have ever watched
@andrewtirtawijaya5627
@andrewtirtawijaya5627 2 ай бұрын
Hi bro, thanks for the video. One question, what if i have couple of question with multiple answer (3 question with multiple answer) what is the best way so pivot table can work just fine? Thanks.
@andrewtirtawijaya5627
@andrewtirtawijaya5627 2 ай бұрын
Bro, thanks for the video. But can you help me how if i have not only one question with multiple answer but 3 question that have multiple answer. Can you advise me what is the best way to sort the data so i can use pivot table correctly?
@MSurveyPoint
@MSurveyPoint 2 ай бұрын
@@andrewtirtawijaya5627 Check this video From 3 minutes on kzbin.info/www/bejne/jYmYmX-Fm6hkiJIsi=mYS4jfkmDtUL3NKb
@MSurveyPoint
@MSurveyPoint 2 ай бұрын
@@andrewtirtawijaya5627 Another option is to Unpivot each of them in the same table as I have done here for comma separated. But be careful as with this option for large sample sizes and with many columns as I have mentioned in the video
@MSurveyPoint
@MSurveyPoint 2 ай бұрын
@@andrewtirtawijaya5627 If you still support, you can send me an email [email protected] Note that a small consultation fee is applied for an hour session. All the best
@homsnour641
@homsnour641 2 ай бұрын
Thank you so so much, it is very helpful
@MSurveyPoint
@MSurveyPoint 2 ай бұрын
Glad it was helpful!
@siobhanpoulter455
@siobhanpoulter455 2 ай бұрын
Many thanks for this it is sooooo helpful :)
@MSurveyPoint
@MSurveyPoint 2 ай бұрын
Glad it was helpful!
@jaunitaekuehettah1254
@jaunitaekuehettah1254 3 ай бұрын
Hey dear I have an assignment would you be able to help me ?
@MSurveyPoint
@MSurveyPoint 3 ай бұрын
@@jaunitaekuehettah1254 Hi Jaunita, Thanks for reaching out. Send me an email below with details of your requests. Please add timeline. Connect with me if you need support on the following services Email: [email protected] 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.
@HoneyBadgerJAB
@HoneyBadgerJAB 3 ай бұрын
Thank you very much!
@Data4Transformation
@Data4Transformation 3 ай бұрын
Bosu, why did your individual percentages sum up to more than 100%?
@MSurveyPoint
@MSurveyPoint 3 ай бұрын
@@Data4Transformation In multiple response questions, total number of responses will mostly be more than the total number of respondents since each respondent could select more than one response item. So sum of percentages (of the number of respondents) will be more than 100% Others however, often mistakenly divide by the total number of responses and get 100% which they go further to wrongly interpret the results. For example saying 20% of the respondents.... when the percentage is not based on the number of respondents. So, the earlier is the correct way to treat multiple response questions.
@MSurveyPoint
@MSurveyPoint 2 ай бұрын
@Data4Transformation Find the explanation in this video. You may want to check it out kzbin.info/www/bejne/g6PPd6OZjLWpjMU
@boblynnamanyire2274
@boblynnamanyire2274 3 ай бұрын
Hello Msurveypoint. using the same example, I want to see the analysis for how many own only, how many own at least 2, how many own 4 and how many own 5 types of gadgets.
@MSurveyPoint
@MSurveyPoint 2 ай бұрын
@boblynnamanyire2274 Check this recent video on this: kzbin.info/www/bejne/a4OyoJaNocd6j9k
@boblynnamanyire2274
@boblynnamanyire2274 3 ай бұрын
I've watched this video over and over again and it's surely helpful.
@MSurveyPoint
@MSurveyPoint 3 ай бұрын
@@boblynnamanyire2274 Happy to know this is helpful. Thanks for the feedback
@lawrencekazibwe9751
@lawrencekazibwe9751 3 ай бұрын
Thanks alot boss,it has been very informative 🎉
@MSurveyPoint
@MSurveyPoint 3 ай бұрын
@@lawrencekazibwe9751 Glad this helped. Thanks for the feedback
@anaisyanlap7360
@anaisyanlap7360 4 ай бұрын
Thankyou so much
@Natnatnatnatnatnatnat
@Natnatnatnatnatnatnat 4 ай бұрын
Thank you very much for this. It is very useful for someone with no experience in working with survey data! Please keep making more 🙏🏻
@MSurveyPoint
@MSurveyPoint 4 ай бұрын
​@@Natnatnatnatnatnatnat Thank you for the encouragement 🙏
@asifkhan-k3m3c
@asifkhan-k3m3c 5 ай бұрын
much appreciated , I was looking for two to three hours to find out the satisfactory and unsatisfactory order alignment in pivot tables in power bi
@MSurveyPoint
@MSurveyPoint 5 ай бұрын
@@asifkhan-k3m3cGlade this helps
@MSurveyPoint
@MSurveyPoint 5 ай бұрын
@@asifkhan-k3m3c Glade this helps.👍 All the best with your project
@doreen2536
@doreen2536 5 ай бұрын
Hello, in my case when i import the data it only shows an option for Table and Only create connection ... The option for Pivot table report doesn't show up What should i do about this 🥲
@MSurveyPoint
@MSurveyPoint 5 ай бұрын
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. [email protected]
@doreen2536
@doreen2536 5 ай бұрын
Yes i did click the "close and load" ... but it didn't show the "pivot table report"
@aniaaaaaa15
@aniaaaaaa15 5 ай бұрын
Very helpful video! Thanks
@MSurveyPoint
@MSurveyPoint 2 ай бұрын
Glad it was helpful!
@soni_b535
@soni_b535 6 ай бұрын
Thank your for your helpful video but for some reason my ID column isnt showing on the pivot chart? What did i do wrong?
@MSurveyPoint
@MSurveyPoint 6 ай бұрын
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....)
@PoulamiDatta-fm1oq
@PoulamiDatta-fm1oq 6 ай бұрын
can I do chi square of this multiple response survey data ??
@MSurveyPoint
@MSurveyPoint 6 ай бұрын
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.
@MSurveyPoint
@MSurveyPoint 6 ай бұрын
Connect with me if you need support on the following: 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 Email: [email protected] Book appointment here calendar.app.google/MMasAbZPDuwCCux76 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.
@MSurveyPoint
@MSurveyPoint 6 ай бұрын
Connect with me if you need support on the following: 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 Email: [email protected] Book appointment here calendar.app.google/MMasAbZPDuwCCux76 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.
@samanthagaulin1921
@samanthagaulin1921 7 ай бұрын
Is there a way to use a slicer with this method?
@MSurveyPoint
@MSurveyPoint 6 ай бұрын
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.
@Buloyskie
@Buloyskie 8 ай бұрын
Why my unpivoted data is not updating everytime I refresh with mew data. My data source if from excel.
@MSurveyPoint
@MSurveyPoint 8 ай бұрын
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
@samuelbaidoo1267
@samuelbaidoo1267 8 ай бұрын
Can you share the sample data with me?
@windibukit1412
@windibukit1412 8 ай бұрын
Hello, after I did Transform-Unvipot selected coloumn-home-pivot table report. I cannot find ID to put on values. Did I miss something?
@MSurveyPoint
@MSurveyPoint 8 ай бұрын
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
@julianasimte3712
@julianasimte3712 8 ай бұрын
Is the close and load to pivot an option available only on certain devices?
@MSurveyPoint
@MSurveyPoint 8 ай бұрын
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
@patriciaejindu
@patriciaejindu 8 ай бұрын
Thank you for the great tutorial. It was exactly what I was searching for. How would you go about visualising results of the statements by key survey metrics such as by organisational unit, region, country, function, age, gender etc? It would be great to see a tutorial around these.
@MSurveyPoint
@MSurveyPoint 8 ай бұрын
Thanks for the feedback. Noted. I will add this up in my upcoming videos
@jasunikanaparthi96
@jasunikanaparthi96 8 ай бұрын
thankyou
@MSurveyPoint
@MSurveyPoint 8 ай бұрын
Thanks for your feedback. Happy to know this helps.
@wiszewska890
@wiszewska890 8 ай бұрын
Thank you, random Indian guy. You saved my life. Again.
@MSurveyPoint
@MSurveyPoint 8 ай бұрын
Glade to hear you found it helpful.
@judahokonkwo3866
@judahokonkwo3866 6 ай бұрын
He sounds Ghanian
@Hussainiat_news__Channel
@Hussainiat_news__Channel 8 ай бұрын
This creates multiple rows due to which the column which has numbers got added multiple times. Do you know any other way..?
@MSurveyPoint
@MSurveyPoint 8 ай бұрын
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.
@Hussainiat_news__Channel
@Hussainiat_news__Channel 8 ай бұрын
​@@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
@MSurveyPoint
@MSurveyPoint 8 ай бұрын
@@Hussainiat_news__Channel 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. kzbin.info/www/bejne/jZvQhYF7ost9aNU
@Hussainiat_news__Channel
@Hussainiat_news__Channel 8 ай бұрын
@@MSurveyPoint how do I get the sum of column for distinct ID? In a measure?
@MSurveyPoint
@MSurveyPoint 8 ай бұрын
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.
@VideoChick666
@VideoChick666 9 ай бұрын
So helpful thank you
@MSurveyPoint
@MSurveyPoint 9 ай бұрын
Thanks for the feedback. Glad to hear that helped. Subscribe to stay updated
@rij17
@rij17 9 ай бұрын
Thankyou so much for this video. it is extremely helpful, you explained it very nicely! Wanted to ask if there are also other ways to represent the linkert scale, other than 100% Bar chart and Column chart, please let me know, thanks again.
@MSurveyPoint
@MSurveyPoint 9 ай бұрын
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.
@godfredamoako9177
@godfredamoako9177 9 ай бұрын
Please, I can't add to the data model. How do I go about it
@MSurveyPoint
@MSurveyPoint 9 ай бұрын
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.
@godfredamoako9177
@godfredamoako9177 9 ай бұрын
@@MSurveyPoint Yhyh...I did but it doesnt allow me to check the add this data to data model
@MSurveyPoint
@MSurveyPoint 9 ай бұрын
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
@tinah426
@tinah426 9 ай бұрын
Thank you so much for the great work done!
@MSurveyPoint
@MSurveyPoint 9 ай бұрын
Hi Tinah Happy to hear this helped. Subscribe to stay updated
@norahmutale4391
@norahmutale4391 10 ай бұрын
Thank you for directing me to this video. I have used this video many times but I want to link the responses to a respondent as i am building a dashboard. when i try to link the chart to the dashboard it does not connect to the slicers
@MSurveyPoint
@MSurveyPoint 10 ай бұрын
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.
@norahmutale4391
@norahmutale4391 10 ай бұрын
@@MSurveyPoint I tried to do that but the slicer was not responding. Let me send you an email
@MSurveyPoint
@MSurveyPoint 10 ай бұрын
@@norahmutale4391 Alright. Sounds good
@norahmutale4391
@norahmutale4391 10 ай бұрын
this video is great, however how do i create a a cross tab (pivot table) that shows all likert scale components? for example english proficiency of reading, writing, speaking and understanding rated from poor - good
@MSurveyPoint
@MSurveyPoint 10 ай бұрын
Hi Nora. Glade you find it helpful. This could be what you are looking for. kzbin.info/www/bejne/hXXXiKmJgLqGf9E Do subscribe to support my channel
@arthautami9999
@arthautami9999 10 ай бұрын
Thank you so much, this video is really help me But i wanto to ask : How to process satisfaction survey data if i use some domain, for example Topic 1 : Statement 1 Statement 2 Statement 3 Topic 2 : Statement 1 Statement 2 Statement 3 etc. And then i want to visualisation based on topic. Could you give me an answer or tutorial video, please 😊😊
@MSurveyPoint
@MSurveyPoint 10 ай бұрын
Glad you found it helpful
@MSurveyPoint
@MSurveyPoint 10 ай бұрын
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
@arthautami9999
@arthautami9999 10 ай бұрын
@@MSurveyPoint thank you very much, finnaly i have solution now
@MSurveyPoint
@MSurveyPoint 10 ай бұрын
@@arthautami9999 Glade this helped
@heyzutube
@heyzutube 10 ай бұрын
you've saved my day
@MSurveyPoint
@MSurveyPoint 10 ай бұрын
Thanks for sharing your feedback Glade to hear this helps.
@zephirosl8073
@zephirosl8073 10 ай бұрын
This video was very helpful for me, thank you very much!!!
@MSurveyPoint
@MSurveyPoint 10 ай бұрын
Thank you for the feedback. Happy to know this helps. Kindly support my channel by sharing with your team. Thank you
@NicoleNotarioRisk
@NicoleNotarioRisk 10 ай бұрын
I've come back to your video several times to help me understand something I'm working on. Thanks so much!
@MSurveyPoint
@MSurveyPoint 10 ай бұрын
Thanks for the feedback. I am glad you found it helpful. I will continue to share more relevant videos. Best regards