Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 below

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions