Skip to content
Clickstream data analysis for a fictitious financial news media company, performed in Python and SQL
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
graphics
.gitignore nicer schema doc Oct 14, 2018
README.md schema rendering fix Oct 14, 2018
click-rate-analysis.ipynb clean up Apr 21, 2018
clickstream-analysis-writeup.pdf
parse-log.sql clean up Apr 21, 2018
requirements.txt

README.md

A clickstream data analysis for a ficticious financial news media company, performed in Python and SQL.

Full report can be read here. IPython Notebook containing analysis code is here.

Database Schema

Database Schema *=Primary Key

** Clicks table created from parsed raw clickstream data for client, using this SQL query. All other tables provided in clients content database.

You can’t perform that action at this time.