Closed

Data Warehouse using Python - Repost - open to bidding

Datasource

[url removed, login to view] /[url removed, login to view]

Download monthwise *[url removed, login to view] files for the years 2009 to 2017.

Dimensions – Time, ASN, People, GDP, Location

Concept Hierarchy

Time – month < quaterly < year

ASN - AS pool > Allocated ASs > Advertised Ass

People – users < population

GDP

Location - Region > Country

Region = { AFRINIC, APNIC,ARIN,RIPENCC,LACNIC}

List of countries in each reagion can be found in

[url removed, login to view]

Perform the following OLAP operations

1. Construct a datacube using the dimensions Time=quaterly, ASN =

{AS pool, Allocated Ass, Advertised Ass}, People = {users,

population}, GDP, Location=country where country=India

2. Construct a datacube using the dimensions Time=yearly, ASN =

{AS pool, Allocated ASs, Advertised ASs}, People = {users,

population}, GDP, Location=Region where Region = { AFRINIC,

APNIC,ARIN,RIPENCC,LACNIC}

sample data for cross reference when you download the data from

given url

Skills: Big Data Sales, Hadoop, Python, Spark, SQL

About the Employer:
( 2 reviews ) KADAPA, India

Project ID: #16007203

1 freelancer is bidding on average ₹50000 for this job

₹50000 INR in 3 days
(5 Reviews)
3.8