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, Hadoop, Python, Spark, SQL

See more:

About the Employer:
( 2 reviews ) KADAPA, India

Project ID: #16007203

2 freelancers are bidding on average ₹52778 for this job

₹50000 INR in 3 days
(5 Reviews)
3.8
infoastra

I can complete with your every need I have well experience along with Big Data as well as with Python Scripting We can provide easy and available solutions to your need But the project cost will be a bit more as th More

₹55555 INR in 10 days
(0 Reviews)
0.0