Which book is least preferred by the readers? What are the most popular books in each city? SQL Project Idea: Use the dataset to answer the following questions: Create a sample dataset of your favorite books by noting the following details for each book in a table: Book_ID, Book Name, Publisher, ISBN, Edition, Number of pages, Sales, City, and Price. Work on this project and set up a virtual bookstore with your favorite books.ĭataset: Imagine you run a chain of bookstores. Recall your school days, you must have come across various books, out of which a few must have become your favorites. Here we have a fun project for beginners in SQL. Also, use aggregate functions to rank the different teams. Use ORDER BY, GROUP BY, and LIMIT commands to analyze the data of various teams and their players. As per the values, use specific JOIN command to combine the tables. Display various tables using the SELECT command in SQL to look at values stored in the tables. SQL Project Idea: Use the dataset to create a database in SQL. Team_Attributes: It contains various columns that reflect each team’s performance.īuild a Review Classification Model using Gated Recurrent Unit View Project Team: It contains teams’ names (short and long), and their IDs for API and FIFA. Player_Attributes: It has various parameters like rating, potential score, preferred foot, etc., for each player to highlight their overall performance. Player: It has Players’ names, height, weight, birth date, FIFA ID, and API ID. The information is specified using the unique ids of the other three tables: Country, League, and Team. Match: It contains performance metrics of various players for different league matches. League: It contains the specific titles of the sports events/league matches. It contains the following tables:Ĭountry: It contains the list of countries where the games are played and their unique ids.
DATA ANALYSIS PROGRAMS HIVE DEDUCE DOWNLOAD
This SQL project will guide you through the application of the query language for understanding the dataset at an aggregated level.ĭataset: Download this European Soccer Game Dataset from Kaggle. If you are a soccer fan and enjoy analyzing trends in sports teams, this project is for you.
How was the weather during the year of highest sales?Ĭonclude whether the weather has an important impact on sales.ĭo the sales always rise near the holiday season for all the years?Īnalyze the relationship between sales and the different macroeconomic variables in the dataset. to answer the following sample questions: After that, use SQL commands like order by, group by, etc.
SQL Project Idea: You can use the dataset to create a database in SQL. You will also have access to weather and holidays data for the same years. It also includes a file containing macroeconomic parameters like GDP, CPI, cotton production, unemployment rate, etc. The dataset contains Walmart store sales (Year, Month, Product Category, and Sales) for 2009-2014. Data Analysts use SQL to build an inventory management system to help business owners make critical decisions related to inventory planning.ĭataset: As an example, you can use this Walmart Dataset on Kaggle.
DATA ANALYSIS PROGRAMS HIVE DEDUCE FREE
Get FREE Access to Data Analytics Example Codes for Data Cleaning, Data Munging, and Data Visualization Inventory Managementįor any product-based business, keeping track of all the items in their inventory is critical.
0 kommentar(er)
