Course Blog on Data Analytics

Hi all, this is the last lecture we will have, please see slides here.

Hi all,

Please see the lecture notes for tomorrow’s class here.

Please see slides here.

Please download the lecture notes here.

Please see lecture notes for dimensional modeling here.

The pivot table example spreadsheet can be downloaded here.

Also there is a dataset I generated from database of Amazon (indirectly of course):

from amazon.com (run scripts to get a dimensional csv file)

to this

to this

and to this for analysis.

Then we can use our statistical and mathematical knowledge to analyze the dataset as we want (e.g., cluster analysis, regression analysis, etc.)

Hi, Please find the lecture notes (slides) for MySQL 2 here.

I will try to post lecture notes before class.

Hi All,

Please find slides for MySQL 1 here.

Hi all,

We might touch on MySQL workbench tomorrow if we have time.

Please see slides here.

Kevin