WGU D326 - TASK 1 DATA Analysis (Passed) Performance Assessment:Advanced Data Management (CSN1) Latest update

Summarize one real-world written business report that can be created from the DVD Dataset from the “Labs on Demand Assessment Environment and DVD Database” attachment. This business report aims to identify the most popular movie categories among customers each month. It is purposed to provide insights into customer preferences and trends allowing the business to optimize its inventory and marketing strategies. 1. Identify the specific fields that will be included in the detailed table and the summary table of the report. Variable name Description Will Gging into a detailed/summary table Category_na m e Movie category Which database table the data come from Detailed and Summary Category Category_id Category ID Detailed Film_id Category Film ID Detailed Film_title Film Film title Detailed Rental_id Film Rental ID Detailed Rental_date Rental Date of rental Detailed Inventory_id Rental Inventory ID Detailed Customer_id Inventory Customer ID Detailed Summary Customer Rental_month Month of rental date, transformed by Rental_date Rental Rental_year Year of rental date , transformed by Summary Rental Rental_date Number_rental Aggregate column, count of rental_id Summary Rental 2. Describe the types of data fields used for the report. The types of data fields used for the report include: 1. Category_name: VARCHAR(25), this field represents categorical data stored as a string type, identifying the movie category. 2. Category_id: INTEGER, this field represents numerical data stored as a ) unique integer type, identifying the category id that refers to the category name. 3. Film_id: INTEGER, this field represents numerical data stored as a unique integer type, identifying the film id that refers to the film name. 4. Film_title: VARCHAR(255), this field represents textual data stored as a string type, containing the title of the movie. 5. Rental_id: INTEGER, this field represents numerical data stored as a unique integer type, identifying the rental id that refers to the rental record. 6. Rental_date: TIMESTAMP, this field represents date and time data stored as a timestamp data type, indicating the date and time the movie was rented. ) 7. Inventory_id: INTEGER, this field represents numerical data stored as a unique integer type, identifying the inventory id that refers to the film id. 8. Customer_id: INTEGER, this field represents numerical data stored as a unique integer type, identifying the customer who rented the movie. 9. Rental_month: INTEGER, this field represents the date, like the rental_date but only with the month part, for aggregation by the months. 10. Rental_year: INTEGER, this field represents the date, like the rental_date but only with the year part, for aggregation by the years. 11. Number_rental: INTEGER, this field represents numerical data stored as an integer type, indicating the count number of rentals for each category in each month, for aggregation.