You will create views based off of your kaggle dataset for the purpose of data visualization...

 

Transcribed Image Text:

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 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

Answer rating: 100% (QA)

A view is the sql statement that can contain entire table that is stored in the database To create a ... View the full answer