Excel Survey Analysis: Use Power Query to find the Top 5 game features
Автор: csvkarl
Загружено: 2025-12-29
Просмотров: 385
Let's use Power Query in Microsoft Excel to analyze a survey about a game and identify the top 5 features gamers actually care about👩💻
📚Process
Step 1 → Select your table→ Data → From Table → Advanced Editor
Step 2 → Copy and Paste Query
Step 3→ Done → Close & Load
✨Query Breakdown
1st Line → Let' begin our query
2nd Line → 'Source' grabs your data from the specific table you're analyzing
3rd Line → ChangedType' converts your scores and votes into proper numbers to prevent calculation errors
4th Line → Sorted' arranges your features from highest score to lowest.
5th Line → Ranked' adds position numbers. The '1, 1' means start at one and increase by one for each row.
6th Line → Top5' keeps only the first five rows
7th Line → In Top5' closes your query
💬 Let me know in the comments section if it worked for you
📲 Share with a friend who also wants to improve their Excel skills
💚 Level up your Excel game and your career. Hit the plus for weekly tutorials
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
