Question: HELP WITH THIS The Scenario: The Google Apps database stores many of the apps developed for android smart phones and the corresponding reviews associated with
The Scenario: The Google Apps database stores many of the apps developed for android smart phones and the corresponding reviews associated with the apps. The database can be created by running the following script: Create_Google.sql The Request: You are working for an independent third-party company that is determining for Google the current app hits and flops, as well as aggregated data for apps being developed and deployed for the Android platform. You have preformed the data analysis in the previous assignment. In this assignment you will be taking the data and creating visualizations to present the data. The visualization can be an infographic, a chart, a word cloud, or some other representation that will present the data in a meaningful and visual way. Requirements and Information: 1. Provide a visualization for the highest rated apps with a user rating of at least 4.6, have at least 1000 reviews, and does not have a content rating of 'Everyone'. 2. Provide a visualization for the total number of apps for each of the 6 content rating categories. 3. Provide a visualization for the top 3 highest rated 'TOOLS' apps that have more than 225,000 reviews. Also, include at least 1 positive review for each of the top 3 apps in the visualization
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
