Project title: Business insights of User usage records of data cards
Software: Hadoop 1.1.2, Hive,Sqoop,Tableau
Hardware:5 node cluster.
Project short description: Aim of this project is finding the business insights of current user records data. And get the benefits for business growth. The parameters to be considered for analysis are
- Daily user count and bytes transmitted on a particular time slot.
- Area wise business(usage) share in the total business
- Since every network owner will be depending on partners to get the service where they does not have the service tower.
From case1: We can find the exact what time more users using the network and what time more downloads and uploads happening. Based on that, they can concentrate tower capacity enhancements. If the tower is underutilized then they can reduce the tower capacity.
From case2: They can concentrate the area where they can invest more to get the more users.
From case3: Find out the areas of partner leading and try to improve the owner tower installations.
All above activities currently happening using data warehousing technologies. But it is more expensive and time consuming. To help better in this area, we are using the Hadoop and Hadoop Echo systems.
SOFTWARE AND HARDWARE
HARDWARE REQUIREMENT FOR EACH NODE/MACHINE IN A CLUSTER
Processor : Intel
Speed : 2.5 GHz
RAM : 8 GB or More
Hard Disk : 500 GB or More
Operating System : Linux
Technology : Hadoop
Reporting Tool : Tableau
Database : My SQL
Java Version : JDK1.6 or Higher version