Data Warehouse using Python - Repost - open to bidding
₹1500-12500 INR
Closed
Posted over 6 years ago
₹1500-12500 INR
Paid on delivery
Datasource
[login to view URL] /[login to view URL]
Download monthwise *[login to view URL] 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
[login to view URL]
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