OLAP Operations using Data Cube - 01/01/2018 06:54 EST
₹1000-2000 INR
Imefungwa
Imechapishwa about 6 years ago
₹1000-2000 INR
Kulipwa wakati wa kufikishwa
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
BI platform & business modelling
If you need the solution on a permanent basis (one or more users in the group) my cloud based solution could be the right one for you.
1) Powerful OLAP based BI platform accepting data from different sources via ETL module (data adjustments).
2) Robust, secure, modular and fully scalable business modelling.
3) Business model adjustable to the end-user needs; multilingual.
4) Supporting all four stages of a business cycle: planning-reporting-analysing-adjusting.
5) Bigger/more complex the organisation/model, bigger our value added.
6) Pre-designed (e.g., “what if”) and on the fly analysis included.
7) Win and full mobility - iOS, Android.
You can use it (1) inside our DB in cloud; (2) more demanding business models can be set-up in their own DB in our cloud or (3) set up separate DB in separate cloud (highest costs).
Details and demonstration on request.
Best way would be to show you in live web session via TV, Skype or similar. Let me know.
@RMC