Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You will create views based off of your kaggle dataset for the purpose of data visualization ie, One view which provides totals, another one

 

You will create views based off of your kaggle dataset for the purpose of data visualization ie, One view which provides totals, another one which provides averages, another can list a table of data (please be creative as this will vary per person). https://kb.tableau.com/articles/howto/connecti ng-to-mysql-views You will use these views in Tableau to create a visual representation of your data. Screenshots of your dashboards will be added to the assignments area. https://www.tableau.com/learn/articles/business- intelligence-dashboards-examples You will create a stored procedure based on your view which accepts a parameter. This parameter will be accepted by Tableau. https://help.tableau.com/current/pro/desktop/e n-us/changing-views-using-parameters.htm You will create a MariaDB/MYSQL data backup which will be uploaded to the assignments area. This backup must contain your views, stored procedures, databases and tables to be graded. Detaset Member numbes Date Item Description tropical fruit whole melic pip freit 1808 2552 2300 21-07-2015 05-01 -2015 19-09-2015 whole vegetables ralls I buns 187 12-12-2015 o1-02-2015 3037 4941 4501 3801 2762 419 14-02 08-05-2015 23-12-2015 2015 other vegetables pot plahts pot whole milik 20-03-2015 12-02-2015 2-02-2o15 14-0~2015 21-07-2015 03-09-2015 troppcal meit cPtnes theit frist beet 1340 2193 7 franicfurter chicken 4546

Step by Step Solution

3.48 Rating (158 Votes )

There are 3 Steps involved in it

Step: 1

A view is the sql statement that can contain entire table that is stored in the database To create a ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Statistics The Art And Science Of Learning From Data

Authors: Alan Agresti, Christine A. Franklin

3rd Edition

9780321849281, 321755944, 321849280, 978-0321755940

More Books

Students also viewed these Programming questions

Question

What is meant by formal organisation ?

Answered: 1 week ago

Question

What is meant by staff authority ?

Answered: 1 week ago

Question

Discuss the various types of policies ?

Answered: 1 week ago

Question

Briefly explain the various types of leadership ?

Answered: 1 week ago

Question

List the conditions for making an election to split gifts.

Answered: 1 week ago

Question

Describe the limitations on the deduction of transfers to charity.

Answered: 1 week ago