QUESTION #1.
Download the dataset www.bit.ly/srm-ba-athlete-dataset and perform the
following
a. Frequency analysis
b.
Find the
correlation between County and Gold Medals
c.
Find the
correlation between Sport and Total Medals
2.
Download the dataset www.bit.ly/srmbasalesdataand perform the following using
OLAP method
a.
Find out the total sales
Region wise
b.
Find out the average units
sold of the item “Pencil”
c.
Find out the average sales
by the representative “Jones”
d.
Find out the item wise
total sales
--------------------------------------------------------------------------------------------------------------
QUESTION #2.
1.
Do the sentimental
analysis for the E-Commerce websites.
2.
Download the dataset www.bit.ly/srmbasalesdatacreate minimum of 5 Pivot tables
--------------------------------------------------------------------------------------------------------------
QUESTION #3.
1.
Download the dataset www.bit.ly/srm-ba-athlete-dataset and perform the
following
a. Frequency analysis
b.
Find the
correlation between County and Gold Medals
c.
Find the
correlation between Sport and Total Medals
2.
Download the dataset www.bit.ly/srm-ba-athlete-datasetcreate minimum of 5 Pivot tables
--------------------------------------------------------------------------------------------------------------
QUESTION #4.
1.
Create the blog for your
family and integrate with Google analytics
2.
Create the sentimental
analysis for Employment portals
--------------------------------------------------------------------------------------------------------------
QUESTION #5.
1.
Download the dataset www.bit.ly/srm-ba-athlete-datasetand perform 3 Chi-square tests
2.
Download the dataset www.bit.ly/srmbasalesdataand perform necessary correlation
analysis
