Applied Intelligence Assignment help, Applied Intelligence homework help
Getting online help for Applied Intelligence assignments was never so easy as our Applied Intelligence experts offer instant & 24*7 sessions in order to assist students with complex problems & Applied Intelligence Assignment help. Send assignment at support@webassignmenthelp.com or else upload it.
Applied Intelligence homework help
Get the instant help for Applied Intelligence homework . Our Applied Intelligence homework help tutors offer 24*7 homework assistance. Connect to website chat anytime 24/7 to get instant Help on Assignments Homework and Projects.
Business Intelligence Analyst Exercise
Instructions/Notes:
- State your assumptions when you solve each problem.
- Please try to give an approximate time that it took you to solve each portion of the exercise.
- Be aware that there may be multiple ways to solve the questions.
1) Visualize the following data and identify any areas you think would require further investigation, with explanation as to why.
|
DateTime
|
Player1ID
|
Player2ID
|
Player1Score
|
Player2Score
|
|
5/27/2015 1:00
|
1121
|
1451
|
200
|
250
|
|
5/27/2015 1:01
|
1121
|
1451
|
250
|
260
|
|
5/27/2015 1:02
|
1121
|
1451
|
300
|
270
|
|
5/27/2015 1:03
|
1121
|
1451
|
400
|
200
|
|
5/27/2015 1:04
|
1121
|
1451
|
1000
|
260
|
|
5/27/2015 1:05
|
1121
|
1451
|
300
|
300
|
|
5/27/2015 1:06
|
1121
|
1451
|
200
|
205
|
|
5/27/2015 1:07
|
1121
|
1451
|
100
|
400
|
|
5/27/2015 1:09
|
1121
|
1451
|
100
|
300
|
|
5/27/2015 1:10
|
1121
|
1451
|
200
|
200
|
|
5/27/2015 1:11
|
1121
|
1451
|
200
|
250
|
|
5/27/2015 12:00
|
6013
|
4215
|
50
|
300
|
|
5/27/2015 12:01
|
6103
|
4215
|
350
|
200
|
|
5/27/2015 12:02
|
6193
|
4215
|
400
|
100
|
|
5/27/2015 12:03
|
6283
|
4215
|
50
|
450
|
|
5/27/2015 12:04
|
6373
|
4215
|
800
|
100
|
|
5/27/2015 12:05
|
6463
|
4215
|
50
|
200
|
|
5/27/2015 12:06
|
6553
|
4215
|
300
|
100
|
|
5/27/2015 12:07
|
6643
|
4215
|
250
|
200
|
|
5/27/2015 12:08
|
6733
|
4215
|
100
|
450
|
|
5/27/2015 12:09
|
6823
|
4215
|
50
|
400
|
|
5/27/2015 12:10
|
6913
|
4215
|
0
|
100
|
|
5/28/2015 15:00
|
2013
|
1121
|
197
|
332
|
|
5/28/2015 15:01
|
2013
|
1121
|
386
|
396
|
|
5/28/2015 15:02
|
2013
|
1121
|
151
|
104
|
|
5/28/2015 15:03
|
2013
|
1121
|
156
|
361
|
|
5/28/2015 15:04
|
2013
|
1121
|
712
|
341
|
|
5/28/2015 15:05
|
2013
|
1121
|
235
|
290
|
|
5/28/2015 15:06
|
2013
|
1121
|
252
|
381
|
|
5/28/2015 15:07
|
2013
|
1121
|
298
|
350
|
|
5/28/2015 15:08
|
2013
|
1121
|
342
|
310
|
|
5/28/2015 15:09
|
2013
|
1121
|
223
|
361
|
|
5/28/2015 15:10
|
2013
|
1121
|
152
|
172
|
For the following three questions, you will need to use a dataset that was collected by the Pew research center on teens and video games in 2008. The data set is in the attached file.
The fields in the dataset that you will need to use for these are in parentheses below. Please note that we are not asking you to pull the data, only to show queries you would use.
Using this dataset, write a SQL query that would show us the frequency of respondents of each education (educ), race (race), and income level (income) group as well as the average and median age (age) of those groups of the people who said that their teens play games (playgame).
Write a SQL query to count the number of respondents who mentioned Mario Kart as one of their top 3 games (k17game), the number of respondents who mentioned Guitar Hero, and the number of respondents who mentioned Halo 3. How would you go about determining the number of respondents who listed fewer than 3 games for this question?
Write a SQL query that will return only the records from the most frequently seen state (state) in the datset. Your query should be able to test for what the most frequent state is before using that information to narrow down your dataset to only responses from that state.
3. What’s wrong with these visualizations and how would you fix them or revisualize them?
