Answered step by step
Verified Expert Solution
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 ...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