印度移动运营商

随着印度移动运营商数量的增加，分析他们在特定区域的收入、技术和覆盖范围成为了一个绝佳机会。常用的Excel报告也能完成任务，但如果我们能从图数据库中获得更多智能洞察，谁还想用Excel呢？

当前要点中一些尚未实现但可以添加的内容包括使用实际的Neo4j空间图谱来映射实际区域。* 找出某个移动运营商未覆盖的区域，并向其提出建议。* 找出某个移动运营商的竞争对手。* 在时间线上比较某个移动运营商在特定区域的收入。* 扩展模型以包含短信、互联网、通话等收入来源，这将开启另一系列的广泛分析。

目前的域模型如下：* 服务提供商 - Airtel - Vodafone - Idea - TataDocomo - Reliance - MTNL

技术
- CDMA
- EDGE
- HSPA
- GSM
- WiMax
邦/州 -Maharashtra -Rajasthan -Gujarat -Kerela -Punjab -Haryana
收入 -总金额 -同比增长

运营商与区域的映射： - airtel → 马哈拉施特拉邦, 拉贾斯坦邦, 古吉拉特邦, 旁遮普邦, 喀拉拉邦 - vodafone → 马哈拉施特拉邦, 拉贾斯坦邦, 古吉拉特邦 - idea → 马哈拉施特拉邦, 古吉拉特邦, 旁遮普邦 - tatadocomo → 拉贾斯坦邦, 古吉拉特邦, 旁遮普邦, 喀拉拉邦 - reliance → 马哈拉施特拉邦, 拉贾斯坦邦, 古吉拉特邦, 旁遮普邦, 喀拉拉邦 - mtnl → 古吉拉特邦, 旁遮普邦, 喀拉拉邦

运营商与技术的映射： - airtel → edge, hspa, gsm, wimax - vodafone → cdma, edge, hspa, gsm, wimax - idea → edge, hspa - tatadocomo → cdma, edge - reliance → edge, gsm, hspa - mtnl → cdma

使用neo4j/browser的模型图

create (airtel:ServiceProvider { id: "airtel", name:"Airtel", revenue: 10000000, growthYOYPercent: 17})
create (vodafone:ServiceProvider { id: "vodafone", name:"Vodafone", revenue: 2000000, growthYOYPercent: 23})
create (idea:ServiceProvider { id: "idea", name:"Idea", revenue: 15000000, growthYOYPercent: 20})
create (tatadocomo:ServiceProvider { id: "tatadocomo", name:"TataDocomo", revenue: 15600000, growthYOYPercent: 15})
create (reliance:ServiceProvider { id: "reliance", name:"Reliance", revenue: 300000, growthYOYPercent: 3})
create (mtnl:ServiceProvider { id: "mtnl", name:"MTNL", revenue: 60000, growthYOYPercent: -1})


create (cdma:Technology { id:"cdma", name:"CDMA"})
create (edge:Technology { id:"edge", name:"EDGE"})
create (hspa:Technology { id:"hspa", name:"HSPA"})
create (gsm:Technology { id:"gsm", name:"GSM"})
create (wimax:Technology { id:"wimax", name:"WiMax"})


create (maharashtra:State { id:"maharashtra", name:"Maharashtra"})
create (rajasthan:State { id:"rajasthan", name:"Rajasthan"})
create (gujarat:State { id:"gujarat", name:"Gujarat"})
create (kerela:State { id:"kerela", name:"Kerela"})
create (punjab:State { id:"punjab", name:"Punjab"})
with airtel,vodafone,idea,tatadocomo,reliance,mtnl, cdma,edge,hspa,gsm,wimax, maharashtra,rajasthan,gujarat,kerela,punjab


match states=(state:State) where state.id in  ['maharashtra', 'rajasthan', 'gujarat', 'punjab', 'kerela']
create unique (airtel)-[:PROVIDES_SERVICE]->(maharashtra)
create unique (airtel)-[:PROVIDES_SERVICE]->(rajasthan)
create unique (airtel)-[:PROVIDES_SERVICE]->(gujarat)
create unique (airtel)-[:PROVIDES_SERVICE]->(punjab)
create unique (airtel)-[:PROVIDES_SERVICE]->(kerela)
with airtel,vodafone,idea,tatadocomo,reliance,mtnl, cdma,edge,hspa,gsm,wimax,maharashtra,rajasthan,gujarat,kerela,punjab


create unique (vodafone)-[:PROVIDES_SERVICE]->(maharashtra)
create unique (vodafone)-[:PROVIDES_SERVICE]->(rajasthan)
create unique (vodafone)-[:PROVIDES_SERVICE]->(gujarat)
with airtel,vodafone,idea,tatadocomo,reliance,mtnl, cdma,edge,hspa,gsm,wimax,maharashtra,rajasthan,gujarat,kerela,punjab


create unique (idea)-[:PROVIDES_SERVICE]->(rajasthan)
create unique (idea)-[:PROVIDES_SERVICE]->(gujarat)
create unique (idea)-[:PROVIDES_SERVICE]->(punjab)
create unique (idea)-[:PROVIDES_SERVICE]->(kerela)
with airtel,vodafone,idea,tatadocomo,reliance,mtnl, cdma,edge,hspa,gsm,wimax,maharashtra,rajasthan,gujarat,kerela,punjab


create unique (tatadocomo)-[:PROVIDES_SERVICE]->(rajasthan)
create unique (tatadocomo)-[:PROVIDES_SERVICE]->(gujarat)
create unique (tatadocomo)-[:PROVIDES_SERVICE]->(punjab)
create unique (tatadocomo)-[:PROVIDES_SERVICE]->(kerela)
with airtel,vodafone,idea,tatadocomo,reliance,mtnl, cdma,edge,hspa,gsm,wimax,maharashtra,rajasthan,gujarat,kerela,punjab


create unique (reliance)-[:PROVIDES_SERVICE]->(maharashtra)
create unique (reliance)-[:PROVIDES_SERVICE]->(rajasthan)
create unique (reliance)-[:PROVIDES_SERVICE]->(gujarat)
create unique (reliance)-[:PROVIDES_SERVICE]->(kerela)
create unique (reliance)-[:PROVIDES_SERVICE]->(punjab)
with airtel,vodafone,idea,tatadocomo,reliance,mtnl, cdma,edge,hspa,gsm,wimax,maharashtra,rajasthan,gujarat,kerela,punjab


create unique (mtnl)-[:PROVIDES_SERVICE]->(gujarat)
create unique (mtnl)-[:PROVIDES_SERVICE]->(punjab)
create unique (mtnl)-[:PROVIDES_SERVICE]->(kerela)
with airtel,vodafone,idea,tatadocomo,reliance,mtnl, cdma,edge,hspa,gsm,wimax,maharashtra,rajasthan,gujarat,kerela,punjab

create unique (airtel)-[:HAS_TECHNOLOGY]->(edge)
create unique (airtel)-[:HAS_TECHNOLOGY]->(hspa)
create unique (airtel)-[:HAS_TECHNOLOGY]->(gsm)
create unique (airtel)-[:HAS_TECHNOLOGY]->(wimax)

create unique (vodafone)-[:HAS_TECHNOLOGY]->(cdma)
create unique (vodafone)-[:HAS_TECHNOLOGY]->(edge)
create unique (vodafone)-[:HAS_TECHNOLOGY]->(hspa)
create unique (vodafone)-[:HAS_TECHNOLOGY]->(gsm)
create unique (vodafone)-[:HAS_TECHNOLOGY]->(wimax)

create unique (idea)-[:HAS_TECHNOLOGY]->(edge)
create unique (idea)-[:HAS_TECHNOLOGY]->(hspa)
create unique (idea)-[:HAS_TECHNOLOGY]->(gsm)
create unique (idea)-[:HAS_TECHNOLOGY]->(wimax)

create unique (tatadocomo)-[:HAS_TECHNOLOGY]->(cdma)
create unique (tatadocomo)-[:HAS_TECHNOLOGY]->(edge)

create unique (reliance)-[:HAS_TECHNOLOGY]->(edge)
create unique (reliance)-[:HAS_TECHNOLOGY]->(hspa)
create unique (reliance)-[:HAS_TECHNOLOGY]->(gsm)

create unique (mtnl)-[:HAS_TECHNOLOGY]->(cdma)

用例

获取特定邦/州的所有提供商。

match (provider:ServiceProvider)-[:PROVIDES_SERVICE]->(state:State)
return state.name as State, collect(distinct provider.name) as Providers

获取提供商的技术。

match (provider:ServiceProvider)-[:HAS_TECHNOLOGY]->(tech:Technology)
return provider.name as Provider, collect(distinct tech.name) as Technologies

此页面有帮助吗？

GraphGists

印度移动运营商