Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You can do everything with excel Or you can learn Knime to profile data Or python. The assignment involves you doing the following work on
You can do everything with excel Or you can learn Knime to profile data Or python.
The assignment involves you doing the following work on the data set shared with you in the attachment; 1- Examining the data set and evaluating the examination results; a. Understanding the dataset: The first step in EDA is to understand the dataset. This should include the size of the dataset, data types, variable names, and whether there is any missing or incorrect data. b. Data cleaning: If there is missing or incorrect data in the dataset, you need to clean it. This may include removing or correcting missing or inaccurate data from the dataset. 2- You should start preparing the assignment in a power point presentation, starting with the work done in the first article. 3- You need to create tables according to the 3rd Normal Form (3NF) setup using the data set. 4- You are expected to model the created tables by establishing two of them as in the example below; Figurel 1 - Sample 3NF Modelling View 5- You need to create 2 sample visualization studies using the data set and add them to the presentation. 6- You need to explain the work you have done above in the relevant slide and add details to the presentation. 3- The data you will use for the assignment is in the excel document belowStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started