This repository provides a sample of data analysis work I completed using SQL and includes the following:
Project Name | Tables (csv) | Description |
---|---|---|
Create_a_Table.sqlite | - | Creating my friends table and add/delete data from it! |
New_York_Restaurants.sqlite | nomnom.csv | Finding the best dinner spots in the city. |
Trends_in_Startups.sqlite | startups.csv | Retrieving some interesting insights about the rising trends in the startup world. |
Analyze_Hacker_News_Trends.sqlite | hacker_news .csv | Exploring stories from hacker news Y Combinator website since its launch - 2007. |
Lyft_Trip_Data.sqlite | Trips_Riders_Cars.csv | Practicing Sql joins as a Data Analyst at Lyft, a ride-sharing platform. |
RPA_Fraud_Detection.sqlite | RPA_Fraud_Detection.csv | Helping RPA finance department to identify potentially risky transactions. |
RPA-Customer-Segmentation.sqlite | RPA-Customer-Segmentation.csv | Helping RPA marketing department to segment the company users by a number of different criteria. |
Davie_Burgers_Subway_Ad.sqlite | Davie_Burgers_Subway_Ad.csv | Helping Davie’s Burgers restaurant business to dig into their orders table to see if there is anything interesting in there for a funny tagline! |
The_Metropolitan_Museum_of_Art.sqlite | The_Metropolitan_Museum_of_Art.csv | Exploring the museum’s collection of American Decorative Arts. |
Cryptocurrency_Exchange.sqlite | Cryptocurrency_Exchange.csv | Helping Fiddy Cent digital currency exchange company to analyze their January ledger data using SQL aggregate functions. |
Welp.sqlite | Welp.csv | Exploring Welp places and reviews tables using Sql. |
Reddit.sqlite | Reddit.csv | Exploring Reddit platform with a focus on the users, posts and subreddit tables. |
VR-Startup-Company.sqlite | VR-Startup-Company.csv | Analyzing Virtual Reality (VR), Inc. current talent pool to ensure each project can be completed efficiently and effectively. |