Call Me Back

Just leave your name and phone number. We will call you back

Name : *  
Phone No : *  
Email : *  
Message : *  
support@webassignmenthelp.com

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?

 

upload assignment homework