/SQLProject_Apple_Store_Apps

Deeper Exploratory data analysis with my own SQL queries after following initial Guided Video

SQLProject_Apple_Store_Apps

Part 1: Exploratory data analysis

SQL USED: I imported the data using SQLite online per the guided video of LoreSoWhat in YouTube.
Queries: I followed the SQL queries from the video here

DATA SOURCE: Dataset link courtesy of LoreSoWhat google drive folder

Part 2: Exploratory data analysis using my own questions

USING MY OWN SQL QUESTIONS THAT SPARKED MY CURIOSITY
Further analysis of the Apps to beat based on previous exploratory analysis and assumptions for the App Developer:

  • PAID apps that have top user ratings among top 5 categories from previous analysis
  • If App developer still wants to develop games, what are the games to beat
    • based on paid, user_rating, cont_rating, etc.

SQL USED: DB Browser for SQLite
Queries: I created my own queries in this sql file
Findings: The sheet named "Non-Guided_SQL_Questions" has the outputs from the Queries I made. excel file - Click 'View raw' to Open the file online

Many thanks to @LoreSoWhat for encouraging us to create our own queries based on the queries that he started.