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
I have More than 5 years in BI and analytics and more than 12 years in IT field.
I have a good level in data analytics and I am motivated to work with you.
I have implemented BI and analytics solutions with the Microsoft Business Intelligence suite of CRM analytics:
• I developed ETL packages with SSIS
• I developed advanced Reports with SSRS and deployed in Sharepoint and also Power BI
• I developed cube with SSAS
• I also developed several data views and reports using Tableau and power BI for analysis needs
• I have also developed and analyzed web analytics reports for eCommerce website
If you need more details, see my resume.
This is an interesting project. I have vast experience in BI, Data warehousing, Data Integration Analysis Services including the development of cubes, and Reporting services.
I very much would like to deliver this project as per the bid.
Thanks for your consideration.
Hello Vinay, Nathan here!
Please accept my proposal as discuss on Upwork!
please set up contract here with the money in escrow
I will arrange my time to do tonight
Sincerely,
Nathan