Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You are a data analyst at the Excellent Business School in Boston, and your supervisor has asked you to analyze survey data collected via Qualtrics
You are a data analyst at the Excellent Business School in Boston, and your supervisor has
asked you to analyze survey data collected via Qualtrics in one of the schools Excel courses.
You know the Qualtrics data are messy so you have dedicated time in your busy day to
clean the data using Power Query before you begin to analyze it
Review the survey questions via the Survey Questions worksheet in Part of the
Start File to familiarize yourself with the survey.
Go to the Student Data worksheet. The table shows the results of your survey. To
prove to yourself that the survey data needs to be cleaned, use the table in the Student
Data worksheet to create a pivot table in the worksheet named SurveyPivotBClean.
One of your goals is to analyze the students Hobbies by their Masters program. Using
the fields NetID, Hobbies and Program try to organize the data like the dashboard
shown below. Youll see the survey data doesnt pivot well. Note: any attempt to create
this dashboard will earn you full credit for this step.
Return to the Student Data worksheet. To clean up the survey data, Load the table
into Power Query. Rename the query Original Data. Make sure you select My table
has headings when you load the table into Power Query. You should have rows
and columns.
Now that you have loaded the survey data into Power Query, you can begin the data
cleaning process:
a Remove the first row of data in the Original Data query so that the row
with the survey questions numbers, ie Q Q is no longer in the
query. Hint Try using the Remove Rows option.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started