Skip to content

An R project, which cleans XML data, loads it in a relational database, extracts this processed data, and loads it into a Data Warehouse following a snowflake schema. It then uses this DW for gaining various insights, visualized as graphs.

Notifications You must be signed in to change notification settings

shethmanan/Pubmed-Data-Analysis

Repository files navigation

A 'R' project, which cleans data from XML, stores it in a relational database, extracts this processed data and loads it into a Data Warehouse following a snowflake schema.

1. ERD for relational schema

2. Data cleaning

3. Creating OLTP Database and inserting data

4. OLAP Schema

5. Performing analysis on OLAP database and visualizing them as graphs

About

An R project, which cleans XML data, loads it in a relational database, extracts this processed data, and loads it into a Data Warehouse following a snowflake schema. It then uses this DW for gaining various insights, visualized as graphs.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages